BSE
20061214-2 dtd. 14-Dec-2006
BSE UCC System in new BSE Webx system ( www. bsewebx.co.in)
The Members of the Exchange are currently uploading the UCC (Unique Client Code) data using BAT and iBAT (www.bsewebx.com). BSE is in the process of enhancing the UCC system into the new BSEWebx system i.e., www.bsewebx.co.in and accordingly needs few changes. Some of the salient features of the new UCC module is given below
1. The current system will not accept “%” (percentage),“|”(pipe) and “,”(comma) in the client code field.
2. A new UCC system provides Batch Upload/Download option, Add/Modify UCC and BAT User Report.
3. For retrieving the data, members are provided with the option of downloading the data from the system based on search criteria i.e., “UCC Code” or “UCC name” or “City”. Search on created date and modified date is also available. Members ca... + Read more
The Members of the Exchange are currently uploading the UCC (Unique Client Code) data using BAT and iBAT (www.bsewebx.com). BSE is in the process of enhancing the UCC system into the new BSEWebx system i.e., www.bsewebx.co.in and accordingly needs few changes. Some of the salient features of the new UCC module is given below
1. The current system will not accept “%” (percentage),“|”(pipe) and “,”(comma) in the client code field.
2. A new UCC system provides Batch Upload/Download option, Add/Modify UCC and BAT User Report.
3. For retrieving the data, members are provided with the option of downloading the data from the system based on search criteria i.e., “UCC Code” or “UCC name” or “City”. Search on created date and modified date is also available. Members can also download all UCC data.
4. Modification of UCC records is possible using the batch upload facility.
5. PAN will be compulsory for registering any UCC.
In this connection, the members and the respective back office vendors are hereby informed that due to the change in the system the batch upload file format for the new UCC system has changed and hence you are requested to make necessary changes in your system while generating the file. The file format for the same is given below :
UCC File Format
New/Modify |SubBATUser|Equity |Derivative| Reserved1 |Reserved2 | Reserved3|Client Code| Status| Category| Name of client| Last Name|First Name| Middle Name| Address| City| State |Country |Pin Code |STD Code| Telephone Number| Email Id |MAPIN |PAN Number| Registration Number | Registering Authority| Place of Registration |Date of Registration| Passport Number| Place of Issue |Date of Issue| Driving License No | DL Place of Issue | DL Date of Issue | Voter Id No | Place of Issue | Date of Issue | Ration Card No | Place of Issue | Date of Issue | Bank Name | Bank Branch Address | Bank Account type | Bank Account No | Depository Name | Depository Participant | Demat Id. Of client | Remarks |Introducers Name | Sub-broker Code | Date of Birth | Client Agreement Date | Client with Other member | Is Active
Description
Attribute Null Max
Allowed Size Description
New/Modify No 1 A N for new and M for Modified
Sub BATUser Yes 11 Webx Sub-Bat user code
Equity (*) No 1 A Y / N for Equity member
Derivative (*) No 1 A Y / N for Derivative Member
Reserved1 Yes 0 Will be null
Reserved2 Yes 0 Will be null
Reserved3 Yes 0 Will be null
Client Code No 11 AN 1) “%”,“|” and “,” will not be accepted.
2) Case Insensitive
Status No 11 A OW/CL/IN
OW - OWN
CL - CLIENT
IN - INSTITUTION
Category No 15 A HUF/PF/MF/NT/CO/I/MB/FII/IFI/B/SP/NRI/OCB/INS/O
Name of client Yes 100 AN
Last Name Yes 50 A Null allowed if Non Individual Client
First Name Yes 50 A Null allowed if Non Individual Client
Middle Name Yes 50 A
Address No 250 AN
City No 25 A
State No 25 A
Country No 25 A
Pin Code No 10 AN
STD Code No 10 N
Telephone Number No 15 N
Email Id Yes 50 AN
MAPIN Yes 20 AN
PAN Number No 10 AN
Registration Number Yes 50 AN
Registering Authority Yes 50 AN
Place of Registration Yes 50 AN
Date of Registration Yes 10 AN DD/MM/YYYY
Passport Number Yes 50 AN
Place of Issue Yes 50 AN
Date of Issue Yes 10 AN DD/MM/YYYY
Driving License No Yes 50 AN
Place of Issue Yes 50 AN
Date of Issue Yes 10 AN DD/MM/YYYY
Voter Id No. Yes 50 AN
Place of Issue Yes 50 AN
Date of Issue Yes 10 AN DD/MM/YYYY
Ration Card No Yes 50 AN
Place of Issue Yes 50 AN
Date of Issue Yes 10 AN DD/MM/YYYY
Bank Name Yes 50 AN
Bank Branch Address Yes 200 AN
Bank Account type Yes 20 AN Saving/Current/Others
Bank Account No Yes 20 AN
Depository Name Yes 50 AN CDSL/NSDL
Depository Participant Yes 50 AN
Demat Id. Of client Yes 50 AN
Remarks Yes 200 AN
Introducers Name Yes 50 AN
Sub-broker Name Yes 50 A
Date of Birth Yes 10 AN DD/MM/YYYY
Client Agreement Date Yes 10 AN DD/MM/YYYY
Client with Other member Yes 1 A Y or N
Is Active No 1 A Y or N
(*) Equity & Derivative column – Both cannot be “N”.
#A – Alpha
#N – Numeric
Column Level Validation
Attribute Validation
Equity Y cannot not be set to N
Derivative Y cannot not be set to N
Client Code 1) Maximum 11 Alphanumeric
2) “%” “|”,”,” will not be accepted.
3) Case Insensitive
4) Once record created cannot be modified.
Status Status Category
OW - CO, I (Individual) & O(Others)
CL - HUF, PF, NT, Co, I, MB, SP, OCB, NRI, O(Others)
IN - MF, FII, IFI, B, INS
Category Mandatory
Name of client Optional when Category is I, SP & NRI
First Name Not Optional when category is I, SP & NRI
Address Mandatory
City Mandatory
State Mandatory
Country Mandatory
Pin Code Should be 6 digits if the country is India
STD Code Mandatory
Telephone Number Mandatory
PAN Number Mandatory (10 AlhpaNumeric)
Date of Birth Not Optional when category is I, SP & NRI
Date of Registration Optional when Category is I, SP & NRI
Date All date fields will be validated for DD/MM/YYYY format and the date
should be less than or equal to the current date.
Members are hereby informed that BSE is planning to make this UCC system live very shortly and, hence, requested to make the necessary changes in their back office system.
As the exchange is in the process of enhancing the UCC system there are certain changes which the member are required to note at the time of uploading the UCC details through the new UCC system.
As the exchange is in the process of enhancing the UCC system there are certain changes which the member are required to note at the time of uploading the UCC details through the new UCC system.
N.A.