File Uploader Link :

https://bow1uploads.bseindia.com
Notes :

* File uploader timing will be 5.30 pm to 8.00 am.

* You can upload user deposit and user stock file during market hours and rest file can be uploaded in the scheduled time.
* File should be upladed in csv format or txt format.
* If you create the file in txt format rather that xls format, it will help you get faster response while uploading.
* Request you to verify file format before uploading.
* Request you to upload correct file in correct option.
* Compulsary fields has been defined as "NOT NULL" in all the give file formats.

IBT User Addition

Dealer Addition
Offline User Addition
Client Dealer Mapping
Client Deposits Upload
Stocks / Holding Uploads
Location ID/NNF Uploads
Trading Rights Uploads
Risk Preffrence Uploads
Contract Margin Uploads
Rights Limits Uploads
Profile Mapping Uploads
SLB Holding Uploads
PAN Update
Only DP Upload
Combined DP Upload with T1 Pool Holding
Only T1 Pool Holding
Bank Upload

BSE - PUBLIC
Client ID/Login ID Owner Id Client ID/Login ID
NOT NULL NOT NULL NOT NULL
varchar(100) varchar(100) varchar(100)

This field contain Owner Id which

This field contain Client means either admin Id like T1001 This field contain Client
code which Is or Mini admin Id like miniadmin- code which Is registered
registered in UCC. T1001 in UCC.

Sample :
A1001,T1001,A1001,1,Password$123,Amol,Modi,abc@gmail.com,N,8369990000,,DUMMY1234A,
A1002,T1001,A1001,1,Password$123,Shankar,Jadhav,xyz@gmail.com,N,8569385000,,DUMMY1234B,

Notes :

* Admin need to select permissions among 1. Login through Thick Client, 2. Login through Web or 3. Login through Mobile wh
* Admin can upload this file from upload menu : INTERNET RETAIL CLIENTS
* Client id length should be less than or equal to 10 characters.
* Password should not be blank
* Donot upload files with headers

BSE - PUBLIC
 User Type Password First Name
NOT NULL NOT NULL NOT NULL
varchar(10) varchar(100) varchar(62)

This field contain password for the user.

This field contain user type. Password must be minimum 8 digit
While creating the client you including 1 Alphabet, 1 Special Character This field contain first
need to enter 1 in this field. and numeric value. name of the client

90000,,DUMMY1234A,
69385000,,DUMMY1234B,

Login through Web or 3. Login through Mobile while uploading IBT user addition file.

BSE - PUBLIC
Last Name Email Id Default Marketwatch Mobile No
NOT NULL NOT NULL NOT NULL NOT NULL
varchar(62) varchar(62) char(1) varchar(14)

This field contain last This field consist email id of This field contain default This field contain client /
name of the client the client / user. field 'N'. dealer mobile number.

BSE - PUBLIC
Default Role (Blank) Pan Card No Broker Id (Blank)
NULL NOT NULL NULL
varchar(100) varchar(100) varchar(10)

This field can be kept as This field consist pan card This field can be kept as
blank. number of the client / dealer. blank.

BSE - PUBLIC
Dealer Id Owner Id Dealer Id User Type
NOT NULL NOT NULL NOT NULL NOT NULL
varchar(100) varchar(100) varchar(100) varchar(10)
This field contain Owner Id
This field contain Dealer This field contain This field contain user type.
which means either admin Id
ID which Is registered in Dealer ID which Is While creating the client you
like T1001 or Mini admin Id
UCC. registered in UCC. need to enter 2 in this field.
like miniadmin-T1001

Sample :
DEALER1,T1001,DEALER1,2,password,Amol,Modi,abc@gmail.com,N,8369990000,,DUMMY1234A,
DEALER2,T1001,DEALER2,2,password,Shankar,Jadhav,xyz@gmail.com,N,8569385000,,DUMMY1234B,

Notes :

* Admin need to select permissions among 1. Login through Thick Client, while uploading Dealer Id addition file.
* Admin can upload this file from upload menu : DEALERS / EMPLOYEE
* Dealer cannot login from BOW1 mobile application.
* Dealer id length should be less than or equal to 10 characters.
* Password should not be blank
* Donot upload files with headers

BSE - PUBLIC
 Password First Name Last Name Email Id
NOT NULL NOT NULL NOT NULL NOT NULL
varchar(100) varchar(62) varchar(62) varchar(62)
This field contain password for the user.
This field contain This field contain
Password must be minimum 8 digit This field consist
first name of the last name of the
including 1 Alphabet, 1 Special email id of the dealer.
dealer. dealer.
Character and numeric value.

addition file.

BSE - PUBLIC
Default MarketwatchMobile No Default Role (Blan Pan Card No
NOT NULL NOT NULL NULL NOT NULL
char(1) varchar(14) varchar(100) varchar(100)

This field contain client This field consist pan

This field contain This field can be
/ dealer mobile card number of the
default field 'N'. kept as blank.
number. client / dealer.

BSE - PUBLIC
Broker Id (Blank)
NULL
varchar(10)

This field can be kept as

blank.

BSE - PUBLIC
Client ID/Login ID Owner Id Client ID/Login ID
NOT NULL NOT NULL NOT NULL
varchar(100) varchar(100) varchar(100)

This field contain Client This field contain Owner Id which means This field contain Client
code which Is registered either admin Id like T1001 or Mini admin code which Is
in UCC. Id like miniadmin-T1001 registered in UCC.

Sample :
A1001,T1001,A1001,1,password,Anita,Shetty,xyz@mail.com,N,8369990000,,DUMMY1234A,
A1002,T1001,A1002,1,password,Arun,Gupta,xyz@mail.com,N,8369990001,,DUMMY1234B,
A1003,T1001,A1003,1,password,Akash,Patel,xyz@mail.com,N,8369990002,,DUMMY1234C,

Notes :

* Admin don’t need to select any login permission while uploading CTCL / Offline User Id addition file.
* Admin can upload this file from upload menu : OFFLINE CLIENTS.
* CTCL / Offline client cannot login from any BOW1 application portal.
* Client id length should be less than or equal to 10 characters.
* Password should not be blank
* Donot upload files with headers

BSE - PUBLIC
 User Type Password First Name
NOT NULL NOT NULL NOT NULL
varchar(10) varchar(100) varchar(62)

This field contain password for the user.

This field contain user type. Password must be minimum 8 digit
While creating the client you including 1 Alphabet, 1 Special Character This field contain first
need to enter 1 in this field. and numeric value. name of the client

MMY1234A,
MMY1234B,
MMY1234C,

e User Id addition file.

BSE - PUBLIC
Last Name Email Id Default MarketwatcMobile No Default Role (Blank)
NOT NULL NOT NULL NOT NULL NOT NULL NULL
varchar(62) varchar(62) char(1) varchar(14) varchar(100)

This field contain

This field contain last This field consist email This field contain client / dealer This field can be kept
name of the client id of the client / user. default field 'N'. mobile number. as blank.

BSE - PUBLIC
Pan Card No Broker Id (Blank)
NOT NULL NULL
varchar(100) varchar(10)

This field consist pan

card number of the This field can be
client / dealer. kept as blank.

BSE - PUBLIC
Client ID Employee ID/Dealer Id
NOT NULL NOT NULL
This field contain client Id. This field contain Dealer Id.

Sample :
A1001,DEALER1
A1002,DEALER1
A1002,DEALER2

Note:

*Single Client can also mapped with multiple Dealers

* Donot upload files with headers

BSE - PUBLIC
Client ID Filler Exchange Market Total Deposit
NOT NULL NULL NOT NULL NOT NULL NOT NULL

This field contain

This field contain market like equity,
This field contain This field should be exchange i.e. BSE, derivatives, This field contain
Client id. blank NSE, MCX, NCDEX currency etc deposit amount.

Sample :
A1001,,BSE,EQ,16000,0,0,0,securities,1,0,,,,,1,0,0,1,Y,Delivery
A1002,,BSE,EQ,25000,0,0,0,securities,1,0,,,,,1,0,0,1,Y,Intraday
A1003,,,,25000,0,0,0,securities,1,0,,,,,1,0,0,1,Y,Intraday

Notes :

* Donot upload files with headers

BSE - PUBLIC
Filler Filler Filler Category Factor
NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

This field contain

category like
This field should be This field should be This field should be Securities, This field contain
have "0" have "0" have "0" commodities factor/ Multiplier

BSE - PUBLIC
Adhoc Margin Filler Filler Filler Filler
NOT NULL NULL NULL NULL NULL

This field contain This field should be This field should be This field should be This field should be
adhoc margin. blank blank blank blank

BSE - PUBLIC
Add Adhoc Flag Mark to Market FactEffective Amount Add Adhoc to MTM Add entry flag
NULL NULL NULL NULL NOT NULL

This field contain This field contain This field contain This field contain
add adhoc flag. mark to market This field contain add MTM flag. add entry flag.
FLAG(0 - no,1 - yes) factor/ multipler effective amount. FLAG(0 - no,1 - yes) FLAG(N- no, Y - yes)

BSE - PUBLIC
Product
NOT NULL

This field contain

product i.e.
delivery, intra etc.

BSE - PUBLIC
Client ID BSE / NSE Symbol Series Quantity
NOT NULL NOT NULL NOT NULL NOT NULL
This field represents the Client This field contain Bse / This field contain Holding qty
code. Nse Symbol. series like EQ, BE etc. (from DP)

Sample
A1001,ABB,EQ,100,0,500002
A1001,SBIN,EQ,75,0,500112
A1001,RPL,EQ,17,0,532743
A1002,BPCL,EQ,200,0,500547
A1002,BEL,EQ,25,0,500049
A1002,,EQ,25,0,506906

Notes :

* Donot upload files with headers

BSE - PUBLIC
FILLER BSE Scrip Code
NULL NOT NULL
0 This field contain BSE Scrip
Code.

BSE - PUBLIC
 Exchange Market Trader Id
NOT NULL NOT NULL NOT NULL

This field contain trader id for

This field contain market like the defined exchange and
This field contain exchange like
equity, derivatives, slb, itp, market. Trade Id list for BSE has
Bse, Nse, Mcx etc
commodities etc been given below for your
reference.

Sample :
BSE,EQUITY,123400901,1234,4000010001001012,DEALER1
BSE,EQUITY,123400901,1234,1111111111111012,A1001
BSE,DERIVATIVE,123400902,1234,1111111111111012,A1001
BSE,CURRENCY,123410001,1234,1111111111111012,A1002
BSE,COMMODITIES,123410003,1234,1111111111111012,A1002
NSE,EQUITY,2323,07667,444444001001116,DEALER 2
NSE,DERIVATIVE,12266,07667,444444001001116,DEALER2
NSE,CURRENCY,6396,07667,444444001001116,DEALER2
NSE,COMMODITIES,2356,07667,444444001001116,DEALER2
MCX,COMMODITIES,12346,12345,400001001001013,DEALER2
NCDEX,COMMODITIES,29454,0020,400001001001002,USER6

Trader Ids list for BSE

EXCHANGE SEGMENT MEMBER ID (example)
BSE EQUITY 1001
BSE DERIVATIVE 1001
BSE CURRENCY 1001
BSE COMMODITIES 1001
BSE SLB 1001
BSE ITP 1001
BSE OFS 1001
BSE MF 1001
BSE DEBT 1001

Trader Ids list for Other Exch

EXCHANGE SEGMENT MEMBER ID (example)
NSE EQUITY 07667
NSE DERIVATIVE 07667
NSE CURRENCY 07667
NSE COMMODITIES 07667

MCX COMMODITIES 40125

NCDEX COMMODITIES 00020

BSE - PUBLIC
Notes :

* Donot upload files with headers

BSE - PUBLIC
 Broker Id Location ID Dealer ID/Client ID
NOT NULL NOT NULL NOT NULL

This field contain ctcl / terminal

This field contain broker id for This field contain login id of
Id which is been registered in
the defined exchange. Client / Dealer.
the exchange platform.

Trader Ids list for BSE

TRADER ID Program Trading Flag Vendor Code
100100901 0 12
100100902 0 12
100110001 0 12
100110003 0 12
301 0 12
701 0 12
601 0 12
401 0 12
501 0 12

Trader Ids list for Other Exchange

TRADER ID Program Trading Flag Vendor Code
2323 1 16
12266 1 16
6396 1 16
2356 1 16

40128 0 13

29454 0 02

BSE - PUBLIC
BSE - PUBLIC
Sample Location ID
4000010001001012
4000010001001012
4000010001001012
4000010001001012
4000010001001012
4000010001001012
4000010001001012
4000010001001012
4000010001001012

Sample Location ID
444444001001116
444444001001116
444444001001116
444444001001116

400001001001013

400001001001002

BSE - PUBLIC
BSE - PUBLIC
Client ID Default Default Permission

NOT NULL NULL NULL NOT NULL

This field contain This field contain This field contain This field contain trading
Client Id. default value 1. default value 1. rights Permission.

Sample :
A1001,1,1,NNNNNNNNNNNY,SECURITIES,,EQUITY,EQUITY,,,,,,,BLOCKED,,N
A1001,1,1,NNNNNNNNNNNY,SECURITIES,BSE,EQUITY,EQUITY,,,,,,,BLOCKED,,N
A1002,1,1,NNNNNNNNNNNY,SECURITIES,NSE,EQUITY,EQUITY,,,,,,,BLOCKED,,N
A1002,1,1,NNNNNNNNNNNY,commodities,MCX,COMMODITIES,commodities-futures,,,,,,,BLOCKED,,N
A1002,1,1,NNNNNNNNNNNY,SECURITIES,NSE,DERIVATIVE,,,,,31 DEC 2020,,,Far Expiry blocked,,N

Notes :

* Donot upload files with headers

* To Delete records via file upload you can add "y" at 17th Position to delete old uploaded records
* Below are combination user can set trading rights

User→Category→Exchange→Market->Segment(Product+NULL)
User->Category->Exchange->Market->Segment(Product+NULL)->Instrument
User->Category->Exchange->Market->Segment(Product+NULL)->Instrument->Symbol
User->Category->Exchange->Market->Segment(Product+NULL)->Instrument->Symbol->ExpiryDate
User->Category->Exchange->Market->Segment(Product+NULL)->Symbol->ExpiryDate
User→Category→Exchange→Market→Segment(Product+NULL)→Symbol→Series
User->Category->Exchange->Market->Segment(Product+NULL)->Series
User→Category→Exchange→Market->Segment(Product+Current Segment Value)
User->Category->Exchange->Market->Segment(ALL)->Symbol
User->Category->Exchange->Market->Segment(Product)->Symbol
User->Category->Exchange->Market->Segment(ALL)->Instrument->ExpiryDate
User->Category->Exchange->Market->Segment(Product)->Instrument->ExpiryDate
User->Category->Exchange->Market->Segment(ALL)->ExpiryDate

BSE - PUBLIC
User->Category->Exchange->Market->Segment(Product)->ExpiryDate

BSE - PUBLIC
 Category Exchange Market Segment

NOT NULL NOT NULL NOT NULL NULL

This field contain category This field contain This field contain market like This field contain segment
like Securities, commodities exchange i.e. BSE, equity, derivatives, currency like equity, futures, options
etc NSE, MCX, NCDEX etc etc.

res,,,,,,,BLOCKED,,N
piry blocked,,N

ploaded records

Blocking based on instument

Blocking based on instument andSymbol
bol->ExpiryDate Blocking based on instument Symbol and expiry
Blocking based on Symbol and expiry
Blocking based on symbol and series
Blocking based on series
Blocking Product and segment
BAN Stock based on symbol with product
BAN Stock based on symbol with product
Expiry level blocking with instrument
Expiry level blocking with instrument and product
Expiry Level blocking

BSE - PUBLIC
Expiry level blocking with segment and product

BSE - PUBLIC
Symbol Series Instrument Name

NULL NULL NULL

This field contain symbol if

This field contains series i.e. This field contain
you wish to block or allow
EQ, BE etc instrument type
particular scrip code.

BSE - PUBLIC
Expiry Date Strike Price Opt Type

NULL NULL NULL

This field contain expiry date if you This field contain strike price if
This field contain opt
will to allow / block particular expiry you wish to allow / block
type I.e. CE/PE
of contract. particular stirke price.

BSE - PUBLIC
 Delete
Remarks Product
Flag
NULL NULL NULL

It Should
be "N" for
This field new
contain addition.
Admin can put remark in this
exchange OrElse "Y"
field mentioning why he block
i.e. to Delete
this client.
Intraday, that same
Delivery record
from
database

BSE - PUBLIC
 Client Code Exchange Market Product Consider Realised Profit

NOT NULL NOT NULL NOT NULL NOT NULL NOT NULL

This field contain value

This field contain This field contain
This field contain which Consider Realised
This field contain market like equity, product i.e.
exchange i.e. BSE, Profit.
Client code. derivatives, Intraday or
NSE, MCX, NCDEX [1/2/3-->1=MARGIN,
currency etc delivery.
2=MTM , 3=BOTH ]

Sample :
A1001,ALL,ALL,ALL,2,2,1,1,2,1,2,1,3,,,,,,
A1001,BSE,COMMODITIES,INTRADAY,3,1,2,1,3,1,2,1,3,,,,,,1
A1001,MCX,EQUITY,DELIVERY,3,1,2,1,3,2,2,3,2,,,,,,

Note:

* Donot upload files with headers

* To Delete records via file upload you can add 1 at 19th Position to delete old uploaded records

BSE - PUBLIC
Consider Realised Loss Consider Unrealised Profit Consider Realised Loss

NOT NULL NOT NULL NOT NULL

This field contain value This field contain value

This field contain value which
which consider realised which consider realised
consider unrealised profit.
loss. loss.
[1/2/3-->1=MARGIN,
[1/2/3-->1=MARGIN, [1/2/3-->1=MARGIN,
2=MTM , 3=BOTH ]
2=MTM , 3=BOTH ] 2=MTM , 3=BOTH ]

BSE - PUBLIC
 Consider Realised P&L for Consider Unrealised P&L for Consider UnRealised P&L For
Options Option Buy Options SELL

NOT NULL NOT NULL NOT NULL

This field contain value which This field contain value which
This field contain value which
consider unrealised P&L for consider unrealised P&L for
consider reliased P&L for options.
options buy. options sell
[1/2/3-->1=MARGIN, 2=MTM ,
[1/2/3-->1=MARGIN, 2=MTM , [1/2/3-->1=MARGIN, 2=MTM ,
3=BOTH ]
3=BOTH ] 3=BOTH ]

BSE - PUBLIC
 Consider Net Realised Loss Consider Net UnRealised Loss Filler 1 Filler 2

NOT NULL NOT NULL NULL NULL

This field contain value which This field contain value which
consider net realised loss. consider net unreliased loss. This field you can This field you can
[1/2/3-->1=MARGIN, 2=MTM , [1/2/3-->1=MARGIN, 2=MTM , keep blank. keep blank.
3=BOTH ] 3=BOTH ]

BSE - PUBLIC
 Filler 3 Filler 4 Filler 5 Delete Flag

NULL NULL NULL NULL

It Should be blank
for new addition.
This field you can This field you can This field you can OrElse "1" to
keep blank. keep blank. keep blank. Delete that same
record from
database

BSE - PUBLIC
Backoffice Id Exchange Market Segment
NOT NULL NOT NULL NOT NULL NOT NULL

This field contain This field contain market This field contain
This field consist
exchange i.e. BSE, NSE, like equity, derivatives, segment like equity,
client Id.
MCX, NCDEX currency etc futures, options etc.

Sample :
A1001,BSE,EQUITY,EQUITY,,,,,,,20,100,,
A1001,NSE,EQUITY,EQUITY,,,,,,,20,100,,
A1002,BSE,EQUITY,EQUITY,,,,,,,20,100,,
A1002,MCX,COMMODITIES,COMMODITIES-FUTURES,,,,,,,20,100,,

Notes :

* Donot upload files with headers

BSE - PUBLIC
Symbol Series Instrument Name Expiry Date Strike Price
NULL NULL NULL NULL NULL

This field contain This field contain instrument

This field contain This field contain This field contain
Series like eq, be Name FUTIDX, FUTSTK,
Symbol. expiry date. strike price.
etc. FUTCUR etc

BSE - PUBLIC
Option Type Intraday Margin
NULL NOT NULL
This field contain intraday margin multiplier.
This field contain option type like Suppose admin need to set margin for 5
CE, PE etc. times then he need to put value 20 in this
field which is 100/5.

BSE - PUBLIC
Delivery Margin Filler Filler
NOT NULL NULL NULL
This field contain delivery margin multiplier.
Suppose admin need to set margin for 2 This field can be kept This field can be
times then he need to put value 50 in this blank. kept blank.
field which is 100/2.

BSE - PUBLIC
Client ID/ USERLEVEL Category EXCHANGE
Dealer ID
NOT NULL NOT NULL NOT NULL NOT NULL
_upload User need to select This field contain category This field contain
level either user level like Securities, commodities exchange i.e. BSE, NSE,
or user group etc MCX, NCDEX

Sample :
A1001,USER,Securities,BSE,EQ,EQ,,,,,,,,,1000,,,,,,,,,20000,200000,
A1001,USER,Securities,BSE,CUR,,,,,,,,,,,220000,,,,,,,,,200000,200000
A1002,Group,Securities,BSE,EQ,EQ,,,,,,,,,,2500000,,,,,,,,,2500000,2500000
A1002,USER,,NSE,EQ,EQ,,,,,,,,,,2500000,,,,,,,,,2500000,2500000,
A1002,USER,COMMODITIES,MCX,CF,,,,,,,,,,,2500000,,,,,,,,,2500000,2500000

Notes :

* Donot upload files with headers

BSE - PUBLIC
MARKET SEGMENT SYMBOL SERIES

NOT NULL NOT NULL NULL NULL

This field contain market This field contain This field contain This field contain
like equity, derivatives, segment like equity, Symbol. Series like eq, be
currency etc futures, options etc. etc.

BSE - PUBLIC
INSTRUMENTNAME EXPIRYDATE STRIKEPRICE OPTIONTYPE

NULL NULL NULL NULL

This field contain instrument This field contain This field contain This field contain
Name FUTIDX, FUTSTK, expiry date. strike price. option type like CE,
FUTCUR etc PE etc.

BSE - PUBLIC
MaxOrderQuantity MaxOrderValue TradeTurnoverLimit

NULL NULL NULL

This field contain max order This field contain max order value This field contain trade turnover
quantity which admin need to which admin need to set for client limit which admin need to set for
set for client or dealer. or dealer. client or dealer.

BSE - PUBLIC
TurnoverLimit TradeGrossExposure TradeNetExposure

NULL NULL NULL

This field contain turnover This field contain trade gross This field contain trade net
limit which admin need to set exposure limit which admin need to exposure limit which admin need to
for client or dealer. set for client or dealer. set for client or dealer.

BSE - PUBLIC
GrossExposure NetExposure BuyAmount

NULL NULL NULL

This field contain gross exposure This field contain net exposure This field contain buy amount limit
limit which admin need to set for limit which admin need to set for which admin need to set for client
client or dealer. client or dealer. or dealer.

BSE - PUBLIC
SellAmount BuyOutstandingAmount

NULL NULL
This field contain sell amount This field contain buy outstanding
limit which admin need to set for amount limit which admin need to set
client or dealer. for client or dealer.

BSE - PUBLIC
SellOutstandingAmount TotalBuyAmount

NULL NULL
This field contain sell outstanding amount This field contain total buy amount
limit which admin need to set for client or limit which admin need to set for
dealer. client or dealer.

BSE - PUBLIC
TotalSellAmount

NULL
This field contain total sell amount
limit which admin need to set for
client or dealer.

BSE - PUBLIC
Login Id TR Profile CM Profile RL Profile
NOT NULL NULL NULL NULL

This field contain

This field contain Client This field contain Trading Contract Margin Profile This field contain Right
Code. Rights Profile Name. Name. Limit Profile Name.

Sample :
A1001,,,Profile1,,,,Profile6
A1002,,,Profile1,,Profile2,,Profile6

Notes :

* Donot upload files with headers

BSE - PUBLIC
UCON Profile MTM Profile IP Profile Exc. Ide Profile.
NULL NULL NULL NULL

This field contain User

Configuration Profile This field contain MTM This field contain Ip This field contain Exchange
Name. Profile Name. Profile name. User Identifier Profile Name.

BSE - PUBLIC
Client ID ISIN Quantity
NOT NULL NOT NULL NOT NULL
This field contain ISIN code for the
This field contain Client Id. SLB stock. This field contain quantity of stock.

Sample :
A1001|INE012A01025|100
A1001|INE117A01022|100
A1002|INE043D01016|100

* This file should be uploaded in pipe (|)seperated format.

Notes :

* Donot upload files with headers

BSE - PUBLIC
Client ID PAN NO
NOT NULL NOT NULL

This field contain Pan Card

This field contain client id.
number of the client.

Sample :
A1001,AAAAA7890A
A1002,BBBBB7890B

Notes :

* Donot upload files with headers

* Can udate PAN number for client which was uploaded at were inittial when PAN was not compulsory

BSE - PUBLIC
BackOffice ID NSE Series BSE Scrip DPQuantit Filler1 DPAvePric Filler2
Symbol Code y e
NOT NULL NOT NULL NOT NOT NULL NOT NULL NULL NOT NULL NULL
NULL
This field This field This field This field Holding qty This field
contain Client contain contain contain BSE (from DP) contains
Id. Nse series Scrip Code. the DP
Symbol. like EQ, Average
BE etc. Price

Sample:
KartikS,ABB,EQ,500002,100,,1000.25,,,20.5
KartikS,SBIN,EQ,500112,75,,1000.25,,,20.55
KartikS,CCCL,BE,532902,25,,1000.25,,,20.55

Notes :

* Do not upload files with headers

BSE - PUBLIC
Filler DPCFSHairc
3 ut
NULL NOT NULL

This field
contains
Credit for Sell
Haircut (in
Percentage)

BSE - PUBLIC
BackOff NSE Series BSE DPQuan Filler1 DPAveP Filler2 Filler3 DPCFSH
ice ID Symbol Scrip tity rice aircut
Code
NOT NOT NOT NOT NOT NULL NOT NULL NULL NOT
NULL NULL NULL NULL NULL NULL NULL
This field This field This field This field Holding This field This field
contain contain contain contain qty contains contains
Client Id. Nse series BSE (from the DP Credit
Symbol. like EQ, Scrip DP) Average for Sell
BE etc. Code. Price Haircut
(in
Percenta
ge)

Sample:
KartikS,ABB,EQ,500002,100,,1000.25,,,10,100,,1000.25,,,100
KartikS,SBIN,EQ,500112,75,,1000.25,,,20.55,75,,1000.25,,,100
KartikS,CCCL,BE,532902,25,,1000.25,,,20.55,100,,1000.25,,,100

Notes :

* Do not upload files with headers

BSE - PUBLIC
PoolQu Filler4 PoolAve Filler5 Filler6 PoolCFSH
antity Price aircut

NOT NULL NOT NULL NULL NOT NULL

NULL NULL
Pool qty This field This field
(from contains contains
DP) the Pool Credit for
Average Sell
Price Haircut (in
Percentage
)

BSE - PUBLIC
BackOff NSE Series BSE PoolQu Filler1 PoolAve Filler2 Filler3 PoolCFS
ice ID Symbol Scrip antity Price Haircut
Code
NOT NOT NOT NOT NOT NULL NOT NULL NULL NOT
NULL NULL NULL NULL NULL NULL NULL
This field This field This field This field Holding This field This field
contain contain contain contain qty contains contains
Client Id. Nse series BSE (from the Pool Credit
Symbol. like EQ, Scrip DP) Average for Sell
BE etc. Code. Price Haircut
(in
Percenta
ge)

Sample:
KartikS,ABB,EQ,500002,100,,1000.25,,,20.5
KartikS,SBIN,EQ,500112,75,,1000.25,,,20.55
KartikS,CCCL,BE,532902,25,,1000.25,,,20.55

Notes :

* Do not upload files with headers

BSE - PUBLIC
BackOff Bank Account Branch Status
ice ID Name No Name
NOT NOT NOT NOT NOT
NULL NULL NULL NULL NULL
This field This field This field This field This field
contain contains contains contains contains
Client Id. the Bank the Bank the the
Name Account Branch status
Number Name active/in
active/su
spended

Sample:
lisam,HDFC bank limited,56789987654,vasai,active

Notes :

* Do not upload files with headers

account no. field : only numbers allowed. (minimum length =10)
Status field values: (active/inactive/suspended)

BSE - PUBLIC