AccountRouteConfig

V8 Message Definiton

METADATA

Attribute	Value
Topic	1800-client-config
MLink Token	ClientControl
Product	SRControl
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
accnt	VARCHAR(16)	PRI	''	SR assigned accnt code
clientFirm	VARCHAR(16)	PRI	''	SR assigned client firm acronym
execBrkrCode	VARCHAR(16)	PRI	''	SR execBrkrCode SR Assigned
enabled	enum - YesNo		'None'	yesroute enabled
relationship	enum - RelationshipType		'None'
catDestFirmIMID	VARCHAR(16)		''	Destination Firm IMID supplied by FINRA fbo destination can be BD or Exchange
catDestDeptType	enum - CatDeptType		'None'	CAT destination department type
routingRule	enum - RoutingRule		'RoundRobin'
backupRouteCode	VARCHAR(65)		''	backup route code if above are unavailable
comment	TINYTEXT		''	maintainer commments
modifiedBy	VARCHAR(24)		''	user who last modified this record
modifiedIn	enum - SysEnvironment		'None'
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of last modification
ClearingFlipList	JSON		'JSON_ARRAY()'
ExchControlList	JSON		'JSON_ARRAY()'
ExecBrkrAccntsList	JSON		'JSON_ARRAY()'
RoutingTableList	JSON		'JSON_ARRAY()'
SupportSwapProvidersList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
accnt	1
clientFirm	2
execBrkrCode	3

JSON Block (ClearingFlipList)

Field	Type	Comment
exDest	enum - exDest	exDest eg CBOEOPT NMSOPT NMSSTK CMXFUT
clrFlipType	enum - FlipType	type of clearing corp delivery
clrFlipFirm	enum - clrFlipFirm	deliverTo clearing member eg OCC NSCC MPID or InstitutionID
clrFlipAccnt	enum - clrFlipAccnt	deliverTo client account eg OCC AID or a DVP FBO code
clrAgent	enum - clrAgent	deliverTo agent eg DVP Agent Bank ID
clrTaxID	enum - clrTaxID	deliverTo taxID eg DVP TaxID
clrBrkrMPID	enum - clrBrkrMPID	clearing broker equity clearing only exDest is an option exch exDestNMSSTK must exist in this list

JSON Block (ExchControlList)

Field	Type	Comment
exDest	enum - exDest	exchange eg NYSESTK CBOEOPT NMSOPT NMSSTK CMXFUT or external broker algo eg NIGHTHAWKSTK NIGHTHAWKOPT
disable	enum - YesNo
externParams	enum - externParams	algo params for style algo exDest entries tagvaluetagvaluetagvalue

JSON Block (ExecBrkrAccntsList)

Field	Type	Comment
exchGroup	enum - ExchGroup	eg NMS CMX ICE EUREX NONEANY
secType	enum - SpdrSecType	eg Stock Future Option NONEANY
execBrkrAccnt	enum - execBrkrAccnt	exec broker account supplied by exec broker usually Account1
execBrkrClFirm	enum - execBrkrClFirm	exec broker clientfirm supplied by exec broker usually OnBehalfOfCompId115
execBrkrUserName	enum - execBrkrUserName	exec broker user name supplied by exec broker
catDestFirmIMID	enum - catDestFirmIMID	perexchGroupsecType override of toplevel catDestFirmIMID empty falls through

JSON Block (RoutingTableList)

Field	Type	Comment
routingCode	enum - routingCode	routing session code is a RouteDefinitionpkeyroutingCode RouteDefinitionexecBrkrCode must match execBrkrCode
featureDisable	enum - FeatureDisable	used to disable certain route features before reaching the routingCoderouteDefinition

JSON Block (SupportSwapProvidersList)

Field	Type	Comment
swapProvider	enum - SwapProvider

SELECT TABLE EXAMPLE QUERY

SELECT *
FROM `SRControl`.`MsgAccountRouteConfig`
WHERE 
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm'
  AND
    /* Replace with a VARCHAR(16) */ 
    `execBrkrCode` = 'Example_execBrkrCode';

Doc Columns Query

SELECT * FROM SRControl.doccolumns WHERE TABLE_NAME='AccountRouteConfig' ORDER BY ordinal_position ASC;