2.5 Broker Upload Format
This topic explains the information on Broker Upload Format.
The upload file would contain various segment identification number in the first column to indicate the type of data that is present in that entire row. The possible segments that would be used in Broker upload are given below for reference:
This topic explains the systematic instructions on Broker Upload Format.The upload file would contain various segment identification number in the first column to indicate the type of data that is present in that entire row. The possible segments that would be used in Broker upload are given below for reference:
Segment ID - 00BRO
This segment will be mandatory for incremental upload
Table 2-46 Broker Upload Format - 00BRO
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 00BRO |
| SEQUENCENUMBER | Y | - | Unique |
| PROCESSID | Y | - | Unique |
| BULKCLIENTCODE | Y | - | Unique |
| IMPORTFILENAME | Y | - | Unique |
| UPLOADMODE | Y | - | I |
| BROKERCODE | Y | - | Valid broker code |
| BROKERNAME | N | Yes | - |
| PARENTBROKERCODE | N | Yes | - |
| BROKERBASECCY | N | Yes | - |
| AMCID | N | Yes | - |
| AUTH_STAT | Y | Yes | U/A |
| DELETEDSTATUS | N | Yes | - |
| OVERRIDDENTAXPERCENTAGE | N | Yes | - |
| USERID | Y | Yes | Represents the user ID who has entered the latest record |
| LEVELNUMBER | N | Yes | - |
| RULEEFFECTIVEDATE | Y | Yes | - |
| CHANGETYPE | N | Yes | - |
| VATREGISTERED | N | Yes | - |
| VATREGISTRATIONNUMBER | N | Yes | - |
| COMMISSIONPERCENTAGE | N | Yes | - |
| COMMISSIONPAYMENTFREQ | N | Yes | - |
| UNITHOLDERID | N | - | - |
| LASTPAYMENTDATE | N | - | - |
| LASTPAYMENTNUMBER | N | - | - |
| LASTPROCESSEDDATE | N | - | - |
| NEXTPAYMENTDATE | N | - | - |
| BROKERTYPE | N | - | - |
| USEBROKERTYPEPAYMENTDATES | N | - | - |
| BROKERCONSULTANT | N | - | - |
| BROKERCATEGORY | N | - | - |
| HOLDBACKPAYMENT | N | - | - |
| MOD_NO | N | - | - |
| HOLDPYMTFROMDATE | N | - | - |
| LATESTRULE | N | - | - |
| BROKERSTATUS | N | - | - |
| RECORD_STAT | N | - | - |
| ONCE_AUTH | N | - | - |
| REPLICATEPARENTDET | N | - | - |
| VATREGISTRATIONDATE | N | - | - |
| TEMPLATEID | N | - | - |
| USINDICIAAVAILABLE | N | - | - |
| FATCASTATUS | N | - | - |
| NATIONALITY | N | - | - |
| COUNTRYOFBIRTH | N | - | - |
| COUNTRYOFDOMICILE | N | - | - |
| INCORPORATIONCOUNTRY | N | - | - |
| TAXID | N | - | - |
| EIN | N | - | - |
| TAXCERTIFICATEEFFEDATE | N | - | - |
| TAXCERTIFICATEEXPDATE | N | - | - |
| TAXCIRCLE | N | - | - |
| FATCACLASSIFICATION | N | - | - |
| GIIN | N | - | - |
| VATEXPIRYDATE | N | - | - |
Segment ID - 01CON
Table 2-47 Broker Upload Format - 01CON
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 01CON |
| SEQUENCENUMBER | Y | - | Unique |
| PROCESSID | Y | - | Unique |
| ENTITYID | N | - | - |
| ENTITYTYPE | N | - | - |
| ADDRESSTYPE | Y | If address type present in file is available in system, system will be updated with remaining details present in file.If Address type present in file is not available in system, new address type will be added with details as available in file | |
| ADDRESSLINE1 | N | Y | - |
| ADDRESSLINE2 | N | Y | - |
| ADDRESSLINE3 | N | Y | - |
| ADDRESSLINE4 | N | Y | - |
| ZIPCODE | N | Y | - |
| COUNTRY | N | Y | - |
| USSTATE | N | Y | - |
| TELEPHONE1 | N | Y | - |
| TELEPHONE2 | N | Y | - |
| CELLPHONENUMBER | N | Y | - |
| FAX | N | Y | - |
| N | Y | - | |
| CONTACTPERSON | N | Y | - |
| EFFECTIVEFROMDATE | N | Y | - |
| EFFECTIVETODATE | N | Y | - |
| BICCODE | N | Y | - |
| RULEEFFECTIVEDATE | Y | Y | - |
| INTDIALLINGCODEFAX | N | Y | - |
| INTDIALLINGCODEPH2 | N | Y | - |
| INTDIALLINGCODEPH1 | N | Y | - |
| INTDIALLINGCODECELL | N | Y | - |
Table 2-48 Broker Upload Format - 02BAN
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 02BAN |
| SEQUENCENUMBER | Y | - | Unique |
| PROCESSID | Y | - | Unique |
| BROKERCODE | N | - | - |
| RULEEFFECTIVEDATE | Y | - | - |
| REFERENCENUMBER | N | - | - |
| BANKCODE | Y | - | If bank/branch/ account type/ account number/ account ccy combination provided in file exists in system- other details will be updated.If does not exist, record will be inserted in system |
| BRANCHCODE | Y | - | - |
| ACCOUNTTYPE | Y | - | - |
| ACCOUNTNUMBER | Y | - | - |
| ACCOUNTNAME | Y | - | - |
| ACCOUNTCURRENCY | Y | - | - |
| DEFAULTDETAILS | Y | Y | - |
| DIRECTDEBITAPPLICABLE | N | Y | - |
| SWIFTFORMAT | N | Y | - |
| BANKCHARGED | N | Y | - |
| BENEFICIARY | N | Y | - |
| BENEFICIARYADD1 | N | Y | - |
| BENEFICIARYADD2 | N | Y | - |
| BENEFICIARYADD3 | N | Y | - |
| BENEFICIARYBICCODE | N | Y | - |
| BENEFICIARYACCTNO | N | Y | - |
| BENEFICIARYCODE | N | Y | - |
| BENEFICIARYINFO | N | Y | - |
| INTERMEDIARY | N | Y | - |
| INTERMEDIARYADD1 | N | Y | - |
| INTERMEDIARYADD2 | N | Y | - |
| INTERMEDIARYADD3 | N | Y | - |
| INTERMEDIARYBICCODE | N | Y | - |
| INTERMEDIARYACCTNO | N | Y | - |
| INTERMEDIARYCODE | N | Y | - |
| INTERMEDIARYINFO | N | Y | - |
| FURTHERCREDITNAME | N | Y | - |
| FURTHERCREDITACCTNO | N | Y | - |
| REFERENCE1 | N | Y | - |
| REFERENCE2 | N | Y | - |
| IBAN | N | Y | - |
| BENEFICIARYIBAN | N | Y | - |
| INTERMEDIARYIBAN | N | Y | - |
Segment ID - 05ADD
Table 2-49 Broker Upload Format - 05ADD
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 05ADD |
| SEQUENCENUMBER | Y | - | Unique |
| PROCESSID | Y | - | Unique |
| ADDINFOLABEL | Y | - | - |
| FIELDVALUE | N | Y | - |
Parent topic: Appendix B - Upload File Formats B