1.7.2 Broker Upload Related Information
This topic provides information on broker upload related information.
Serial Number: 1
Segment Identification Number: 00BRO
Description: This segment is used for providing Broker Upload related Information.
Attributes: Mandatory
Table 1-54 Broker Upload Related Information
| Field Name (as expected in the file) | Data type | Length | Attributes | Characteristics/rules | Values |
|---|---|---|---|---|---|
| SEGMENTID | VARCHAR2 | 20 | Mandatory | - | Segment ID. Value for Segment ID is 00BRO |
| SEQUENCENUMBER | NUMBER | 10 | Mandatory | - | Sequence Number |
| PROCESSID | VARCHAR2 | 50 | Mandatory | - | Process ID |
| BULKCLIENTCODE | VARCHAR2 | 12 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Bulk Client Code |
| IMPORTFILENAME | VARCHAR2 | 255 | Mandatory | - | Import File Name |
| UPLOADMODE | VARCHAR2 | 1 | Mandatory | - | Mode of operation which has to be performed on the record |
| BROKERCODE | VARCHAR2 | 12 | Mandatory | - | The code to uniquely identify the broker. |
| BROKERNAME | VARCHAR2 | 105 | Mandatory | - | Name of the broker |
| PARENTBROKERCODE | VARCHAR2 | 12 | Mandatory | - | Represents the parent of the broker. The commission received by the broker is shared with this parent |
| BROKERBASECCY | VARCHAR2 | 3 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Represents the base currency of the broker. Tax and other calculations are done based on this currency |
| AMCID | VARCHAR2 | 12 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | AMC ID |
| DELETEDSTATUS | NUMBER | 1 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Flag to identify whether the broker record is in any of these states :
|
| OVERRIDDENTAXPERCENTA GE | NUMBER | 156 | Mandatory | - | The tax percentage applicable for the broker can be overridden here |
| USERID | VARCHAR2 | 15 | Mandatory | - | Represents the user ID who has entered the latest record |
| LEVELNUMBER | NUMBER | 3 | Optional | - | Represents at which level the broker is in the parent broker hierarchy. The top parent will have level number 0 |
| RULEEFFECTIVEDATE | DATE | 10 | Mandatory | - | The date from which the changes are applicable. This along with broker code forms the PRIMARY KEY |
| CHANGETYPE | VARCHAR2 | 1 | Optional | - | This column is not used |
| VATREGISTERED | NUMBER | 1 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Represents whether the broker is VAT Registered broker or not. If the broker is VAT registered then VAT will be applicable on the commission amount he gets |
| VATREGISTRATIONNUMBER | VARCHAR2 | 15 | Mandatory | - | Represents the VAT Registration number of the broker |
| COMMISSIONPERCENTAGE | NUMBER | 52 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Represents how much percentage commission should be shared with his parent broker. If the broker is the top level broker then this value should be 100 |
| COMMISSIONPAYMENTFREQ | VARCHAR2 | 1 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Indicates at what frequency the commission should be paid to the broker |
| UNITHOLDERID | VARCHAR2 | 12 | Mandatory | - | Represents the default unit holder of the broker |
| NEXTPAYMENTDATE | DATE | 10 | Mandatory | - | Indicates the next payment date of the broker. Commission accumulated from last payment date to till this date will be paid on this date |
| BROKERTYPE | VARCHAR2 | 6 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Represents the type of the broker; user can define broker type throught broker type maintenance |
| USEBROKERTYPEPAYMENTD ATES | NUMBER | 1 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Flag to identify whether the payment details based in the broker type maintenance or not |
| BROKERCONSULTANT | VARCHAR2 | 40 | Mandatory | Value defaulted as maintained in Bulk client defaults in the absence of information in the file | Represents broker consultant name |
| BROKERCATEGORY | VARCHAR2 | 1 | Mandatory | - | Represents the category of the broker, whether Individual or Corporate |
| HOLDBACKPAYMENT | NUMBER | 1 | Mandatory | - | Flag to identify whether the payment should be kept hold for the broker |
| MOD_NO | NUMBER | 10 | Optional | - | Represents the number of times the record got modified |
| HOLDPYMTFROMDATE | DATE | 10 | Mandatory | - | Represents the payment hold back from date |
| BROKERSTATUS | VARCHAR2 | 1 | Mandatory | - | Represents whether the broker is in normal or weeded status |
| REPLICATEPARENTDET | CHAR | 1 | Mandatory | - | Flag to identify whether the details of the parent broker should be replicated or not. If this is true then the parent brokers data will be defaulted based on the template maintained |
| VATREGISTRATIONDATE | DATE | 10 | Mandatory | - | Represents from when the broker got VAT registered |
| TEMPLATEID | VARCHAR2 | 6 | Mandatory | - | Represents the template ID to replicate the parent details, the fields available in template will be replicated to child broker if REPLICATEPARENTDET flag is set to true |
| NATIONALITY | VARCHAR2 | 3 | Mandatory | - | Nationality of the broker |
| COUNTRYOFBIRTH | VARCHAR2 | 3 | Mandatory | - | Birth country of the broker |
| COUNTRYOFDOMICILE | VARCHAR2 | 3 | Mandatory | - | Country of domicile of the broker |
| INCORPORATIONCOUNTRY | VARCHAR2 | 3 | Mandatory | - | The country of the corporate |
| TAXID | VARCHAR2 | 50 | Mandatory | - | Tax identification |
| EIN | VARCHAR2 | 50 | Mandatory | - | Employer ID number |
| TAXCERTIFICATEEFFEDATE | DATE | 10 | Mandatory | - | Tax certificate effective Date |
| TAXCERTIFICATEEXPDATE | DATE | 10 | Mandatory | - | Tax certificate expiry Date |
| TAXCIRCLE | VARCHAR2 | 3 | Mandatory | - | Name of the Place |
| VATEXPIRYDATE | DATE | 10 | Optional | - | Represents the expiry date for VAT registered flag |
Parent topic: Broker File Format