5. Managing Brokers

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:

5.1 Broker Type Detail Screen

This section contains the following topics:

5.1.1 Creating Broker Groups

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.

5.1.2 Invoking Broker Type Details Screen

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:

  1. A code that will uniquely identify the broker type, in the Broker Type field.
  2. Descriptive text about the broker type, in the Description field.
  3. The ID of the AMC for which the broker type is applicable, in the AMC ID field.
  4. The commission payment frequency that would apply to any broker mapped to the broker type, in the Payment Details section. Select either Monthly or Bi-Monthly, as applicable.

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.

Basic Information

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.

Payment Details

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:

Contact Details

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.

Email

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.

5.2 Broker Type Summary Screen

This section contains the following topics:

5.2.1 Retrieving Broker Type in Broker Type Summary Screen

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.

Example

You can search the record for Broker Type by using the combination of % and alphanumeric value as follows:

5.2.2 Editing Broker Types

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:

5.2.3 Viewing Broker Types

To view a record that you have previously entered, you must retrieve the same in the Broker Type Summary screen, as follows:

5.2.4 Deleting Broker Types

You can delete only unauthorized records in the system. To delete a record that you have previously entered:

5.2.5 Authorizing Broker Types

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.

5.2.6 Amending Broker Types

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:

5.2.7 Authorizing Amended Broker Types

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.

5.3 Broker Maintenance Detail Screen

This section contains the following topics:

5.3.1 Maintaining Individual Brokers

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.

5.3.2 Specifying Mandatory Information for Creating Broker Record

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:

5.3.3 Saving Broker Record

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:

5.3.4 Invoking Broker Maintenance Detail Screen

 

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.

5.3.5 Broker Details Tab

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 an­other 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.

Individual

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.

Corporate

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.

Payment Details

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 Details

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.

5.3.6 Broker Contact Info Tab

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.

Email

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.

5.3.7 Broker Bank Details Tab

 

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:

Broker Bank 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 Details

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 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 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 Section

Reference 1-2

Alphanumeric; 35 Characters; Optional

Enter the reference details.

5.3.8 Broker Legacy Details Tab

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.

5.3.9 Broker Preference Tab

 

Click ‘Broker Preferences’ tab to enter the details.

Broker Preference 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.

5.3.10 Related Parties Tab

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.

5.3.11 Broker Add Info Tab

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.

5.4 Broker Maintenance Summary Screen

This section contains the following topics:

5.4.1 Retrieving Broker Records in Broker Maintenance Summary Screen

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.

Example

You can search the record for Broker Code by using the combination of % and alphanumeric value as follows:

5.4.2 Editing Broker Records

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:

5.4.3 Viewing Broker Records

To view a record that you have previously entered, you must retrieve the same in the FCIS Broker Maintenance Summary screen, as follows:

5.4.4 Deleting Broker Records

You can delete only unauthorized records in the system. To delete a record that you have previously entered:

5.4.5 Authorizing Broker Records

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.

5.4.6 Amending Broker Records

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:

5.4.7 Authorizing Amended Broker Records

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.

5.4.7.1 Details of Broker Record That Can Be Amended

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:

Example 1

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:

Example 2

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:

Example 3

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.

5.4.8 Amending Broker Details after Transaction Unitization

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:

5.5 Transaction Broker Amendment Screen

This section contains the following topic:

5.5.1 Invoking Transaction Broker Amendment Screen

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:

5.6 Broker Payment Currency Preference Detail Screen

This section contains the following topic:

5.6.1 Invoking Payment Currency Preference Screen

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 Payment Currency preference

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.

Broker Preferred Currency

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.

5.7 FCIS Broker Payment Currency Preference Summary Screen

This section contains the following topics:

5.7.1 Retrieving Broker Payment Currency Preference Summary

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.

Example

You can search the record for Broker Code by using the combination of % and alphanumeric value as follows:

5.7.2 Editing Broker Payment Currency Preference

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:

5.7.3 Viewing Broker Payment Currency Preference

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:

5.7.4 Deleting Broker Payment Currency Preference

You can delete only unauthorized records in the system. To delete a record that you have previously entered:

5.7.5 Authorizing Broker Payment Currency Preference

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.

5.7.6 Amending Broker Payment Currency Preference

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:

5.7.7 Authorizing Amended Broker Payment Currency Preference

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 data­base. 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.

5.8 Broker Migration Screen

This section contains the following topics:

5.8.1 Processing Broker Merger

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”.

5.8.2 Invoking Broker Migration Screen

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.

5.9 Broker Migration Summary Screen

This section contains the following topics:

5.9.1 Retrieving Broker Migration Summary

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.

Example

You can search the record for Source Broker ID by using the combination of % and alphanumeric value as follows:

5.9.2 Viewing Broker Migration

To view a record that you have previously entered, you must retrieve the same in the Broker Migration Summary screen, as follows:

5.10 Broker Journal Detail Screen

This section contains the following topics:

5.10.1 Maintaining Accounting Journal for Broker

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:

5.10.2 Invoking Broker Journal Detail Screen

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.

Payment Details

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.

5.11 Broker Journal Summary Screen

This section contains the following topics:

5.11.1 Retrieving Journal Entry in Broker Journal Summary Screen

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.

Example

You can search the record for Journal Txn Number by using the combination of % and alphanumeric value as follows:

5.11.2 Editing Journal Entry

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:

5.11.3 Viewing Journal Entry

To view a record that you have previously entered, you must retrieve the same in the Broker Journal Summary screen, as follows:

5.11.4 Deleting Journal Entry

You can delete only unauthorized records in the system. To delete a record that you have previously entered:

5.11.5 Authorizing Journal Entry

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.

5.12 Income Distribution Setup Screen

This section contains the following topics:

5.12.1 Setting Up Income Distribution Options for Brokers

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.

5.12.2 Invoking Income Distribution Setup Screen

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

5.13 Raise Broker Commission Screen

This section contains the following topics:

5.13.1 Invoking Raise Broker Commission

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 List

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 List

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.

5.13.2 Calculating VAT Amount

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.TRANSACTION­MODE  =  'A' AND TransactionDetails.BROKER­CODE  <> 'DIRECT' AND TransactionDetails.VATREGISTERED  =  '1'

204

Initial Broker Fee - Rands(Non Vat)

WHERE TransactionDetails.TRANSACTION­MODE  =  'A' AND TransactionDetails.BROKER­CODE  <> 'DIRECT' AND TransactionDetails.VATREGISTERED  =  '0'

205

Initial Broker Fee - Units(Vat)

WHERE TransactionDetails.TRANSACTION­MODE  =  'U' AND TransactionDetails.BROKER­CODE  <> 'DIRECT' AND TransactionDetails.VATREGISTERED  =  '1'

206

Initial Broker Fee - Units(Non Vat)

WHERE TransactionDetails.TRANSACTION­MODE  =  'U' AND TransactionDetails.BROKER­CODE  <> 'DIRECT' AND TransactionDetails.VATREGISTERED  =  '0'

5.14 Commission Payment Status Change Screen

This section contains the following topics:

5.14.1 Invoking Commission Payment Status Change Screen

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.

5.14.2 Search Results Tab

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:

5.14.3 Exchange Rate Source Tab

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.

5.14.4 Exchange Rate Maintenance Tab

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.

5.15 Broker Commission Payment Screen

This section contains the following topic:

5.15.1 Invoking Broker Commission Payment Screen

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.

 

Broker Commission Payment

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.

5.16 Minimum Commission Payment Amount Maintenance Screen

This section contains the following topic:

5.16.1 Invoking Minimum Commission Payment Amount Maintenance

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.

Details

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.

5.17 Minimum Commission Payment Amount Maintenance Summary Screen

This section contains the following topics:

5.17.1 Retrieving Minimum Commission Payment Amount Maintenance Sum­mary

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.

5.17.2 Editing Minimum Commission Payment Amount

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:

5.17.3 Viewing Minimum Commission Payment Amount

To view a record that you have previously entered, you must retrieve the same in the Broker Currency Preference Summary screen, as follows:

5.17.4 Deleting Minimum Commission Payment Amount

You can delete only unauthorized records in the system. To delete a record that you have previously entered:

5.17.5 Authorizing Minimum Commission Payment Amount

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.

5.17.6 Amending Minimum Commission Payment Amount

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:

5.17.7 Authorizing Amended Minimum Commission Payment Amount

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.

5.18 Entity Commission Payment Inquiry Detail

This section contains the following topics:

5.18.1 Invoking Entity Commission Payment Inquiry Detail Screen

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.

5.18.2 Payable Tab

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:

5.18.3 Accrual Tab

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: