Brokers are intermediaries between investors and their investment avenues.
An investor may approach the AMC, seeking to invest in its funds, on the basis of guidance received from a broker. Also, an AMC may contract a broker to market its funds and thereby attract investors.
Being an intermediary, a broker usually receives payments either from investors or the AMC, as the case may be. This payment is known as a commission.
Sometimes, brokers do not act as single entities, but as groups of brokers, in hierarchical structures that entail sharing of profits. The commission earned by a broker may not be credited just to the actual broker for the investment transaction, but could also share with other brokers who are part of the same hierarchical structure.
Oracle FLEXCUBE Investor Servicing enables the AMC to maintain records of brokers and their respective hierarchies in the system database, as well as process and maintain details of commission payments to brokers. This chapter deals with all aspects of maintaining brokers, their hierarchies and processing commission payments in the system.
This chapter contains the following sections:
This section contains the following topics:
In Oracle FLEXCUBE Investor Servicing, you can create groups of brokers with common characteristics such as the following:
These group sets are known as broker types. Therefore, a broker type is a set of characteristics such as commission payment frequencies, common consultants and contact details, which you expect to be common to a group of brokers for whom you want to maintain records in the database.
Broker types are typically relevant in the case of brokerage firms with many individual brokers operating under them. They are also relevant in the case of countries where the tax is different based on the broker type, that is, the tax for an individual broker is different from the tax charged from the corporate broker.
To set up a broker type, use the ‘Broker Type Detail’ screen. You can invoke this screen by typing ‘UTDBRKTY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Specify the following mandatory information to set up a broker type:
After you have specified these details, save your changes by clicking the Save button.
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the Broker Type screen.
Broker Type
Alphanumeric; 6 Characters; Mandatory
Specify a unique alphanumeric identifier for the broker type.
Description
Alphanumeric; 255 Characters; Mandatory
Specify the description of the broker type
Distributor ID
Alphanumeric; 12 Characters; Mandatory
Select the ID of the AMC for which you are defining the broker type.
Distributor
Display
The system displays the distributor details for the selected distributor ID.
Broker Consultant
Alphanumeric; 40 Characters; Mandatory
Specify the name of the designated consultant for the broker type.
In this section, specify the frequency pattern for the payment of commission to any of the brokers that would be mapped to the broker type.
Payment Frequency
Mandatory
Select whether a monthly or bimonthly frequency of payment is preferred for brokers under this broker type from the drop-down list. The list displays the following values:
First Payment Date No
Optional
If the payment frequency you have indicated for the broker type is monthly, indicate the date of every month on which the commission payment is to be processed for brokers under this broker type, by choosing the appropriate day of the month from the list.
If the payment frequency you have indicated for the broker type is bimonthly, indicate the date of every month on which the first commission payment is to be processed for brokers under this broker type, by choosing the appropriate day of the month from the list.
Second Payment Date No
Optional
If the payment frequency you have indicated for the broker type is bimonthly, indicate the date of every month on which the second commission payment is to be processed for brokers under this broker type, by choosing the appropriate day of the month from the list.
This value must be higher than the one you selected in the First Payment Date No. field.
Last Working Day
Optional
Select if the commission payment for brokers mapped to this broker type must be processed on the last working day of the month from the drop-down list. The list displays the following values:
In this section, specify the means of communication with the main brokerage firm that represents the broker type. You can access this section by clicking the Contact Details link.
You can specify at least two addresses, and designate one as the default mailing address to be used for correspondence with the brokerage firm, and the other as the alternate address. Specify the default address under the Default Address head, and the alternate address under the Alternate Address head.
You can also maintain the SWIFT Address for the main brokerage firm of the broker type, in the SWIFT Address tab.
Address Type
Mandatory
Select the type of address from the drop-down list. The list displays the following values:
Address Lines 1-2
Alphanumeric; 80 Characters; Optional (Address Line 1 is Mandatory)
Specify the postal address that is to be used for correspondence with the main brokerage firm for this broker type.
City/ Address Line 3
Alphanumeric; 80 Characters; Optional
Specify the name of the city of residence of the main brokerage firm for this broker type.
State/ Address Line 4
Alphanumeric; 80 Characters; Optional
Specify the state in which the city of residence of the main brokerage firm for this broker type is located.
Zip Code
Alphanumeric; 6 Characters; Optional
Specify the zip code of the specified city of residence of the main brokerage firm for this broker type.
Country
Alphanumeric; 3 Characters; Mandatory
Select the country in which the main brokerage firm for this broker type is domiciled, from the drop-down list.
Telephone 1-2
Alphanumeric; 15 Characters; Optional
Enter the contact telephone numbers of the main brokerage firm for this broker type.
Cell Phone Number
Alphanumeric; 16 Characters; Optional
Specify the cell phone number of the main brokerage firm for this broker type.
Fax Number
Alphanumeric; 15 Characters; Optional
Enter the fax number of the main brokerage firm for this broker type.
Alphanumeric; 60 Characters; Optional
Specify the E-mail address of the main brokerage firm for this broker type.
Contact Person
Alphanumeric; 70 Characters; Optional
Specify the name of any contact person or official through whom communication with the main brokerage firm is possible.
Effective From Date
Date Format; Optional
Specify the date that marks the beginning of the period for which the specified Correspondence address is valid.
Effective To Date
Date Format; Optional
Specify the date that marks the end of the period for which the specified Correspondence address is valid.
BIC Code
Alphanumeric; 12 Characters; Optional
Specify the Bank Identifier Code (BIC) of the main brokerage firm for this broker type.
This section contains the following topics:
After you have set up a broker type through the Broker Type Detail screen, you can:
To perform any of these operations, use the ‘Broker Type Summary’ screen. You can invoke this screen by typing ‘UTSBRKTY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can also set up a record for each individual broker in the system and map these broker records to the authorized broker type. You can do this using the ‘Broker Maintenance Detail’ screen, which you can access from the Broker Maintenance menu in the Browser.
You can retrieve a previously entered record in the Broker Type Summary screen, as follows:
Note
You can also retrieve the individual record detail from the detail screen by doing query in the following manner:
You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operation by selecting from the Action list.
You can also search the record by using combination of % and alphanumeric value.
You can search the record for Broker Type by using the combination of % and alphanumeric value as follows:
You can modify the details of Broker Type parameters that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:
To view a record that you have previously entered, you must retrieve the same in the Broker Type Summary screen, as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized Broker Type record must be authorized in the system for it to be processed. To authorize a record:
When the checker authorizes a record, details of validations, if any, that were overridden by the maker of the record during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the transaction.
After a Broker Type record is authorized, it can be modified using the Unlock operation from Action list. To make changes to a record after authorization:
An amended Broker Type record must be authorized for the amendment to be made effective in the system. The authorization of amended records can only be done from Fund Manager Module and Agency branch Module.
The process of authorization is subsequently the same as that for normal transactions.
This section contains the following topics:
In the Oracle FLEXCUBE Investor Servicing system, you can maintain a record in the database for each individual broker who wishes to transact with the AMC.
Just as with the unit holder account for an investor, the broker record in the system database is the single repository for all details concerning the broker, including details of commission processing and payment.
In Oracle FLEXCUBE Investor Servicing, when a broker wishes to reinvest the commission earnings from any fund back into the funds of the AMC, the reinvestment is effected through a default unit holder account that functions as the broker’s investment account in the system database.
To maintain a record for a broker, use the ‘FCIS Broker Maintenance Detail’ screen. You can invoke this screen by typing ‘UTDBRKMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can set up a broker in the system database by creating a record for the same in the Broker Maintenance Detail screen, as follows:
Before you begin to set up any new brokers in the system, you must ensure that the following static information sets have already been set up and entered into the system database and the required authorizations done:
For a detailed account of this information, refer to the Fund Manager.
Note
You must also ensure that any broker types necessary for grouping the brokers have been set up and authorized.
When you create a record for a broker in the Broker Maintenance Detail screen, you must specify the following data as mandatory information:
Contact Details Section
In the Contact Details section, you must specify the default contact address of the broker, in the Default Address field.
Bank Details Section
In the Bank Details section, you must specify the details of at least one bank account operated by the broker, and at designate at least one of the bank accounts as the default bank account. For each bank account, all the details on the screen are mandatory information.
Payment Details Section
In this section, you must specify the following:
After you have specified all of the mandatory information required for saving a record for a new broker into the database, save the record by clicking the Save button at the bottom of the Broker Maintenance Detail screen.
The record of the broker is now saved as an unauthorized record in the system database.
Alternatively, after you have specified all mandatory information, you can add further data before you save the record, as follows:
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the FCIS Broker Maintenance screen.
Click ‘Broker Details’ tab to enter the details.
The following fields are available in the Broker Maintenance Detail screen for data entry:
Broker Code
Alphanumeric; 12 Characters; Mandatory
Specify an alphanumeric code that would uniquely identify the record of the broker in the system.
This would be the identifier that you would use whenever you query the database for any details regarding the broker.
Broker Name
Alphanumeric; 105 Characters; Mandatory
Specify the name of the broker for whom you are setting up a record in this screen.
Parent Broker Code
Alphanumeric; 9 Characters; Mandatory
Select the broker code of the immediate higher broker to which this broker must report from the option list.
When you select a parent broker in this field, you indicate that the broker whose record you are creating now is a sub-broker of an authorized broker already existing in the system. It also means that the broker is part of an existing hierarchy structure.
Note
If it is necessary to set up the broker as the highest broker in a new hierarchy, specify the unique code that you entered for this broker in the Broker Code field in the screen. If the broker code and the parent broker code are identical for a broker, then it means that the broker is the highest broker in the hierarchy, and has no parent broker. You can change the parent broker code for a particular broker. The system changes the hierarchy and the level number of the broker and all its sub brokers based on the new parent broker code and level during authorization. The broker commission processing considers the latest broker maintenance for commission sharing.
Parent Broker Name
Display
When you select the parent broker for the broker in this field, the name of the selected parent broker is displayed in the Parent Broker Name field.
Note
Also, you must authorize a broker before you select the broker as a parent broker for another broker.
Replicate Parent Details
Optional
The system defaults the parent broker details, if Replicate Parent Details option is selected. Even if you input the broker details it will be overridden by the parent broker details only for the fields mentioned in the template. During authorization of broker amendment, the system replicates the fields specified in the template of the amended broker to all the sub-brokers for whom the Replicate Parent Details option is selected.
If Template ID is given and the Replicate Parent Details is selected as Yes, then click Enrich button to default the parent broker details based on Auto replication preference maintenance.
Template ID
Alphanumeric; 6 Characters; Optional
Specify the template ID.
Broker Category
Mandatory
Select the tax category applicable for the broker from the drop-down list. The list displays the following values:
Broker Type
Alphanumeric; 6 Characters; Optional
From the list, select the broker type to be associated with the broker.
You can indicate that the frequency of payment that has been designated for the selected broker type must also apply to the broker, by checking the Use Broker Type Payment Details check box.
Type Description
Alphanumeric; 255 Characters; Optional
Provide a description of the broker type.
Broker Base Currency
Alphanumeric; 3 Characters; Mandatory
Specify the broker base currency. The adjoining option list displays valid broker base currencies maintained in the system. You can choose the appropriate one.
Rule Effective Date
Date Format; Mandatory
Specify the date from which the broker is effective in the system. The rule effective date must be equal to or greater than the application date.
By default, system will display the application date as the rule effective date.
Broker Status
Alphanumeric; 1 Character; Mandatory
From the list, specify the status of the broker. If the broker is to be disabled in the system, select the option ‘WEEDED’.
Status Description
Display
The system displays the description for the selected broker status.
Broker Consultant
Alphanumeric; 40 Characters; Optional
Specify the name of the consultant preferred by the broker.
AMC
Alphanumeric; 12 Characters; Mandatory
Select the AMC in which the broker wishes to transact.
AMC Description
Display
The system displays the description for the selected AMC ID.
Level Number
Display Only
When you specify the code and the parent broker for the new broker, the level number of the new broker in the broker hierarchy structure is displayed here by the system. If you specified the code of the new broker itself as the parent broker code, (i.e., the new broker has no parent broker) the level number displayed is zero, and so on.
Use Broker Type Payment Details
Optional
If you have designated the new broker to be identified under a selected broker type in the system, then you can designate that the frequency of payment identified for the broker type be applicable by default to the new broker too. To do so, check this box.
Hold Back Payment
Mandatory
Select ‘Yes’ from drop-down list to indicate that commission payments to the new broker must be held back and not paid out. The commission payment will be held back and not paid out until the tax liability of the broker falls below the commission earned, for a tax year.
Held From
Date Format; Optional
Select the Held From date. from the adjoining calendar.
Overridden Percent
Numeric; 15 Characters; Optional
Specify the overridden percentage.
For the purpose of computing and deducting withholding tax, the tax slabs (if any) maintained in the With Holding Tax Input for the broker category under which the broker is placed, are identified. However, you can specify a fixed percentage in this field that will override any slab details maintained for the broker category.
Therefore, the percentage that you specify here is used to compute tax, and supersedes any WHT slabs maintained in the With Holding Tax Input screen.
Broker Disable Status
Mandatory
Select the broker status from the drop-down list. Select ‘Yes’ to indicate that the broker whose record you are creating is disabled.
If the broker disable status is selected as ‘Yes’ then the Broker is marked as Pending Closure on save. The broker needs to be authorized to incorporate the status change of the broker and then it will not be available for the new business. Also the system will check if the broker is associated with any active UH accounts, SI, or policy. If yes, the system displays the following message:
‘Broker has pending transactions/business in the system’ and broker status is marked as ‘Pending closure’.
While the Broker is in Pending Status, any commission earned from Debit Orders is paid, but the Broker Code is not available for any new business.
A broker whose record in the system is disabled cannot be designated for an investor or for any transactions, and commission payments for the broker will also not be processed or paid out.
Note
You can re-enable the disabled broker if the broker is disabled by mistake.
Employer ID Number
Alphanumeric; 50 Characters; Optional
Specify the employer ID number.
Tax ID
Alphanumeric; 50 Characters; Optional
Specify the tax identification.
Tax Circle
Alphanumeric; 15 Characters; Optional
Select the tax circle country from the adjoining option list.
Tax Certificate Effective Date
Date Format; Optional
Specify the date from which the tax certificate is effective.
Tax Certificate Expiry Date
Date Format; Optional
Specify the expiry date of the tax certificate.
FATCA Sponsor Type
Optional
Select the FATCA sponsor type from the adjoining drop down list. The values are:
If you select ‘Sponsoring Entity’, you need to specify the sponsoring entity type and sponsoring entity ID.
If you select ‘Sponsored Entity’, you need not to specify the sponsoring entity type and sponsoring entity ID.
Sponsoring Entity Type
Numeric; 1 Character; Optional
Specify the sponsoring entity type. You can also select the valid entity type from the adjoining option list.
GIIN Issue Date
Date Format; Optional
Specify the GIIN issue date.
The GIIN issue date cannot be greater than the application date.
GIIN Verified Flag
Display
System displays the GIIN verified flag based on the GIIN. In case the GIIN is entered and not chosen from the list, the flag GIIN verified will be set to ‘NO’. If the GIIN is chosen from the list of values, then GIIN verified flag will be set to ‘YES’.
Global Intermediary Identification Number (GIIN)
Alphanumeric; 30 Characters; Optional
Specify the global intermediary identification number.
US Indicia Available
Display
The system defaults US Indicia Available as Yes if any of the below mentioned values are true::
FATCA Status
Display
If the ‘US Indicia Available’ is true then the ‘FATCA Status’ value depends on the FATCA Maintenance.
FATCA Classification
Display
The system displays the FATCA classification type.
Description
Display
The system displays the description of FATCA classification.
Sponsoring Entity ID
Alphanumeric; 12 Characters; Optional
Specify the sponsoring entity for the FATCA entity type. You can also select the valid entity ID from the adjoining option list.
GIIN Expiry Date
Date Format; Optional
Specify the GIIN expiry date.
The GIIN expiry date cannot be lesser than the GIIN issue date.
Nationality
Alphanumeric; 3 Characters; Optional
Select the nationality from the adjoining option list.
Description
Display
The system displays the description for the selected nationality.
Country of Domicile
Alphanumeric; 3 Characters; Optional
Select the country of domicile from the adjoining option list.
Description
Display
The system displays the description for the selected country of domicile.
Country of Birth
Alphanumeric; 3 Characters; Optional
Select the country of birth from the adjoining option list.
Description
Display
The system displays the description for the selected country of birth.
Incorporation Country
Alphanumeric; 3 Characters; Optional
Select the Incorporation country from the adjoining option list.
Description
Display
The system displays the description for the selected country of incorporation.
In this section, specify the parameters that will govern the processing and payment of commission due the broker.
Also, if the broker is VAT registered, indicate the corresponding registration number.
You can access this section through the Payment Details link.
Hierarchy Commission Percentage
Numeric; 5 Characters; Mandatory
Specify the percentage of the commission received that is to be paid by the broker to the immediate parent broker level.
For a given broker hierarchy structure, the commissions received at any level may be shared between the brokers of the hierarchy in a pre-defined manner.
To understand how earned commission would be shared in a hierarchy structure, let us consider an example.
Consider a four-tier broker setup as given below. Let us suppose that the transaction commission processed of a particular subscription transaction must be split amongst the brokers in the following manner.
The Top-Level (Level Zero) parent broker receives 10%
The Level 1 parent broker receives 15%
The Level 2 parent broker receives 25%
The Level 3 parent broker receives 50%
Such a setup entails that a subscription transaction commission of 1000 currency units (initiated by Level 4 broker) must be split amongst this broker hierarchy as follows:
The Top-Level (Level Zero) parent broker receives 100 currency units.
The Level 1 parent broker receives 150 currency units.
The Level 2 parent broker receives 250 currency units.
The Level 3 parent broker receives 500 currency units.
Therefore, this must be the pattern of receivables that must arise from this commission setup, for this hierarchy.
In Oracle FLEXCUBE, to enable this kind of a pattern, the following setup (called the payables method) is used.
Set the commission percentage of Top-Level (Level Zero) parent broker to 0% (i.e., this broker pays nothing to the immediate parent broker as the broker is a level zero broker)
Level 1 parent broker: 60% (Pays 60% of commission received to immediate parent broker)
Level 2 parent broker: 50% (Pays 50% of commission received to immediate parent broker)
Level 3 parent broker: 50% (Pays 50% of commission proceeds to immediate parent broker i.e. Level 2)
As a result of the above setup for the case mentioned above, (subscription commission of 1000 currency units) the split will be as follows:
Broker |
Receivable (Currency Units) |
Payable (Currency Units) |
Net Receivable (Currency Units) |
Level 3 Broker |
1000 |
500 |
500 |
Level 2 broker |
500 |
250 |
250 |
Level 1 broker |
250 |
150 |
100 |
Level 0 broker |
150 |
0 |
150 |
Payment Frequency
Optional
From the drop-down list, indicate the frequency according to which commission payments must be made to the broker. The list displays the following values:
If you have designated the broker to be identified under a selected broker type, and also checked the Use Broker Type Payment Details check box in this screen, the frequency of payment identified for the selected broker type is also applicable by default for the broker. This frequency is displayed here.
Next Payment Date
Date Format; Optional
Specify the earliest future date on which the next commission payment should be made to the broker. Do not specify a designated system holiday in this field. The commissions will be processed based on the new payment date and the frequency specified will be used to make periodic payments.
Last Payment Date
Display
The most recent date on which a commission payment was made to this broker is displayed here. When you are creating a new record for a broker in this screen, this field is empty.
Default Unit Holder ID
Alphanumeric; 12 Characters; Optional
Select the ID of the unit holder account that is designated to be used as the default account in the system for the broker. This is typically so when the broker prefers that a unit holder receives the proceeds of the commission payments.
Whenever the broker opts for reinvestment of earned commission back into the funds of the AMC, (according to the income distribution setup options defined for the broker) the reinvestment will be effected through the unit holder ID you specify here.
You can query for unit holder ID by clicking ‘Find UH’ button.
VAT Registered
Mandatory
Select ‘Yes’ option from the drop-down list to indicate that the broker is a VAT Registered broker.
VAT Registration No.
Alphanumeric; 15 Characters; Optional
If the broker is a VAT registered broker, specify the broker’s VAT Registration Number.
VAT Registration Date
Date Format; Optional
Select the date of VAT registration from the adjoining calendar. VAT Registration date is mandatory if the broker is a VAT registered broker.
While processing broker commission, the system computes the VAT amount only if the transaction date is on or after the VAT registration date of the broker.
During periodic loan accrual processing, system computes the VAT amount only if the accrual date is on or after the VAT registration date maintained at the broker level.
VAT Expiry Date
Date Format; Optional
Select VAT expiry date from the adjoining calendar.
In this section, specify all the details of the available modes of communication and correspondence with the broker. Click ‘Broker Contact Info’ tab to enter the details.
You can specify at least two addresses, and designate one as the default mailing address to be used for correspondence with the broker, and the other as the alternate address. Specify the default address under the Default Address head, and the alternate address under the Alternate Address head.
You can also maintain the SWIFT Address for the main brokerage firm of the broker type, in the SWIFT Address tab.
The following fields comprise the Correspondence; Alternate and SWIFT address information in the Address Type tab.
Address Type
Mandatory
Select the type of address from the drop-down list. The list displays the following values:
Address Lines 1-2
Alphanumeric; 80 Characters; Optional (Address Line 1 is Mandatory)
Specify the postal address that is to be used for correspondence with the broker.
City
Alphanumeric; 80 Characters; Optional
Specify the name of the city of residence of the broker. You can select the city from the drop down list provided. The available options depend on the values defined at the params maintenance. If the city is not available in the list, you can specify the city in the field provided alongside.
Zip Code
Alphanumeric; 10 Characters; Optional
Specify the zip code of the specified city of residence of the broker.
US State
Optional
Select ‘Yes’ option from drop-down list to indicate that the specified state is a US (United States) state.
State
Alphanumeric; 80 Characters; Optional
Specify the state in which the city of residence of the broker is located. You can select the state of residence from the drop down list provided. The available options depend on the values defined at the params maintenance. If the state is not available in the list, you can specify the city in the field provided alongside.
Country
Alphanumeric; 3 Characters; Optional
Select the country in which the broker is domiciled, from the drop-down list.
Contact Person
Alphanumeric; 70 Characters; Optional
Specify the name of any contact person or official through whom communication with the broker is possible.
Int. Dialing Code +
Alphanumeric; 10 Characters; Optional
Specify the international dialling code.
Telephone 1
Alphanumeric; 60 Characters; Optional
Enter the contact telephone numbers of the broker.
Int. Dialing Code +
Alphanumeric; 10 Characters; Optional
Specify the international dialling code.
Telephone 2
Alphanumeric; 60 Characters; Optional
Enter the contact telephone numbers of the broker.
Int. Dialing Code +
Alphanumeric; 10 Characters; Optional
Specify the international dialling code.
Cell Phone Number
Alphanumeric; 60 Characters; Optional
Specify the cell phone number of the broker.
Int. Dialing Code +
Alphanumeric; 10 Characters; Optional
Specify the international dialling code.
Fax Number
Alphanumeric; 120 Characters; Optional
Enter the fax number of the broker.
Alphanumeric; 255 Characters; Optional
Specify the E-mail address of the broker.
Effective From Date
Date Format; Optional
Specify the date that marks the beginning of the period for which the specified alternate address is valid.
Effective To Date
Date Format; Optional
Specify the date that marks the end of the period for which the specified alternate address is valid.
BIC Code
Alphanumeric; 12 Characters; Optional
Specify the Bank Identifier Code (BIC) of the broker.
In this section, you specify details of any bank accounts operated by the broker, which are preferred for transacting with the AMC. You can access this section by clicking ‘Broker bank Details’ tab.
You can specify any number of preferred bank accounts for a broker for each currency, but you must designate one of these to be used by the broker as the default bank account for making or receiving payments in transactions in each currency.
For each bank account in each currency, specify the following details:
Bank
Alphanumeric; 12 Characters; Mandatory
From the list, select the name of the bank in which the account is held.
Bank Name
Display
The system displays the name of the bank for the selected bank code.
Branch
Alphanumeric; 12 Characters; Mandatory
From the list, select the name of the branch of the bank in which the account is held.
Account Type
Alphanumeric; 1 Character; Mandatory
From the list, select the nature of the account held by the broker.
The list provides all account types that have been set up in the Account Type Maintenance records.
Account Number
Alphanumeric; 16 Characters; Mandatory
Specify the number of the account held by the broker in the selected bank.
Default
Optional
Select ‘Yes’ to identify the bank account that is to be reckoned as the default bank account for the broker in the system.
IBAN
Alphanumeric; 40 Characters; Optional
Specify the IBAN (International Bank Account Number) of the account holder.
Account Name
Alphanumeric; 100 Characters; Mandatory
Specify the name in which the broker holds the specified bank account.
By default, the system reckons this to be the specified name of the broker, and the same is displayed here. It will be accepted into the database as the account holder’s name if you do not specify any other.
Account Currency
Alphanumeric; 3 Characters; Mandatory
Select the currency of the bank accounts that you are designating for the broker. You can maintain any number of accounts in each currency; however, you must designate one default bank account for each currency.
Note
You can make commission payments where the commission currency is different from the broker bank account currency by selecting MCY option from the list of values for account currency.
Direct Debit Allowed
Optional
Select ‘Yes’ to allow the direct debit.
SWIFT format
Optional
Select the SWIFT format from the drop-down list. The list displays the following values::
Bank Charged
Optional
Select the bank charged details from the drop-down list. The list displays the following values:
Beneficiary
Alphanumeric; 35 Characters; Optional
Specify the beneficiary details.
Beneficiary Add1-3
Alphanumeric; 105 Characters; Optional
Enter beneficiary address.
Beneficiary BIC Code
Alphanumeric; 24 Characters; Optional
Enter beneficiary BIC Code.
Beneficiary Acct Number
Alphanumeric; 34 Characters; Optional
Enter beneficiary Account Number.
Beneficiary Code
Alphanumeric; 24 Characters; Optional
Enter beneficiary code.
Beneficiary Info
Alphanumeric; 100 Characters; Optional
Enter beneficiary information.
Beneficiary IBAN
Alphanumeric; 40 Characters; Optional
Specify the beneficiary IBAN details.
Intermediary
Alphanumeric; 35 Characters; Optional
Enter the intermediary details.
Intermediary Add 1-3
Alphanumeric; 105 Characters; Optional
Enter intermediary address.
Intermediary BIC Code
Alphanumeric; 24 Characters; Optional
Enter intermediary BIC Code.
Intermediary Acct Number
Alphanumeric; 34 Characters; Optional
Enter intermediary Account Number.
Intermediary Code
Alphanumeric; 24 Characters; Optional
Enter intermediary code.
Intermediary Info
Alphanumeric; 100 Characters; Optional
Enter intermediary information.
Intermediary IBAN
Alphanumeric; 40 Characters; Optional
Enter intermediary IBAN details.
Further Credit Name
Alphanumeric; 35 Characters; Optional
Enter further credit name.
Further Credit Acct Number
Alphanumeric; 35 Characters; Optional
Enter further credit account number.
Reference 1-2
Alphanumeric; 35 Characters; Optional
Enter the reference details.
Click ‘Broker Legacy Details’ tab to enter the details.
Legacy Code
Alphanumeric; 12 Characters; Optional
Enter any legacy code linked to the broker. The legacy code for each broker must be unique in the system. System will not allow you to store duplicate legacy codes. While processing a transaction, you can search for the broker using the legacy codes specified here.
Click ‘Broker Preferences’ tab to enter the details.
Feed Type
Alphanumeric; 20 Characters; Optional
From the option list, select the type of feed the broker wishes to receive. The various types available are as follows:
You cannot maintain preferences for a feed type more than once. If a duplicate feed type is selected, then system will throw up an error.
Feed Structure
Alphanumeric; 4 Characters; Optional
Specify the format of the file being extracted. The options available in option list are as follows:
The available options depend on the values defined in PARAMS maintenance.
Start Date
Date Format; Optional
Specify the date that marks the beginning of the Feed period.
Feed Frequency
Alphanumeric; 20 Characters; Optional
From the list, indicate the frequency according to which the data feed must be made to the broker.
Feed Format
Alphanumeric; 6 Characters; Optional
Indicate the format of the Feed to be made to the broker.
The available options depend on the values defined in PARAMS maintenance.
Click ‘Related Parties’ tab to specify the details
You can specify the following details:
Entity Type
Alphanumeric; 2 Characters; Mandatory
Select the entity type. Alternatively, you can select entity type from the option list. The list displays all valid entity types maintained in the system.
Entity Type Description
Display
The system displays the description for the selected entity type.
Entity ID
Alphanumeric; 12 Characters; Mandatory
Select the entity ID from the option list. These entities are based on the Entity Type chosen.
Entity Name
Display
The system displays the name of the entity for the selected entity ID.
Reporting Level
Alphanumeric; 1 Character; Mandatory
Select the reporting level from the option list. The following are the reporting levels:
Preferred Mailing Mode
Alphanumeric; 1 Character; Optional
Select the preferred mailing mode from the list. The following are the preferred mailing modes:
Link Notes
Alphanumeric; 255 Characters; Optional
The link notes stores free format text which is used to explain the reason for linking the entity with the unit holder.
Note
Related Parties are captured for informational purpose only and no processing impact is associated.
Related Party Level
Mandatory
Select the related party level from the adjoining drop-down list. Following are the options available:
Related Party Value
Alphanumeric; 12 Characters; Mandatory
Specify the related party value. The adjoining option list displays all valid related party values maintained in the system. You can choose the appropriate one.
If you select ‘All’ in ‘Related Party Level’ field, then you need to select ‘All’ from the adjoinin option list in ‘Related Party Value’ field as well. The system will not allow any more records to be added if ALL has been selected in the ‘Related Party Level’ field for a particular entity ID and entity type combination.
If the AMC has designated any additional information heads for brokers, you can indicate the relevant information applicable to the broker under each head, in this section.
You can access this section by clicking ‘Broker Add Info’ tab.
Other Info Field
Display
Displays the other information in the field.
Field Value
Alphanumeric; 60 Characters; Optional
Select the field value from the option list.
This section contains the following topics:
After you have set up a record for a broker in the system, you can perform the following maintenance operations, as required:
To perform any of these operations, use the ‘FCIS Broker Maintenance Summary’ screen. You can invoke this screen by typing ‘UTSBRKMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
After a broker record is authorized, you can also:
You can retrieve a previously entered record in the FCIS Broker Maintenance Summary screen, as follows:
Click ‘Search’ button to view the records. All records with the specified details are retrieved and displayed in the lower portion of the screen.
Note
You can also retrieve the individual record detail from the detail screen by doing query in the following manner:
You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operation by selecting from the Action list.
You can also search the record by using combination of % and alphanumeric value.
You can search the record for Broker Code by using the combination of % and alphanumeric value as follows:
You can modify the details FCIS Broker Maintenance parameters that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:
To view a record that you have previously entered, you must retrieve the same in the FCIS Broker Maintenance Summary screen, as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized FCIS Broker Maintenance record must be authorized in the system for it to be processed. To authorize a record:
When the checker authorizes a record, details of validations, if any, that were overridden by the maker of the record during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the transaction.
After a Broker Maintenance record is authorized, it can be modified using the Unlock operation from Action list. To make changes to a record after authorization:
An amended Broker Journal record must be authorized for the amendment to be made effective in the system. The authorization of amended records can only be done from Fund Manager Module and Agency branch Module.
The process of authorization is subsequently the same as that for normal transactions.
The amended record with the changes is saved in the database as an amended, unauthorized record that you must subsequently authorize for your changes to be reflected as authorized in the database.
You can make changes to any of the following details in a broker record through an amendment operation:
Amending the Broker Hierarchy
If you need to change the reporting structure in a broker hierarchy setup, you can amend the record of one of the concerned brokers and change the parent broker. You can also introduce an intermediate reporting level broker to whom the existing levels must report.
The following examples will make this clear:
The above illustration is a sample Broker Hierarchy Structure that is referred to in the examples 1-3.
Consider the following hierarchy setup for representing a reporting structure:
Let us suppose that the record of broker B1 is amended, and as a result, the broker B1 undergoes a level change and now reports to broker B111. To enable this change, the broker code of broker B1 is altered from B1 (existing) to B111.
On authorization, this change will be interpreted by the system as follows:
Broker B111 will report to himself (become a level zero broker).
Broker B1 will report to broker B1
All brokers under broker B111 will report to broker B111.
All brokers under B1 broker will report to broker B1.
As a result of the above level changes the new hierarchy will look as follows:
Let us suppose that, in the same original hierarchy structure, (the first figure) the record of the broker B11 is amended, and as a result, the broker B11 undergoes a level change and now reports to broker B111. To enable this change, the broker code of broker B11 is altered from B1 (existing) to B111.
On authorization, this will be interpreted by the system as follows:
Broker B111 will report to the original parent broker of broker B11, i.e., broker B1.
Broker B11 reports to broker B111.
All brokers under broker B111 will report to broker B111.
All brokers under broker B11 will report to broker B11.
As a result of the above level changes the new hierarchy will look as follows:
If a new reporting level has to be incorporated so that an existing level reports to the new broker, the following level changes should be done.
For example, consider the original setup:
Let us suppose that a new broker Bx is required to be inserted as a level 3 broker under broker B111, and that all brokers who are currently reporting to B111 must now be made level 4 brokers who are required to report to broker Bx.
To meet the requirement, the following changes (amendments) must be done in the records of the brokers concerned:
Introduce broker Bx with parent broker as broker B111, and assign the level number 3 to this broker.
In the record of broker B1111, change the parent broker of broker B1111 to broker Bx, and change the level number assigned to broker B1111 from 3 to 4.
Do likewise in the record of broker B1112.
As a result of these amendments, the new reporting structure would look like this:
This structure reflects the desired changes.
Amending VAT Information
You can amend a broker record so that the VAT information can be changed. On authorization, this amended record will affect the VAT payment portion for VAT registered brokers. If the VAT Registered option is unchecked, for future payments VAT will not be added.
Next Payment Date
When you amend a broker record, you can alter the Next Payment Date. This possibility can be used in case a broker account is to be closed (disabled permanently) and the commission payable is to be paid out immediately.
Commission Information
When you amend a broker record, you can alter the Commission percentage payable by this broker to the immediate parent broker.
Enabling or Disabling Brokers
When you amend a broker record, you can disable or enable the broker. Therefore, this possibility can be used to disable a broker from initiating further transactions in the system. This restricts the agency branches in selecting the broker code in all the transaction screens. (To revoke the disabling of the broker, enable the broker again and authorize the details).
Amending Other Information
When you desire to change basic details such as addresses, names, contact persons, broker status, rule effective date and so on for a broker, you can amend the broker's record and make the required changes. On Amendment of Broker details, Rule Effective date will be defaulted with the current Application Date.
The system allows you to amend the broker details even after a transaction is unitized. If you amend the broker details of a transaction after unitization, the system passes the appropriate broker commission entries for the old and the new broker to the OMIPAY and GL interfaces.
The amendment of the broker details will not have any implications on:
This section contains the following topic:
The ‘Transaction Broker Amendment’ screen displays the Transaction Broker Amendment details. You can invoke this screen by typing ‘UTDTXBRM’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Note
The screen restricts to modify transactions linked with single broker. For multiple brokers scenario you can reverse and recapture the transaction.
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the Transaction Broker Amendment screen.
Transaction Option
Mandatory
Select transaction option from the drop-down list. The list displays the following values:
Transaction Number
Alphanumeric; 16 Characters; Mandatory
Enter UT transaction number or policy transaction number for amendment of Broker’s information.
Old Broker Code
Alphanumeric; 12 Characters; Mandatory
Specify the Old Broker code.
New Broker Code
Alphanumeric; 12 Characters; Mandatory
Enter the New Broker Code.
Broker Name
Display
The system displays the broker name for the selected new broker code.
On authorization of the changes to the broker details:
This section contains the following topic:
You can specify preferred broker payments in multiple currencies based on the source currency of the commission through the Broker Payment Currency Preference screen. You can invoke this screen by typing ‘UTDBCYPR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Note
You cannot map multiple bank accounts to the same preferred currency.
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the Broker Payment Currency Preference screen.
Broker Code
Alphanumeric; 12 Characters; Mandatory
Select unique broker code from the adjoining list.
Broker Name
Display
The broker name will be displayed.
Effective Date
Date Format, Mandatory
Specify the date from which the broker payment currency is effective in the system.
Source Currency
Alphanumeric; 3 Characters; Mandatory
Specify the source currency of the payment.
Preferred Currency
Alphanumeric; 3 Characters; Mandatory
Select the preferred currency from the option list.
This section contains the following topics:
You can invoke the FCIS Broker Payment Currency Preference Summary screen by typing ‘UTSBCYPR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can retrieve a previously entered record in the FCIS Broker Payment Currency Preference Summary screen, as follows:
Click ‘Search’ button to view the records. All records with the specified details are retrieved and displayed in the lower portion of the screen.
You can also retrieve the individual record detail from the detail screen by doing query in the following manner:
You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operation by selecting from the Action list.
You can also search the record by using combination of % and alphanumeric value.
You can search the record for Broker Code by using the combination of % and alphanumeric value as follows:
You can modify the details of Broker Payment Currency Preference parameters that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:
To view a record that you have previously entered, you must retrieve the same in the FCIS Broker Payment Currency Preference Summary screen, as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized FCIS Broker Payment Currency Preference record must be authorized in the system for it to be processed. To authorize a record:
When the checker authorizes a record, details of validations, if any, that were overridden by the maker of the record during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the transaction.
After a Broker Payment Currency Preference record is authorized, it can be modified using the Unlock operation from Action list. To make changes to a record after authorization:
An amended Broker Payment Currency Preference record must be authorized for the amendment to be made effective in the system. The authorization of amended records can only be done from Fund Manager Module and Agency branch Module.
The process of authorization is subsequently the same as that for normal transactions.
Note
When a journal entry for a broker is authorized, the process for any adjustments specified in the entry to the next payment cycle or transaction for the broker is begun in the database. Subsequently, you cannot change a journal entry that has been authorized, in any way. The amendment operation is not available on authorized journal entries for brokers.
This section contains the following topics:
Broker merger is a scenario, where source broker code merges with target broker code to form a single entity.
Post RDR, if the broke merger is not due to advise, then the merger is considered as not advised and the new agent/broker will inherit the terms of holdings. Also. is eligible to receive commission.
Once the broker is merged, the commission due to source broker is paid to the target broker for the business mobilized by the source broker. Also, the system transfers the holdings of source broker to target broker. Post merger, if a transaction is received with source broker code, then the transaction is linked to the target broker code.
Merger of brokers is scheduled as a EOD batch process triggered by 'Broker Merger' activity on the day the merger is authorized.
Note
– If either the source or target broker is suspended or deceased, then the system disables broker merger.
– If source broker code is UK domiciled and target broker code is non UK domiciled or visa versa, then the system displays the warning message as “Source/target broker is UK Domiciled- Do you wish to continue”.
You can change the default broker, from one broker to the other, for all the unit holders, in bulk, through the Broker Migration screen.
You can invoke this screen by typing ‘UTDBRMIG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
The system validates if the source broker status is Pending Closure before migration. Only the Brokers with disabled status as ‘No’ are mapped as destination brokers.
Note
Duplicate entries with the same source and destination broker with the same effective date are not allowed.
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the Broker Migration screen. Only save operation is applicable for the Broker Migration screen.
Source Broker ID
Alphanumeric; 12 Characters; Mandatory
Source broker is the broker from whom migration is done. Select the source Broker ID of the option list.
Source Broker Name
Display
The name of the source broker is displayed.
Destination Broker ID
Alphanumeric; 12 Characters; Mandatory
Destination broker is the new broker to whom the details are migrated. Select the destination Broker ID of the option list.
Destination Broker Name
Display
The name of the destination broker is displayed.
Effective Date
Date Format; Mandatory
Specify the date from which the broker migration is effective in the system.
Status
Display
The status of broker migration is displayed.
This section contains the following topics:
You can invoke the ‘FCIS Broker Migration Summary’ screen by typing ‘UTSBRMIG’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can retrieve a previously entered record in the Broker Migration Summary screen, as follows:
Click ‘Search’ button to view the records. All records with the specified details are retrieved and displayed in the lower portion of the screen.
Note
You can also retrieve the individual record detail from the detail screen by doing query in the following manner:
You can also search the record by using combination of % and alphanumeric value.
You can search the record for Source Broker ID by using the combination of % and alphanumeric value as follows:
To view a record that you have previously entered, you must retrieve the same in the Broker Migration Summary screen, as follows:
This section contains the following topics:
Brokers receive commission payments out of some of the transactions in every fund for which they are designated intermediaries.
With regard to commission earnings, brokers could request for:
Oracle FLEXCUBE Investor Servicing enables the AMC to keep track of the processing and actual payment of commission earnings for brokers, by providing an accounting ‘journal’ facility, which would record each payment made.
Using this journal, you can:
To maintain a journal of accounting entries for payments to a broker, use the ‘Broker Journal Detail’ screen. You can invoke this screen by typing ‘UTDBRKJR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In the screen, specify the following mandatory information for each accounting entry for a broker, for a transaction in a fund:
After you have specified this data, save your changes by clicking the Save button at the end of the screen.
You must have another user to authorize a journal entry for the same to be reflected in the database.
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the Broker Journal screen.
The following fields are available in the Broker Journal Detail screen for data entry:
Journal Txn Number
Display
System displays the automatically generated Journal Txn Number here.
Entry Date
Date Format; Mandatory
Specify the date on which the respective accounting entry was made in this journal. This date cannot be a future date.
Note
System computes the VAT amount for the commission only if the broker journal entry date is on or after the broker VAT registration date.
Reference Number
Alphanumeric; 16 Characters; Mandatory
Specify a unique alphanumeric identifier for the journal entry. You will use this reference number to track this entry subsequently.
Journal Type
Alphanumeric; 1 Character; Mandatory
Select the Journal type from the adjoining drop-down list.
This list displays the following values:
General Journal (G): If you select General Journal, the broker code and the journal remarks are mandatory.
Client-Specific Journal (C): If you select Client-Specific Journal, the broker code, UHID and remarks are mandatory.
Transaction-Specific Journal (T): If you select Transaction-Specific Journal, broker code, transaction number, UHID and remarks are mandatory.
The system defaults Fund ID and Unit Holder ID on the selection of transaction number.
Broker
Alphanumeric; 9 Characters; Mandatory
Select the code of the broker for whom the accounting entry is being recorded in the journal.
Broker Name
Display
The broker name will be displayed.
Product ID
Alphanumeric; 10 Characters; Optional
Select the product ID from the option list.
Product Name
Display
The system displays the name of the product for the selected product ID.
Fund ID
Alphanumeric; 6 Characters; Mandatory
Select the fund ID in which the commission was earned by the broker, resulting in this journal entry.
The list contains all funds in which the broker has transacted and received commission, in the AMC. When you specify the fund, the ISIN Code of the fund is displayed in the ISIN Code field.
Fund Name Short
Display
The system displays the short name of the fund.
ISIN Code
Alphanumeric; 25 Characters; Mandatory
Select the ISIN Code of the selected fund. If you specify the ISIN Code of a fund, the fund is displayed in the Fund field.
Transaction Number
Numeric; 16 Characters; Optional
Select the Transaction Number from the adjoining option list.
Note
If the transaction number is given then system validates whether the transaction number belongs to the corresponding broker or not, while saving.
Unit Holder ID
Alphanumeric; 12 Characters; Optional
The system populates the Unit Holder ID from the transaction number selected.
You can also query unit holder ID by clicking ‘Find UH’ button.
Unit Holder Name
Display
The system defaults the Unit Holder Name as per the Unit Holder ID.
Journal Currency
Alphanumeric; 3 Characters; Mandatory
Select the currency for the journal entry. The base currency for the fund is displayed here, but you can choose a different currency.
Payables
Alphanumeric; 18 Characters; Optional
Specify the amount that the broker must pay to the AMC, if any, as a result of the transaction.
Receivables
Alphanumeric; 18 Characters; Optional
Specify the commission amount that the broker must receive from the AMC, if any, as a result of the transaction.
Adjustment Entry
Mandatory
Select the appropriate Adjustment Entry from the adjoining drop-down list to indicate that the payable or receivable amount specified for this journal entry must be adjusted or offset in the next commission payment cycle for the next transaction, for the selected broker.
If you select the option ‘VAT Only’, then the amount entered against Payables and Receivables is considered as VAT amount payable and receivable.
If the Adjustment entry is selected as VAT only, then the system will make changes only to the VAT amount.
Remarks
Alphanumeric; 255 Characters; Mandatory
Specify any narrative or descriptive text qualifying the journal entry. This information is mandatory.
Currency Name
Display
The system displays the name of the currency for the selected journal currency.
In this section, specify the details of the mode in which the payables or receivables amount has to be paid out or received by the broker.
Payment Mode
Optional
Select the mode in which the payment was made or received, either through check or by account transfer.
Bank
Alphanumeric; 12 Characters; Mandatory
Select the code of the bank, in which the transfer account resides, which was used to make the payment.
Check Number
Alphanumeric; 12 Characters; Mandatory for check payments
Specify the number of the check.
Account Currency
Alphanumeric; 3 Characters; Optional
Select the currency of the transfer account, which was used to make the payment.
Account Number
Alphanumeric; 16 Characters; Optional
Specify the number of the transfer account that was used to make the payment.
IBAN
Alphanumeric; 40 Characters; Optional
Specify the IBAN (International Bank Account Number) of the account holder.
Branch
Alphanumeric; 12 Characters; Optional
Select the code of the bank, in which the transfer account resides, which was used to make the payment.
Cheque Date
Date Format; Optional
Specify the date on which the check was drawn.
Account Type
Alphanumeric; 1 Character; Optional
Select the type of the transfer account, which was used to make the payment.
Maintained Bank Accounts
Alphanumeric; 35 Characters; Optional
Select the maintained bank accounts from the option list.
This section contains the following topics:
After you have made an accounting entry in a broker journal, you can:
To perform any of these operations, use the ‘Broker Journal Summary’ screen. You can invoke this screen by typing ‘UTSBRKJR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can retrieve a previously entered record in the Broker Journal Summary screen, as follows:
Click ‘Search’ button to view the records. All records with the specified details are retrieved and displayed in the lower portion of the screen.
You can also retrieve the individual record detail from the detail screen by doing query in the following manner:
You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operation by selecting from the Action list.
You can also search the record by using combination of % and alphanumeric value.
You can search the record for Journal Txn Number by using the combination of % and alphanumeric value as follows:
You can modify the details of Broker Journal parameters that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:
To view a record that you have previously entered, you must retrieve the same in the Broker Journal Summary screen, as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized Broker Journal record must be authorized in the system for it to be processed. To authorize a record:
When the checker authorizes a record, details of validations, if any, that were overridden by the maker of the record during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the transaction.
When a journal entry for a broker is authorized, the process for any adjustments specified in the entry to the next payment cycle or transaction for the broker is begun in the database. Subsequently, you cannot change a journal entry that has been authorized, in any way. The amendment operation is not available on authorized journal entries for brokers.
This section contains the following topics:
An intermediary (such as a broker) derives commission earnings from the transactions in the funds of the AMC.
Brokers could wish to choose the manner in which they could use their commission earnings. They could:
The pattern chosen by the broker to use commission earnings is known as the Income Distribution Setup pattern or the IDS pattern for the broker.
You can capture this pattern for any broker in the Oracle FLEXCUBE Investor Servicing system.
Use the Income Distribution Setup Detail screen to set up the income distribution pattern for a broker. You can invoke this screen by typing ‘UTDUHIDS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
In this screen, you set up the IDS pattern by:
Select 'New' from the Actions menu in the Application tool bar or click new icon to enter the details of the ‘Income Distribution Setup’ screen.
For further details on this screen, please refer ‘Income Distribution Setup Screen’ section in this User Manual
This section contains the following topics:
You can raise broker commission using the ‘Raise Broker Commission’ screen. You can invoke this screen by typing ‘UTDBRAIS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
To Date
Date Format; Mandatory
Specify the date until which you wish to raise the broker commission. This field is mandatory.
If you raise broker commission on current application date, the system will consider all the transactions allotted till the previous day. ‘To date’ should be less than or equal to the previous working date.
Last Raise Date
Date Format; Optional
Select the last raise date when the raise was made from the adjoining calendar.
Broker Type
Alphanumeric; 6 Characters; Optional
Specify the broker type for which the commission should be raised.
AMC ID
Alphanumeric; 6 Characters; Optional
Specify the id of the AMC. The adjoining option list displays all valid AMC ids maintained in the system. You can select the appropriate one.
AMC Name
Alphanumeric; 10 characters; Optional
When you select the AMC ID, the AMC name automatically gets populated. However, you are allowed to edit the same.
Fund ID
Alphanumeric; 6 characters; Optional
Specify the fund id. The adjoining option list displays all valid fund ids maintained in the system. You can select the appropriate one.
Fund Name
Display
When you select the fund id ,the fund name automatically gets populated.
The system logs the VAT amount details along with commission details.
The raising of commission is independent of the payment of commission, and the raise of commission and the payment of commission need not occur on the same day. The commission table shows the converted amount if the broker source currency is different from that of the preferred currency.
For raise broker commission, previous system date cannot be a holiday.
The system computes the VAT amount for periodic load accrual using the following formula:
(Load Amount * VAT%)
The system computes the VAT for transaction load using the following formula:
(Load Amount * VAT%)
The VAT will be calculated only if the VAT registered date is less than the transaction date.
The criteria based load setup should be done to achieve the VAT calculation based on the VAT registered date. The criteria based load set up should be done as below:
LOAD ID |
LOAD DESCRIPTION |
CRITERIA |
203 |
Initial Broker Fee - Rands(Vat) |
WHERE TransactionDetails.TRANSACTIONMODE = 'A' AND TransactionDetails.BROKERCODE <> 'DIRECT' AND TransactionDetails.VATREGISTERED = '1' |
204 |
Initial Broker Fee - Rands(Non Vat) |
WHERE TransactionDetails.TRANSACTIONMODE = 'A' AND TransactionDetails.BROKERCODE <> 'DIRECT' AND TransactionDetails.VATREGISTERED = '0' |
205 |
Initial Broker Fee - Units(Vat) |
WHERE TransactionDetails.TRANSACTIONMODE = 'U' AND TransactionDetails.BROKERCODE <> 'DIRECT' AND TransactionDetails.VATREGISTERED = '1' |
206 |
Initial Broker Fee - Units(Non Vat) |
WHERE TransactionDetails.TRANSACTIONMODE = 'U' AND TransactionDetails.BROKERCODE <> 'DIRECT' AND TransactionDetails.VATREGISTERED = '0' |
This section contains the following topics:
You can change the commission payment status using the ‘Commission Payment Status Change’ screen. This means that you can hold the commission payment for which the commission is raised. You can invoke this screen by typing ‘UTDCHPAY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Reference Number
Display
The system displays the reference number.
Fund ID
Alphanumeric; 12 Characters; Mandatory
Specify the fund ID.
Transaction Number
Alphanumeric; 16 Characters; Optional
Specify the transaction number.
From Entity ID
Alphanumeric; 12 characters; Optional
Specify the entity from whom the commission is charged.
To Entity ID
Alphanumeric; 15 characters; Optional
Specifies the entity for whom the commission is charged. This field is mandatory.
Policy Number
Alphanumeric; 10 characters; Optional
Specify the policy number. The adjoining option list displays valid policy numbers maintained in the system. You can choose the appropriate one.
Current Payment Status
Alphanumeric; 15 Characters; Optional
Select the current payment status from the adjoining option list.
Select All
Optional
Select if all the records has to be selected or not from the drop-down list. The list displays the following values:
Click on ‘Show Details’ button to show all the records with the specified values.
New Payment Status
Alphanumeric; 15 Characters; Optional
Specify the new payment status for the commission record. This determines the eligibility for the payment of commission.
All commission records that have a Payment Status = ‘P’ will be eligible for Commission Payment. ‘P’ means payable.
All commission records that have a Payment Status = ‘S’ will not be eligible for the next commission payment run. After the next commission payment processing, system will update the commission records with Payment Status as ‘S’ to ‘P’ (Payable) status. ‘S’ means Single Payment Hold Back.
All commission records that have a Payment Status = ‘I’ will not be eligible for a commission payment run. ‘I’ means indefinite hold back.
System will not automatically update the commission records with payment status as ‘I’ to ‘P’. This should be done manually.
You can select a record and change the Exchange Rate Source or Exchange Rate or New payment status and click on ‘Process’ button to update the commission record with new payment status, new exchange rate source applied, new exchange rate applied.
Click ‘Search Results’ tab to view the records for which broker commission is raised. However, you can override the details in this section.
You can view the following fields:
Click ‘Exchange Rate Source’ tab to map the exchange rate source and currency details.
Specify the following details:
Commission Currency
Alphanumeric; 3 Characters; Optional
Specify the currency in which the commission is paid.
Currency Name
Display
The system display the name of the currency.
New Exchange Rate Source
Alphanumeric; 6 Characters; Optional
Select the exchange rate source from which the exchange rates are to be derived for the transaction.
For example, If the default source currency is USD and you are required to convert commission from GBP to EUR, then the system first converts from GBP to USD and then from USD to EUR.
Click ‘Exchange Rate Maintenance’ tab to maintain the exchange rate.
Specify the following fields:
Source Currency
Alphanumeric; 3 Characters; Optional
The system displays the source currency, however, you can specify the currency in which the commission is paid from the adjoining option list.
Payment Currency
Alphanumeric; 3 Characters; Optional
Specify the currency in which the commission is paid.
Exchange Rate Source
Alphanumeric; 6 characters; Optional
Specify the exchange rate source from which the exchange rates are to be derived for the transaction.
New Exchange Rate
Alphanumeric; 15 Characters; Optional
Specify the latest exchange rate maintained for an exchange rate source.
Note
Payment status change of a record is also reflected in the Payment Enrichment screen.
This section contains the following topic:
You can determine the date of commission payment for all commission transactions raised from a specific agency branch or across all agency branches using the ‘Broker Comm Payment’ screen. You can invoke this screen by typing ‘UTDBRCOP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
Click the ‘Start Process’ button to process the commission payment.
Note
If the amount in payment currency for the broker is greater than the minimum payment amount for Payment Currency, then all of those commission should be paid. You can make the payment at any time.
This section contains the following topic:
In this section specify the details to maintain a minimum payment amount for each commission payment currency. You can invoke this screen by typing ‘UTDMINPY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button. The FCIS Min Comm Payment Amt Maintenance Detail screen is displayed:
Effective Date
Date Format; Mandatory
Specify the date from which the commission payment should be effective in the system.
Payment currency
Alphanumeric; 3 Characters; Mandatory
Select appropriate currency from the adjoining option list.
Minimum Payment Amount
Alphanumeric; 25 Characters; Mandatory
Specify the minimum payment amount for each commission payment amount.
Note
You can maintain a new record, copy, unlock, delete, authorize and re-open a record in this screen.
Example
The system validates the minimum payment amount specified for each payment currencies during payment processing.
If minimum payment amount is not maintained then the system considers the minimum amount as zero.
Assume that in minimum commission Payment Amount Maintenance screen the payment currency and minimum payment amount is maintained as follows:
Currency |
Minimum Payment Amount |
ZAR |
150 |
USD |
100 |
GBP |
0 |
Then the system will make the broker commission payment as follows:
System uses the default exchange rate for conversion.
This section contains the following topics:
You can invoke the FCIS Broker Currency Preference Summary screen by typing ‘UTSMINPY’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can retrieve a previously entered record in the Minimum Commission Payment Amount Maintenance Summary screen, as follows:
Click ‘Search’ button to view the records. All records with the specified details are retrieved and displayed in the lower portion of the screen.
Note
You can also retrieve the individual record detail from the detail screen by doing query in the following manner:
You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operation by selecting from the Action list.
You can also search the record by using combination of % and alphanumeric value.
You can modify the details of Minimum Commission Payment Amount Maintenance parameters that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:
To view a record that you have previously entered, you must retrieve the same in the Broker Currency Preference Summary screen, as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized Minimum Commission Payment Amount Maintenance record must be authorized in the system for it to be processed. To authorize a record:
When the checker authorizes a record, details of validations, if any, that were overridden by the maker of the record during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the transaction.
After a Minimum Commission Payment Amount Maintenance record is authorized, it can be modified using the Unlock operation from Action list. To make changes to a record after authorization:
An amended Minimum Commission Payment Amount Maintenance record must be authorized for the amendment to be made effective in the system. The authorization of amended records can only be done from Fund Manager Module and Agency branch Module. The process of authorization is subsequently the same as that for normal transactions.
This section contains the following topics:
You can inquire entity commission payment using ‘Entity Commission Payment Inquiry Detail’ screen. You can invoke this screen by typing ‘UTDENCMP’ in the field at the top right corner of the Application tool bar.
You can specify the following details:
Entity Type
Alphanumeric; 1 Character; Optional
Specify the entity type. Alternatively, you can select entity type from the option list. The list displays all valid entity type maintained in the system.
Type of Information
Mandatory
Select the type of information from the drop-down list. The list displays the following values:
Entity ID
Alphanumeric; 12 Characters; Mandatory
Specify the entity ID. Alternatively, you can select entity ID from the option list. The list displays all valid entity ID maintained in the system.
Fund ID
Alphanumeric; 6 Characters; Mandatory
Specify the fund ID. Alternatively, you can select fund ID from the option list. The list displays all valid fund ID maintained in the system.
Payment Number
Numeric; 22 Characters; Optional
Specify the payment number.
Payment From Date
Date Format; Optional
Select the date from when the entity commission payment has to be made from the adjoining calendar.
Payment To Date
Date Format; Optional
Select the date till when the entity commission payment has to be made from the adjoining calendar.
Transaction Number
Alphanumeric; 16 Characters; Optional
Specify the transaction number.
Commission Type
Alphanumeric; 16 Characters; Optional
Specify the type of commission. Alternatively, you can select commission type from the option list. The list displays all valid commission type maintained in the system.
Accrual Date
Date Format; Optional
Select the accrual date from the adjoining calendar.
Click ‘Accrual’ tab in ‘Entity Commission Payment Inquiry Detail’ screen.
After specifying the necessary details, click ‘Find’ button. The system displays the following commission paid details:
Click ‘Accrual’ tab in ‘Entity Commission Payment Inquiry Detail’ screen.
After specifying the necessary details, click ‘Find’ button. The system displays the following commission accrual details: