|
noren_ord_num
|
bigint(20)
|
|
|
|
|
noren_time_stamp
|
bigint(20)
|
|
|
|
|
noren_nsecs
|
bigint(20)
|
|
|
|
|
eref
|
bigint(20)
|
|
|
|
|
noren_kid_id
|
int(10)
|
|
|
|
|
ord_status
|
int(10)
|
|
|
|
|
report_type
|
int(10)
|
|
|
|
|
acct_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
ord_src
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
trading_symbol
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
exch_seg
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
token
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
trans_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
price_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
product
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
ord_duration
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
broker_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
region
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
family_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
cust_firm
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
partic_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
pan_num
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
qty_to_fill
|
bigint(20)
|
|
|
|
|
red_qty
|
bigint(20)
|
|
|
|
|
price_to_fill
|
bigint(20)
|
|
|
|
|
red_price
|
bigint(20)
|
|
|
|
|
rej_reason
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
rej_by
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
noren_org_time_stamp
|
bigint(20)
|
|
|
|
|
noren_org_nsecs
|
bigint(20)
|
|
|
|
|
disc_qty
|
bigint(20)
|
|
|
|
|
exch_user_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
ord_remarks
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
price_precision
|
int(10)
|
|
|
|
|
qty_precision
|
int(10)
|
|
|
|
|
mkt_ind
|
int(10)
|
|
|
|
|
symbol_name
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
exchange
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
segment
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
trd_symbol
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
instrument_name
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
option_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
tick_size
|
int(10)
|
|
|
|
|
spread_trading_symbol_leg_1
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
spread_trading_symbol_leg_2
|
varchar(256)
|
utf8mb4_general_ci
|
|
|
|
hl_min_price
|
bigint(20)
|
|
|
|
|
hl_max_price
|
bigint(20)
|
|
|
|
|
bo_min_price
|
bigint(20)
|
|
|
|
|
bo_max_price
|
bigint(20)
|
|
|
|
|
con_prod_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
sip_min_amt
|
bigint(20)
|
|
|
|
|
sip_max_amt
|
bigint(20)
|
|
|
|
|
sip_inc_amt
|
bigint(20)
|
|
|
|
|
sip_min_inst
|
bigint(20)
|
|
|
|
|
sip_max_inst
|
bigint(20)
|
|
|
|
|
sip_val_det
|
varchar(512)
|
utf8mb4_general_ci
|
|
|
|
gui_status
|
int(10)
|
|
|
|
|
red_check
|
int(10)
|
|
|
|
|
red_super_user
|
int(10)
|
|
|
|
|
exch_seg_acct_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
rej_qty
|
bigint(20)
|
|
|
|
|
rej_ord_src
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
rej_price_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
user_privilege
|
int(10)
|
|
|
|
|
purchse_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
dp_trans
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
kyc_status
|
int(10)
|
|
|
|
|
sip_start_date
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
sip_frequency_type
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
firstorderflag
|
int(10)
|
|
|
|
|
brokerage
|
bigint(20)
|
|
|
|
|
xsip_mandate_id
|
varchar(40)
|
utf8mb4_general_ci
|
|
|
|
no_of_instalments
|
bigint(20)
|
|
|
|
