2.1.13 File format for Detailed Record
This topic explains the information on File format for Detailed Record.
The Detail Record File format is the record of all the Broker details, involved in all the transactions for that day, taken individually. The file containing the Detailed records for all the individual Brokers. The file format used for Detailed records is:
Table 2-39 File format for Detailed Record
| Field Name | Data Type | Details |
|---|---|---|
| Record Category | Number | It is displayed as 00. |
| Transaction Sequence Number | Number | Unique identifier of transaction in the source external interface |
| Product Provider | Character | The code for which the file is processed to calculate commission. For example Unit Trust ‘UT’ |
| Cycle Number | Number | Preceded by zeros |
| Intermediary Code (Sales Code) | Number | The intermediary’s sales code as supplied on the policy proposal / application form. It consists of six digits preceded by zeros. |
| Intermediary Type (Sales Type) | Number | Code for the intermediary who has initiated the sale of that policy;
|
| Intermediary Commission Percentage (Direct Share) | Number | The percentage of commission as indicated in the policy/ application form |
| Intermediary Figure Percentage (Indirect Share) | Numeric | The percentage of indirect commission as indicated in the policy/ application form |
| Sales Centre (branch / team structure code) | Character | An optional field |
| Sale Type | Character | Not applicable can be left blank |
| Policy Number (Contract Number) | Character | It is the Policy or Contract number |
| Policy Type (Contract Type) | Character | Only applicable for recurring business types, can be left blank |
| Policy Term | Number | It is applicable for recurring business only, default set at 01 |
| Product Code | Character | The selection is available from a drop down list |
| Premium Amount | Number | The amount of the premium for a transaction |
| Premium Frequency | Character | You can select from a list, for the type of premium applicable |
| Premium Term | Number | The term for which the premium is applicable |
| Movement Code | Number | It is the number code for the type of transaction |
| Transaction Date | Number | The date on which the transaction takes place |
| Entry Date | Number | The date from which the new business/policy is started |
| Effective Date | Number | The date from which the policy becomes effective |
| Client or Entity Number | Character | It is an optional field |
| Client Name | Character | The name as mentioned in description |
| Fees | Character | Optional field |
| Commission Amount 01 | Number | The commission amount for 1 year |
| Commission Amount 02 | Number | The commission amount for the 2nd year |
| Life Credit | Character | Not mandatory can be left blank |
| Commission Year Indicator | Number | It indicates the year for which the commission is applicable |
| Commission Content | Number | It contains the commission amount for the two years |
| Commission Scaling Factor | Number | The amount agreed between the client and the broker |
| Commission Frequency | Character | It is optional, left blank |
| Commission Type | Character | This field is left blank |
| Current Potential Commission (Primary) | Number | It is applicable for only recurring business, input display shows 000000000000000 |
| Future Potential Commission (Secondary) | Number | It is applicable for only recurring business, input display shows 000000000000000 |
| VAT | Number | It is the value added tax, not required as input |
| Broker Reference | Character | It is the reference as specified on the application form |
| Currency Indicator | Character | It indicates the currency type selected |
| Agents Commission | Number | It is not applicable in this case, displayed as 000000000000000 |
| Commission Allowance | Number | It is the waiver amount on the broker’s commission |
| New Business Date | Number | It is the transaction date |
| Total Investment | Number | It is the total amount of investments |
| Investment Type | Character | An optional field can be left blank |
| Fund Value | Number | It is the sum of the average of the absolute values of the fund of the client |
| Layer type | Character | This field is left blank |
| Layer Number | Number | This field displays 00 |
| Reject ID | Number | This field is not required for entry, it displays 00000000 |
| Adjustment Indicator | Character | This field is not required for entry and is left blank |
| Territory | Character | This field is not required for entry |
| Annual Fund Total | Number | This field is not required for entry, it displays 000000000000000 |
| Distribution Fee (Channel) | Number | This field is not required for entry, it displays 000000000000000 |
| Maximum Commission | Number | This field is not required for entry, it displays 000000000000000 |
| Instance Number | Character | This field is not required for entry |
| BEN Type | Character | This field is not required for entry |
| EMM Client Number | Character | This field is not required for entry |
| Sales Instance | Number | This field is not required for entry, it displays 000 |
| Transaction Instance | Number | This field is not required for entry, it displays 000 |
Parent topic: Fund Rules Upload Formats