近期访问
`performance_schema`.`threads`
`information_schema`.`INNODB_BUFFER_POOL_STATS`
`LicenseApp`.`ProcessReq`
`information_schema`.`PARTITIONS`
`performance_schema`.`users`
`information_schema`.`PROCESSLIST`
`LicenseApp`.`ProcessReqList`
`performance_schema`.`setup_consumers`
`access_data_mariadb`.`access_data`
`performance_schema`.`setup_timers`
表收藏夹
表收藏夹为空。
新建
cm9vdA==.YWNjZXNzX2RhdGFfbWFyaWFkYg==
cm9vdA==.YWNjZXNzX2RhdGFfbWFyaWFkYg==
0
access_data_mariadb
cm9vdA==.Q2hhaW5z
cm9vdA==.Q2hhaW5z
0
Chains
cm9vdA==.RXhjaENvcnBEYXRh
cm9vdA==.RXhjaENvcnBEYXRh
0
ExchCorpData
cm9vdA==.RXhjaE5ld3NEYXRh
cm9vdA==.RXhjaE5ld3NEYXRh
0
ExchNewsData
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h
0
information_schema
cm9vdA==.TGljZW5zZUFwcA==
cm9vdA==.TGljZW5zZUFwcA==
0
LicenseApp
cm9vdA==.bXlzcWw=
cm9vdA==.bXlzcWw=
0
mysql
cm9vdA==.Tm9yZW5BY2NvcmRDb21hcG55RGF0YQ==
cm9vdA==.Tm9yZW5BY2NvcmRDb21hcG55RGF0YQ==
0
NorenAccordComapnyData
cm9vdA==.Tm9yZW5CbG9ja0Z1bmRzQVNCQQ==
cm9vdA==.Tm9yZW5CbG9ja0Z1bmRzQVNCQQ==
0
NorenBlockFundsASBA
cm9vdA==
cm9vdA==.Tm9yZW5EQg==
0
NorenDB
cm9vdA==.Tm9yZW5EQg==
cm9vdA==.Tm9yZW5EQg==.
0
NorenDB
cm9vdA==.Tm9yZW5EQl9vbGQ=
cm9vdA==.Tm9yZW5EQg==.b2xk
0
NorenDB_old
cm9vdA==.Tm9yZW5EQkNvbXBhbnlEYXRh
cm9vdA==.Tm9yZW5EQkNvbXBhbnlEYXRh
0
NorenDBCompanyData
cm9vdA==.Tm9yZW5EQklwb0RhdGE=
cm9vdA==.Tm9yZW5EQklwb0RhdGE=
0
NorenDBIpoData
cm9vdA==.Tm9yZW5EaW9uTmV3c0RhdGE=
cm9vdA==.Tm9yZW5EaW9uTmV3c0RhdGE=
0
NorenDionNewsData
cm9vdA==.Tm9yZW5GZWVkRGF0YQ==
cm9vdA==.Tm9yZW5GZWVkRGF0YQ==
0
NorenFeedData
cm9vdA==.Tm9yZW5JbnN0aVZ3YXA=
cm9vdA==.Tm9yZW5JbnN0aVZ3YXA=
0
NorenInstiVwap
cm9vdA==.Tm9yZW5Mc05ld3M=
cm9vdA==.Tm9yZW5Mc05ld3M=
0
NorenLsNews
cm9vdA==.Tm9yZW5TdGdEQg==
cm9vdA==.Tm9yZW5TdGdEQg==
0
NorenStgDB
cm9vdA==
cm9vdA==.Tm9yZW5UUERC
0
NorenTPDB
cm9vdA==.Tm9yZW5UUERC
cm9vdA==.Tm9yZW5UUERC.
0
NorenTPDB
cm9vdA==.Tm9yZW5UUERCX29sZA==
cm9vdA==.Tm9yZW5UUERC.b2xk
0
NorenTPDB_old
cm9vdA==.Tm9yZW5VcGxEQl90ZXN0
cm9vdA==.Tm9yZW5VcGxEQl90ZXN0
0
NorenUplDB_test
cm9vdA==.Tm9yZW5Vc2VyQXBpS2V5
cm9vdA==.Tm9yZW5Vc2VyQXBpS2V5
0
NorenUserApiKey
cm9vdA==.Tm9yZW5VdGlsZXNfdGVzdA==
cm9vdA==.Tm9yZW5VdGlsZXNfdGVzdA==
0
NorenUtiles_test
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h
0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==
cm9vdA==.cGhwbXlhZG1pbg==
0
phpmyadmin
cm9vdA==.dGVzdA==
cm9vdA==.dGVzdA==
0
test
cm9vdA==.VXBsb2Fkc0RC
cm9vdA==.VXBsb2Fkc0RC
0
UploadsDB
导航面板
导航树
服务器
数据库
表
导航面板
自定义导航面板。
以树状显示数据库导航面板
导航栏使用数据库选择器替代树形列表
与主面板链接
高亮当前数据库或表链接到主面板。
显示徽标
在导航面板中显示图示。
徽标链接地址
导航面板中图示指向的链接地址。
徽标链接目标
在主窗口(
main
)或新窗口(
new
)打开目标页面。
main
new
启用高亮
高亮鼠标指针所在位置的服务器。
第一层节点的最大项数
每页导航树所能显示的第一层的最大项数。
显示筛选框的最少项数
设置达到多少个项(表、视图、程序和事件)时将显示筛选框。
最近使用的表
最近使用的表的最大数量;设为 0 为禁用。
表收藏夹
收藏表的最大数量;设为 0 为禁用。
导航面板宽度
设置为0以折叠导航面板。
导航树
自定义导航树。
节点中最大项数
每页导航树所能显示的最大项数。
分组树中的项
将导航树中的项分组(根据上面 数据库与数据表 页面设置的分隔符分组)。
启用表导航条展开功能
是否允许在导航栏中展开导航树。
在导航树显示表
在导航树是否在数据库下显示数据表节点
在导航树显示视图
在导航树中是否在数据库下显示视图节点
在导航树显示函数
是否显示导航树中数据库下级功能
在导航树显示进程
是否在导航树中显示数据库进程
在导航树显示事件
在导航树中数据库下是否显示事件节点
展开单个数据库
是否自动在导航树中展开单个数据库。
服务器
服务器显示选项。
显示服务器选择
在导航面板顶部显示可选的服务器。
列表显示服务器
直接显示服务器列表而不使用下拉框。
数据库
数据库显示选项。
设置达到多少个数据库时将显示数据库筛选框
数据库树分隔符
将数据库分为不同层级的字符串。
表
表显示选项。
快速访问图标的目标
结构
SQL
搜索
插入
浏览
第二快速访问图标的目标页面
结构
SQL
搜索
插入
浏览
表树分隔符
将表分为不同层级的字符串。
表树最大深度
将文件拖动至此
SQL 上传 (
0
)
x
-
该处必须启用 Javascript!
服务器: localhost
»
数据库: NorenDB
结构
SQL
搜索
查询
导出
导入
操作
权限
程序
事件
触发器
追踪
设计器
文本框列
控制台
清除
历史
选项
书签
调试 SQL
按 Ctrl+Enter 键执行查询
按 Enter 执行查询
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
information_schema
查询时间 :
在当前会话期间
SELECT * FROM `CHARACTER_SETS`
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃
扩展
显示跟踪
隐藏跟踪
数量
用时
书签
刷新
添加
没有书签
添加书签
标签:
目标数据库:
共享和谐书签
确定
选项
恢复默认
总是扩展查询消息
在开始时显示查询历史
显示当前浏览查询
浏览设置,使按Shift+Enter键执行输入和插入新行作为永久设置。
切换到黑色主题
崩溃
扩展
重新查询
编辑
解析
性能分析
书签
查询失败
数据库 :
查询时间 :
多表查询
通过示例查询
*
acct_id
exch_seg
exch_seg_acct_id
partic_id
enabled
noren_time_stamp
src_user_id
broker_id
*
acct_id
exch_seg
exch_seg_acct_id
partic_id
enabled
noren_time_stamp
src_user_id
broker_id
*
user_count
noren_time_stamp
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
rej_reason
rej_by
exch_time_stamp
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_ord_num
exch_user_id
lot_size
symbol_name
exchange
segment
trd_symbol
instrument_name
tick_size
con_prod_id
sip_min_amt
sip_max_amt
sip_val_det
gui_status
red_check
red_super_user
exch_seg_acct_id
rej_qty
rej_ord_src
rej_price_type
user_privilege
ip_address
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
exch_time_stamp
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_ord_num
exch_user_id
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
gui_status
red_check
AMO
red_super_user
exch_seg_acct_id
user_privilege
purchse_type
dp_trans
foliono
euin
ip_address
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
rej_reason
rej_by
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_user_id
ord_remarks
price_precision
qty_precision
mkt_ind
symbol_name
exchange
segment
trd_symbol
instrument_name
option_type
tick_size
spread_trading_symbol_leg_1
spread_trading_symbol_leg_2
hl_min_price
hl_max_price
bo_min_price
bo_max_price
con_prod_id
sip_min_amt
sip_max_amt
sip_inc_amt
sip_min_inst
sip_max_inst
sip_val_det
gui_status
red_check
red_super_user
exch_seg_acct_id
rej_qty
rej_ord_src
rej_price_type
user_privilege
purchse_type
dp_trans
kyc_status
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
rej_reason
rej_by
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_user_id
ord_remarks
price_precision
qty_precision
mkt_ind
symbol_name
exchange
segment
trd_symbol
instrument_name
option_type
tick_size
spread_trading_symbol_leg_1
spread_trading_symbol_leg_2
hl_min_price
hl_max_price
bo_min_price
bo_max_price
con_prod_id
sip_min_amt
sip_max_amt
sip_inc_amt
sip_min_inst
sip_max_inst
sip_val_det
gui_status
red_check
red_super_user
exch_seg_acct_id
rej_qty
rej_ord_src
rej_price_type
user_privilege
purchse_type
dp_trans
kyc_status
sip_start_date
sip_frequency_type
firstorderflag
brokerage
xsip_mandate_id
no_of_instalments
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
rej_reason
rej_by
exch_time_stamp
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_ord_num
exch_user_id
lot_size
symbol_name
exchange
segment
trd_symbol
instrument_name
tick_size
con_prod_id
sip_min_amt
sip_max_amt
sip_val_det
gui_status
red_check
red_super_user
exch_seg_acct_id
rej_qty
rej_ord_src
rej_price_type
user_privilege
ip_address
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
exch_time_stamp
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_ord_num
exch_user_id
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
gui_status
red_check
AMO
red_super_user
exch_seg_acct_id
user_privilege
purchse_type
dp_trans
foliono
euin
ip_address
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
rej_reason
rej_by
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_user_id
ord_remarks
price_precision
qty_precision
mkt_ind
symbol_name
exchange
segment
trd_symbol
instrument_name
option_type
tick_size
spread_trading_symbol_leg_1
spread_trading_symbol_leg_2
hl_min_price
hl_max_price
bo_min_price
bo_max_price
con_prod_id
sip_min_amt
sip_max_amt
sip_inc_amt
sip_min_inst
sip_max_inst
sip_val_det
gui_status
red_check
red_super_user
exch_seg_acct_id
rej_qty
rej_ord_src
rej_price_type
user_privilege
purchse_type
dp_trans
kyc_status
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
ord_src
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
broker_id
region
family_id
cust_firm
partic_id
pan_num
qty_to_fill
red_qty
price_to_fill
red_price
rej_reason
rej_by
noren_org_time_stamp
noren_org_nsecs
disc_qty
exch_user_id
ord_remarks
price_precision
qty_precision
mkt_ind
symbol_name
exchange
segment
trd_symbol
instrument_name
option_type
tick_size
spread_trading_symbol_leg_1
spread_trading_symbol_leg_2
hl_min_price
hl_max_price
bo_min_price
bo_max_price
con_prod_id
sip_min_amt
sip_max_amt
sip_inc_amt
sip_min_inst
sip_max_inst
sip_val_det
gui_status
red_check
red_super_user
exch_seg_acct_id
rej_qty
rej_ord_src
rej_price_type
user_privilege
purchse_type
dp_trans
kyc_status
sip_start_date
sip_frequency_type
firstorderflag
brokerage
xsip_mandate_id
no_of_instalments
*
trading_symbol
exch_seg
trans_type
price_type
product
ord_duration
acct_id
user_id
ord_src
cust_firm
noren_time_stamp
noren_nsecs
qty_to_fill
price_to_fill
partic_id
fix_remarks
cautionary_msg
*
client_id
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
*
acct_id
creation_date
noren_time_stamp
mob_num
display_precision
dp_type
dp_id
broker_id
region
acct_name
src_user_id
email_id
pan_num
addr
acct_type
status
office_addr
addr_city
addr_state
gender
occupation
exch_acct_id
family_id
context
product
dp_actnum1
dp_actnum2
dp_actnum3
mail
sms
trade_notification
cust_firm
bank_addr1
bank_brnch_name1
bank_name1
bank_acct_type1
bank_acct_num1
bank_ifsc_code1
bank_addr2
bank_brnch_name2
bank_name2
bank_acct_type2
bank_acct_num2
bank_ifsc_code2
bank_addr3
bank_brnch_name3
bank_name3
bank_acct_type3
bank_acct_num3
bank_ifsc_code3
bank_addr4
bank_brnch_name4
bank_name4
bank_acct_type4
bank_acct_num4
bank_ifsc_code4
bank_addr5
bank_brnch_name5
bank_name5
bank_acct_type5
bank_acct_num5
bank_ifsc_code5
bank_addr6
bank_brnch_name6
bank_name6
bank_acct_type6
bank_acct_num6
bank_ifsc_code6
sor_flag
*
acct_id
creation_date
noren_time_stamp
mob_num
display_precision
dp_type
dp_id
broker_id
region
acct_name
src_user_id
email_id
pan_num
addr
acct_type
status
office_addr
addr_city
addr_state
gender
occupation
exch_acct_id
family_id
context
product
dp_actnum1
dp_actnum2
dp_actnum3
mail
sms
trade_notification
cust_firm
bank_addr1
bank_brnch_name1
bank_name1
bank_acct_type1
bank_acct_num1
bank_ifsc_code1
bank_addr2
bank_brnch_name2
bank_name2
bank_acct_type2
bank_acct_num2
bank_ifsc_code2
bank_addr3
bank_brnch_name3
bank_name3
bank_acct_type3
bank_acct_num3
bank_ifsc_code3
bank_addr4
bank_brnch_name4
bank_name4
bank_acct_type4
bank_acct_num4
bank_ifsc_code4
bank_addr5
bank_brnch_name5
bank_name5
bank_acct_type5
bank_acct_num5
bank_ifsc_code5
bank_addr6
bank_brnch_name6
bank_name6
bank_acct_type6
bank_acct_num6
bank_ifsc_code6
sor_flag
*
acct_id
exch_seg
token
product
trading_symbol
buy_qty
buy_amt
sell_qty
sell_amt
cf_buy_qty
cf_buy_amt
cf_sell_qty
cf_sell_amt
noren_time_stamp
src_user_id
*
EntityID
expiry_margin
noren_time_stamp
noren_nsecs
*
Acct_id
Trans_ref_num
Init_time_stamp
Src_user_id
Amt
Tran_status
Noren_time_stamp
User_remarks
Bank_acct_type
Bank_acct_num
Bank_name
Broker_id
Admin_remarks
Segment
Exch_seg
Product
Withdraw_success_amt
Bank_ref_number
Aggr_ref_number
Vendor
Vendor_url
Bank_ifsc_code
Customer_name
Mob_num
Email_id
Upi_id
Expiry_time
Customer_ref_number
*
GTTid
UserId
status
exch_seg
token
noren_time_stamp
noren_nsecs
Remarks
trading_symbol
alert_name
validity
price_type
ord_duration
product
qty_to_fill
price_to_fill
trigger_price
acct_id
cust_firm
trans_type
order_source
*
GTTid
UserId
status
exch_seg
token
noren_time_stamp
noren_nsecs
Remarks
trading_symbol
alert_name
validity
price_type
ord_duration
product
qty_to_fill
price_to_fill
trigger_price
acct_id
cust_firm
trans_type
order_source
*
acct_id
product
holding_qty
t1_holding_qty
collateral_qty
collateral_mode
hair_cut
close_price
is_collateral
interop_key
interop_exch_seg
user_id
broker_id
region
family_id
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
broker_collateral_qty
broker_hair_cut
upload_price
isin
dp_holding_qty
exchseg1
exchseg2
token1
token2
npoa_disp_qty
t1_npoa_disp_qty
*
entity_id
cash
*
entity_id
profile_name
segment
exch_seg
product
family_risk
cash
turnover_limit
pending_order_limit
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
payin
payout
daylong_cash
uncleared_cash
broker_collateral
brokerage_perc_eq_margin
brokerage_perc_eq_intraday
brokerage_perc_eq_cac
brokerage_perc_eq_hl
brokerage_perc_eq_bo
brokerage_perc_der_margin
brokerage_perc_der_intraday
brokerage_perc_der_hl
brokerage_perc_der_bo
brokerage_perc_fx_margin
brokerage_perc_fx_intraday
brokerage_perc_fx_hl
brokerage_perc_fx_bo
brokerage_perc_com_margin
brokerage_perc_com_intraday
brokerage_perc_com_hl
brokerage_perc_com_bo
brokerage_flat_perc
from_segment
from_exch_seg
from_product
aux_daylong_cash
aux_uncleared_cash
aux_broker_collateral
gross_exposure_limit
mtm_loss_limit
*
entity_id
profile_name
segment
exch_seg
product
family_risk
cash
turnover_limit
pending_order_limit
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
payin
payout
daylong_cash
uncleared_cash
broker_collateral
brokerage_perc_eq_margin
brokerage_perc_eq_intraday
brokerage_perc_eq_cac
brokerage_perc_eq_hl
brokerage_perc_eq_bo
brokerage_perc_der_margin
brokerage_perc_der_intraday
brokerage_perc_der_hl
brokerage_perc_der_bo
brokerage_perc_fx_margin
brokerage_perc_fx_intraday
brokerage_perc_fx_hl
brokerage_perc_fx_bo
brokerage_perc_com_margin
brokerage_perc_com_intraday
brokerage_perc_com_hl
brokerage_perc_com_bo
brokerage_flat_perc
from_segment
from_exch_seg
from_product
aux_daylong_cash
aux_uncleared_cash
aux_broker_collateral
gross_exposure_limit
mtm_loss_limit
*
User
UserAccessType
IPDetails
InOut
SSBOE
DtTime
FailureId
Text
AppVersion
Broker
BranchId
UserType
MACAddress
ProcId
LoginDevice
SourceUserId
UserIPAddr
*
req_status
user_sess_id
last_attempt_count
device_pin_flag
user_privilege
login_proc_id
access_type
user_id
noren_time_stamp
last_login_time
ui_dev_code
addl_src_info
user_ip_addr
src_user_id
*
req_status
user_sess_id
last_attempt_count
device_pin_flag
user_privilege
login_proc_id
access_type
user_id
noren_time_stamp
last_login_time
ui_dev_code
src_user_id
*
MsgId
AcctId
ProId
CpCode
Seg
PrevAmt
Amt
UDIndicator
Status
NorenTimeStamp
*
app_key
exch_seg
algo_id
last_upd_time
*
app_key
secret_key
redirect_url
client_type
scope
display_name
ip_addr
user_id
status
last_upd_time
ord_webhook_url
*
app_key
user_id
user_sess_id
access_type
noren_time_stamp
noren_nsecs
redirect_url
auth_code
access_token
secret_key
refresh_token
expires_in
client_type
scope
status
state
display_name
ip_addr
*
app_key
user_id
user_sess_id
access_type
noren_time_stamp
noren_nsecs
redirect_url
auth_code
access_token
secret_key
refresh_token
expires_in
client_type
scope
status
state
display_name
ip_addr
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
cust_firm
partic_id
pan_num
qty_to_fill
price_to_fill
rej_reason
cancelled_qty
total_fill_qty
exch_time_stamp
exch_nsecs
fill_price
fill_avg_price
trigger_price
disc_qty
exch_ord_num
fill_id
ord_remarks
fill_time
trading_symbol_leg_2
trans_type_leg_2
trading_symbol_leg_3
trans_type_leg_3
trading_symbol_leg_4
trans_type_leg_4
token_leg_2
token_leg_3
token_leg_4
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
qty_to_fill_leg_4
price_to_fill_leg_4
fill_leg
total_fill_qty_leg_2
total_fill_qty_leg_3
total_fill_qty_leg_4
fill_avg_price_leg_2
fill_avg_price_leg_3
fill_avg_price_leg_4
lot_size
price_precision
qty_precision
multiplier
symbol_name
company_name
exchange
segment
expiry_date
expiry_date_leg_2
expiry_date_leg_3
expiry_date_leg_4
instrument_name
option_type
isin
strike_price
tick_size
price_numerator
price_denominator
gen_numerator
gen_denominator
ui_dev_code
broker_id
region
family_id
ord_src
ip_address
order_status
report_status
exchseg_acct_id
ctcl_id
channel
user_agent
app_install_id
orgtimestamp
modified_by
fix_rmks
rej_by
snofillId
exchusrinfo
algoid
algocategory
algoname
guiid
orgguiid
streamId
giveupInd
stopprice
profitprice
trailingprice
snoordtype
orderstate
auctionnumber
mktprotection
exectype
basketid
price_multiplier
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
cust_firm
partic_id
pan_num
qty_to_fill
price_to_fill
rej_reason
cancelled_qty
total_fill_qty
exch_time_stamp
exch_nsecs
fill_price
fill_avg_price
trigger_price
disc_qty
exch_ord_num
fill_id
ord_remarks
fill_time
trading_symbol_leg_2
trans_type_leg_2
trading_symbol_leg_3
trans_type_leg_3
trading_symbol_leg_4
trans_type_leg_4
token_leg_2
token_leg_3
token_leg_4
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
qty_to_fill_leg_4
price_to_fill_leg_4
fill_leg
total_fill_qty_leg_2
total_fill_qty_leg_3
total_fill_qty_leg_4
fill_avg_price_leg_2
fill_avg_price_leg_3
fill_avg_price_leg_4
lot_size
price_precision
qty_precision
multiplier
symbol_name
company_name
exchange
segment
expiry_date
expiry_date_leg_2
expiry_date_leg_3
expiry_date_leg_4
instrument_name
option_type
isin
strike_price
tick_size
price_numerator
price_denominator
gen_numerator
gen_denominator
ip_address
order_status
report_status
exchseg_acct_id
ctcl_id
channel
user_agent
app_install_id
orgtimestamp
modified_by
fix_rmks
rej_by
snofillId
exchusrinfo
algoid
algocategory
algoname
guiid
orgguiid
streamId
giveupInd
stopprice
profitprice
trailingprice
snoordtype
orderstate
auctionnumber
mktprotection
exectype
basketid
ord_src
ui_dev_code
broker_id
region
family_id
*
Acct_id
Trans_ref_num
Init_time_stamp
Src_user_id
Amt
Tran_status
Noren_time_stamp
User_remarks
Bank_acct_type
Bank_acct_num
Bank_name
Broker_id
Admin_remarks
Segment
Exch_seg
Product
Withdraw_success_amt
Bank_ref_number
Aggr_ref_number
Vendor
Vendor_url
Bank_ifsc_code
Customer_name
Mob_num
Email_id
Upi_id
Expiry_time
Customer_ref_number
*
Acct_id
Trans_ref_num
Init_time_stamp
Src_user_id
Amt
Tran_status
Noren_time_stamp
User_remarks
Bank_acct_type
Bank_acct_num
Bank_name
Broker_id
Admin_remarks
Segment
Exch_seg
Product
Withdraw_success_amt
Bank_ref_number
Aggr_ref_number
Vendor
Vendor_url
Bank_ifsc_code
Customer_name
Mob_num
Email_id
Upi_id
Expiry_time
Customer_ref_number
*
Acct_id
Trans_ref_num
Init_time_stamp
Src_user_id
Amt
Tran_status
Noren_time_stamp
User_remarks
Bank_acct_type
Bank_acct_num
Bank_name
Broker_id
Admin_remarks
Segment
Exch_seg
Product
Withdraw_success_amt
Bank_ref_number
Aggr_ref_number
Vendor
Vendor_url
Bank_ifsc_code
Customer_name
Mob_num
Email_id
Upi_id
Expiry_time
Customer_ref_number
*
SlNo
EntityID
Timestamp
PeakMargin
src_user_id
*
Acct_id
noren_time_stamp
noren_nsecs
fill_qty
exch_seg
token
product
prev_product
broker_id
region
family_id
msg_flag
segment
symbol_name
trading_symbol
instrument_name
expiry_date
option_type
strike_price
ord_src
interop_key
interop_exch_seg
red_super_user
src_user_id
fill_price
fill_avg_price
trans_type
user_privilege
*
UserId
RefName
MobNum
Email
Lang
NorenTimeStamp
src_user_id
*
EntityID
TotalCash
TotalMtom
MtomPerc
Timestamp
NSec
ProfileName
TotalMarginCash
TotalMarginUsed
MarginPerc
Segment
Product
AlertType
src_user_id
*
sip_id
exch_seg
token
trading_symbol
product
quantity
price
noren_time_stamp
*
sip_id
exch_seg
token
trading_symbol
product
quantity
price
noren_time_stamp
*
sip_id
user_id
acct_id
sip_name
broker_id
register_date
start_date
frequency
end_period
due_date
execution_date
tenure_count
previous_execution_date
current_status
noren_time_stamp
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
report_type
acct_id
user_id
trading_symbol
exch_seg
token
trans_type
price_type
product
ord_duration
cust_firm
partic_id
pan_num
qty_to_fill
price_to_fill
rej_reason
cancelled_qty
fill_qty
total_fill_qty
exch_time_stamp
exch_nsecs
fill_price
fill_avg_price
trigger_price
disc_qty
exch_ord_num
fill_id
ord_remarks
fill_time
trading_symbol_leg_2
trans_type_leg_2
trading_symbol_leg_3
trans_type_leg_3
trading_symbol_leg_4
trans_type_leg_4
token_leg_2
token_leg_3
token_leg_4
qty_to_fill_leg_2
price_to_fill_leg_2
qty_to_fill_leg_3
price_to_fill_leg_3
qty_to_fill_leg_4
price_to_fill_leg_4
fill_leg
total_fill_qty_leg_2
total_fill_qty_leg_3
total_fill_qty_leg_4
fill_avg_price_leg_2
fill_avg_price_leg_3
fill_avg_price_leg_4
lot_size
price_precision
qty_precision
multiplier
symbol_name
company_name
exchange
segment
expiry_date
expiry_date_leg_2
expiry_date_leg_3
expiry_date_leg_4
instrument_name
option_type
isin
strike_price
tick_size
price_numerator
price_denominator
gen_numerator
gen_denominator
ui_dev_code
broker_id
region
family_id
ord_src
ip_address
order_status
report_status
exchseg_acct_id
ctcl_id
channel
user_agent
app_install_id
orgtimestamp
modified_by
fix_rmks
rej_by
snofillId
exchusrinfo
algoid
algocategory
algoname
guiid
orgguiid
streamId
giveupInd
stopprice
profitprice
trailingprice
snoordtype
orderstate
auctionnumber
mktprotection
exectype
basketid
price_multiplier
*
noren_ord_num
noren_time_stamp
noren_nsecs
eref
noren_kid_id
ord_status
acct_id
user_id
ord_src
trans_type
price_type
broker_id
region
partic_id
pan_num
rej_reason
fill_qty
fill_price
exch_ord_num
fill_id
exch_user_id
fill_time
lot_size
symbol_name
exchange
segment
trading_symbol
expiry_date
instrument_name
option_type
exch_expiry_date
strike_price
red_expiry_date
tick_size
org_ord_src
exch_seg
token
product
user_privilege
giveupInd
fill_leg
*
exch_seg
user_id
acct_id
org_acct_id
symbol_name
exp_date
strike_price
option_type
product
trans_type
fill_qty
lot_size
fill_price
fill_id
fill_time
ord_status
exch_ord_num
price_type
ord_src
noren_ord_num
trading_symbol
token
instrument_name
partic_id
rej_reason
noren_time_stamp
stream_id
ord_remarks
line_order_id
giveup_ind
order_status
*
user_id
noren_time_stamp
noren_nsecs
src_user_id
src_broker_id
*
user_id
creation_date
noren_time_stamp
login_image
last_password_time
last_login_time
mob_num
display_precision
max_contract_sub
dob
user_login_otp
last_login_mac
user_default_mw
addr_city
addr_state
addr
executing_broker_id
email_id
pan_num
user_access_grp
status
user_ip_addr
user_mac_addr
noren_extras_grp
noren_extras
user_ord_validator
prop_id
user_name
login_password
user_sess_id
src_user_id
last_login_ip
user_privilege
access_type
noren_app_version
last_login_os
broker_id
region
user_sess_otp
login_proc_id
prop_ord_flag
acct_overview
red_super_user
user_2fa_flag
password_reset
last_attempt_count
last_attempt_time
product
user_accesstype
user_ordtype
fcm_token
user_tag
remarks
totp_sec
last_otp_time
otp_count
*
user_id
exch_seg
exch_user_info
exch_user_id
red_check
exch_expiry_date
enabled
noren_time_stamp
src_user_id
exch_expiry_dateTime
*
user_id
exch_seg
exch_user_info
exch_user_id
red_check
exch_expiry_date
enabled
noren_time_stamp
src_user_id
exch_expiry_dateTime
*
user_id
creation_date
noren_time_stamp
login_image
last_password_time
last_login_time
mob_num
display_precision
max_contract_sub
dob
user_login_otp
last_login_mac
user_default_mw
addr_city
addr_state
addr
executing_broker_id
email_id
pan_num
user_access_grp
status
user_ip_addr
user_mac_addr
noren_extras_grp
noren_extras
user_ord_validator
prop_id
user_name
login_password
user_sess_id
src_user_id
last_login_ip
user_privilege
access_type
noren_app_version
last_login_os
broker_id
region
user_sess_otp
login_proc_id
prop_ord_flag
acct_overview
red_super_user
user_2fa_flag
password_reset
last_attempt_count
last_attempt_time
product
user_accesstype
user_ordtype
fcm_token
user_tag
remarks
totp_sec
last_otp_time
otp_count
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
X
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
X
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
X
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
显示
排序
递增
递减
添加为
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
文字
另一个字段
选择表
AccountExchDetails
AccountExchHistory
ActiveUserCount
AncOrderBook
AncOrderBookIpo
AncOrderBookMfd
AncOrderBookXsip
AncOrderHistory
AncOrderHistoryIpo
AncOrderHistoryMfd
AncOrderHistoryXsip
CautionaryMessage
ClientDelete
ClientDetails
ClientSil
ClntPos
Expirymargin
FundTransfer
GTTOrderHistory
GTTUpdates
Holdings
IncrementalLimits
Limits
LimitsCur
LogInOuts
Logins
Logouts
NCLAllocationUpd
oAuthAlgoIdDetails
oAuthAppKeyDetails
oAuthCodeDetails
oAuthTokenDetails
OrderBook
OrderHistory
PayInUpdates
PayoutHistory
PayoutUpdates
PeakMargin
ProductConversion
Refdata
RMSAlerts
SipExchDetails
SipExchHistory
SipHistory
TradeBook
TradeGiveup
TradeModify
UserDelete
UserDetails
UserExchDetails
UserExchHistory
UserSil
.
选择字段
X