Skip to main content
Version: 8.4.08.4

MLegOrderGateway

V8 Message Definiton

Records inserted, updated, or replaced into the MLegOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release.\nSee the SpiderRock Execution Engine concept guide for more details.

METADATA

AttributeValue
Topic5120-srse-gateway
MLink TokenSystemData
ProductSRTrade
accessTypeSELECT,UPDATE(spdrActionType),INSERT,DELETE

Table Definition

FieldTypeKeyDefault ValueComment
ticker_atenum - AssetTypePRI'None'
ticker_tsenum - TickerSrcPRI'None'
ticker_tkVARCHAR(12)PRI''
accntVARCHAR(16)PRI''Will automatically be set to the account associated with DB login
groupingCodeCHAR(19)PRI'0000-0000-0000-0000'Client supplied order
orderSideenum - BuySellPRI'Buy'
clientFirmVARCHAR(16)PRI''
spdrActionTypeenum - SpdrActionType'Add'Add new order AddReplace add or replace order Cancel cxl existing Replace update existing only Release modify order active size
altOrderIdVARCHAR(24)''Alternate client order ID This order ID will be copied to all execution reports
altAutoHedgeIdVARCHAR(24)''alternate order ID for child autohedge orders if any
altAccntVARCHAR(32)''alternate client assigned long account string optional used to map between client and SR account strings
altUserNameVARCHAR(24)''alternate client assigned user name optional used to map between client and SR account strings
execBrkrCodeVARCHAR(16)''optional override the default execBrkrCode for this order
strategyVARCHAR(36)''Client strategy string This value will appear on the SR Trade Monitor and in execution reports
orderDttmDATETIME(6)'1900-01-01 00:00:00.000000'order entry time from clientif any
orderSizeINT-1parent order size contracts 1 no changeused when spdrActionTypeRelease
orderActiveSizeINT-1total activated size total size released for execution 1 all available size
addCumFillQuantityenum - YesNo'No'If Yes then OrderSize is calculated order arrival as requested OrderSize existing CumFillQuantity
exchMaskINT UNSIGNED0eligible exchanges 0 all
maxExposureSizeINT-1maximum simultaneous cumulative child order public size exposure 1 orderActiveSize order can overfill if orderActiveSize and numMakeExchanges 1
numMakeExchangesTINYINT UNSIGNED1number of exchanges 1 4 on which to publish public making orders Effective number might be less than requested number if sufficient exchanges are not available
publicSizeenum - PublicSizeHandling'None'public order size handling Noneuse default size handling usually limits public size to typical market size Randomizerandomize public size MktSizeexpose only typical market size FullSizeexpose entire order size where possible
randomizeSizeenum - YesNo'Yes'randomize public order size
canOverlapCxlReplenum - YesNo'No'can execution engines overlap cancelreplace operations order can overfill if YES at most one active overlapping cxlreplace operation for each parent order
progressRuleenum - ProgressRule'None'None all size immediately availableTWAP size released in time intervalsVWAP size released in volume intervals
twapSliceCntTINYINT UNSIGNED4ProgressSliceCnt number of progress slices to use default 4 or 8 max 20
progressExposeTimeINT0minimum time secs to expose order 0 no minimum used to guarantee that the order is exposed at midmarket for some time before actively taking
auctionResponderenum - AuctionResponder'None'if set parent order can be an auction responder
autoHedgeenum - AutoHedge'None'
hedgeInstrumentenum - HedgeInst'Default'Defaultunderlier EQT or FUT Index Options use ETF FrontMonthunderlier EQT or front month FUT Index Options use FM Fut StockhedgeSecKey FuturehedgeSecKey
hedgeSecKey_atenum - AssetType'EQT'autohedge instrument either TickerKey or ExpiryKey
hedgeSecKey_tsenum - TickerSrc'NMS'autohedge instrument either TickerKey or ExpiryKey
hedgeSecKey_tkVARCHAR(12)''autohedge instrument either TickerKey or ExpiryKey
hedgeSecKey_yrSMALLINT UNSIGNED2000autohedge instrument either TickerKey or ExpiryKey
hedgeSecKey_mnTINYINT UNSIGNED0autohedge instrument either TickerKey or ExpiryKey
hedgeSecKey_dyTINYINT UNSIGNED0autohedge instrument either TickerKey or ExpiryKey
hedgeBetaRatioFLOAT1.0Portion of executed money to autohedge can be 10 Beta for beta hedging 40 to 40
hedgeScopeenum - HedgeScope'RiskGroup'Autohedge at the RiskGroup or Accnt level
hedgeSessionenum - MarketSession'RegMkt'
cxlUPrcRangeenum - UPrcCxl'None'cancel parent order ifwhen outside minmax uPrc range Halt also cancel if the securityunderlier has been halted
minUBidFLOAT0optional
maxUAskFLOAT0optional 001 none
minMaxTypeenum - MinMaxType'Prc'if Prc minUBidmaxUAsk are expressed as prices if Pct then they are expresses as pct change since parent order arrival
maxChildOrdersINT1000maximum number of child orders that can be generated by this parent order order will terminate ifwhen this cap is reachedzero or neg unlimited
spdrStageTypeenum - SpdrStageType'None'SizeLock stage pending modification can reduce size SizeModify stage pending modification can increasereduce size
marketSessionenum - MarketSession'RegMkt'
startDttmDATETIME(6)'2000-01-01'optional parent order start time
orderDurationINT-1optional number of seconds
activeDurationINT-1
goodTillDttmDATETIME(6)'2000-01-01'optional default 20000101
startTypeenum - StartType'None'WaitTrigger
parentOrderHandlingenum - ParentOrderHandling'CobMaker'
parentBalanceHandlingenum - ParentBalanceHandling'PostLimit'
orderLimitTypeenum - SpdrLimitType'Market'Various Prc PrcDe Rel Marketestablishes the primary LimitPrice for a parent order
takeLimitClassenum - SpdrLimitClass'Simple'Simple LimitPrice Surface BESTLimitPrice SurfLimit Probability BESTLimitPrice ProbLimit
makeLimitClassenum - SpdrLimitClass'Simple'Simple LimitPrice Surface BESTLimitPrice SurfLimit Probability BESTLimitPrice ProbLimit
takeReachRuleenum - ReachRule'None'None reach room immediately available Delayed available after 13 seconds Passive available if contra side aggresses WeakOnly only take if available size avgMarketSize ISOSweep Intermarket Sweep requires WaitTrigger
leadSideenum - BuySell'None'for legged orders which side to lead with optional None ok
maxCompletionSlippageDOUBLE0Maximum price slippage to complete an open basket or a cross auction face side slippage
orderPrcLimitDOUBLE0Applies if LimitType Prc
takeSurfPrcOffsetDOUBLE0default0
takeSurfVolOffsetFLOAT0default0
orderPrcOffsetDOUBLE0default0
takeAlphaTypeenum - AlphaType'None'Applies if takeLimitClass Probability
makeAlphaTypeenum - AlphaType'None'Applies if makeLimitClass Probability
takeAlphaFactorFLOAT022 takeProbLimit MAXtakeProbability takeProbAvg takeAlphaFactor takeProbStd if takeAlphaType Relative
makeAlphaFactorFLOAT022 makeProbLimit MAXmakeProbability makeProbAvg makeAlphaFactor makeProbStd if takeAlphaType Relative
takeProbabilityFLOAT0takeProbLimit takeProbability if takeAlphaType Static
makeProbabilityFLOAT0makeProbLimit makeProbability if makeAlphaType Static
firmTypeenum - FirmType'None'Used to override firmType in account config Default None use SpiderRock account configuration
stockSideenum - BuySell'None'Stock Orde Side if any
ssaleFlagenum - ShortSaleFlag'Auto'Used to determine stock autohedge flags
stockSharesINT0Number of shares in spread package Default 0 none
altStkLegIDVARCHAR(24)''Optional stock leg ID
numOptionLegsTINYINT UNSIGNED0The number of valid legs below The first leg is required and the rest are optional For each optional leg okey and mult must be valid values whereas side positionType and legID will be assigned default values
multihedgeenum - Multihedge'None'
optionTypeenum - OptionType'Equity'
underliersPerCnINT100Default 100
okey1_atenum - AssetType'None'Option symbol for leg 1 Must be a valid option symbol
okey1_tsenum - TickerSrc'None'Option symbol for leg 1 Must be a valid option symbol
okey1_tkVARCHAR(12)''Option symbol for leg 1 Must be a valid option symbol
okey1_yrSMALLINT UNSIGNED0Option symbol for leg 1 Must be a valid option symbol
okey1_mnTINYINT UNSIGNED0Option symbol for leg 1 Must be a valid option symbol
okey1_dyTINYINT UNSIGNED0Option symbol for leg 1 Must be a valid option symbol
okey1_xxDOUBLE0Option symbol for leg 1 Must be a valid option symbol
okey1_cpenum - CallPut'Call'Option symbol for leg 1 Must be a valid option symbol
mult1SMALLINT UNSIGNED0Multiplier for leg 1 Must be greater than zero
side1enum - BuySell'Buy'Order side for leg 1
positionType1enum - PositionType'Auto'Position type for leg 1
altLegID1VARCHAR(24)''ID for leg 1 If left blank will be assigned an autogenerated ID
okey2_atenum - AssetType'EQT'Option symbol for leg 2 Must be a valid option symbol
okey2_tsenum - TickerSrc'NMS'Option symbol for leg 2 Must be a valid option symbol
okey2_tkVARCHAR(12)''Option symbol for leg 2 Must be a valid option symbol
okey2_yrSMALLINT UNSIGNED1900Option symbol for leg 2 Must be a valid option symbol
okey2_mnTINYINT UNSIGNED1Option symbol for leg 2 Must be a valid option symbol
okey2_dyTINYINT UNSIGNED1Option symbol for leg 2 Must be a valid option symbol
okey2_xxDOUBLE100Option symbol for leg 2 Must be a valid option symbol
okey2_cpenum - CallPut'Call'Option symbol for leg 2 Must be a valid option symbol
mult2SMALLINT UNSIGNED0Multiplier for leg 2 Must be greater than zero
side2enum - BuySell'Buy'Order side for leg 2
positionType2enum - PositionType'Auto'Position type for leg 2
altLegID2VARCHAR(24)''ID for leg 2 If left blank will be assigned an autogenerated ID
okey3_atenum - AssetType'EQT'Option symbol for leg 3 Must be a valid option symbol
okey3_tsenum - TickerSrc'NMS'Option symbol for leg 3 Must be a valid option symbol
okey3_tkVARCHAR(12)''Option symbol for leg 3 Must be a valid option symbol
okey3_yrSMALLINT UNSIGNED1900Option symbol for leg 3 Must be a valid option symbol
okey3_mnTINYINT UNSIGNED1Option symbol for leg 3 Must be a valid option symbol
okey3_dyTINYINT UNSIGNED1Option symbol for leg 3 Must be a valid option symbol
okey3_xxDOUBLE100Option symbol for leg 3 Must be a valid option symbol
okey3_cpenum - CallPut'Call'Option symbol for leg 3 Must be a valid option symbol
mult3SMALLINT UNSIGNED0Multiplier for leg 3 Must be greater than zero
side3enum - BuySell'Buy'Order side for leg 3
positionType3enum - PositionType'Auto'Position type for leg 3
altLegID3VARCHAR(24)''ID for leg 3 If left blank will be assigned an autogenerated ID
okey4_atenum - AssetType'EQT'Option symbol for leg 4 Must be a valid option symbol
okey4_tsenum - TickerSrc'NMS'Option symbol for leg 4 Must be a valid option symbol
okey4_tkVARCHAR(12)''Option symbol for leg 4 Must be a valid option symbol
okey4_yrSMALLINT UNSIGNED1900Option symbol for leg 4 Must be a valid option symbol
okey4_mnTINYINT UNSIGNED1Option symbol for leg 4 Must be a valid option symbol
okey4_dyTINYINT UNSIGNED1Option symbol for leg 4 Must be a valid option symbol
okey4_xxDOUBLE100Option symbol for leg 4 Must be a valid option symbol
okey4_cpenum - CallPut'Call'Option symbol for leg 4 Must be a valid option symbol
mult4SMALLINT UNSIGNED0Multiplier for leg 4 Must be greater than zero
side4enum - BuySell'Buy'Order side for leg 4
positionType4enum - PositionType'Auto'Position type for leg 4
altLegID4VARCHAR(24)''ID for leg 4 If left blank will be assigned an autogenerated ID
okey5_atenum - AssetType'EQT'Option symbol for leg 5 Must be a valid option symbol
okey5_tsenum - TickerSrc'NMS'Option symbol for leg 5 Must be a valid option symbol
okey5_tkVARCHAR(12)''Option symbol for leg 5 Must be a valid option symbol
okey5_yrSMALLINT UNSIGNED1900Option symbol for leg 5 Must be a valid option symbol
okey5_mnTINYINT UNSIGNED1Option symbol for leg 5 Must be a valid option symbol
okey5_dyTINYINT UNSIGNED1Option symbol for leg 5 Must be a valid option symbol
okey5_xxDOUBLE100Option symbol for leg 5 Must be a valid option symbol
okey5_cpenum - CallPut'Call'Option symbol for leg 5 Must be a valid option symbol
mult5SMALLINT UNSIGNED0Multiplier for leg 5 Must be greater than zero
side5enum - BuySell'Buy'Order side for leg 5
positionType5enum - PositionType'Auto'Position type for leg 5
altLegID5VARCHAR(24)''ID for leg 5 If left blank will be assigned an autogenerated ID
okey6_atenum - AssetType'EQT'Option symbol for leg 6 Must be a valid option symbol
okey6_tsenum - TickerSrc'NMS'Option symbol for leg 6 Must be a valid option symbol
okey6_tkVARCHAR(12)''Option symbol for leg 6 Must be a valid option symbol
okey6_yrSMALLINT UNSIGNED1900Option symbol for leg 6 Must be a valid option symbol
okey6_mnTINYINT UNSIGNED1Option symbol for leg 6 Must be a valid option symbol
okey6_dyTINYINT UNSIGNED1Option symbol for leg 6 Must be a valid option symbol
okey6_xxDOUBLE100Option symbol for leg 6 Must be a valid option symbol
okey6_cpenum - CallPut'Call'Option symbol for leg 6 Must be a valid option symbol
mult6SMALLINT UNSIGNED0Multiplier for leg 6 Must be greater than zero
side6enum - BuySell'Buy'Order side for leg 6
positionType6enum - PositionType'Auto'Position type for leg 6
altLegID6VARCHAR(24)''ID for leg 6 If left blank will be assigned an autogenerated ID
optPremiumFLOAT0The premium for the option legs a contribution to the order premium Valid range is 99990 99990 Default 0
orderRefUPrcFLOAT0The stock reference price a contribution to the order premium Default 0
riskGroupIdCHAR(19)'0000-0000-0000-0000'Default 0 none Required to be nonzero if autoHedge is something other than None
reqAuxRiskGroupCtrlenum - YesNo'None'
refRMetric1Srcenum - RMetricSource'None'
refRMetric2Srcenum - RMetricSource'None'
refRMetric3Srcenum - RMetricSource'None'
refRMetric4Srcenum - RMetricSource'None'
refRMetric5Srcenum - RMetricSource'None'
refRMetric6Srcenum - RMetricSource'None'
refRMetric7Srcenum - RMetricSource'None'
orderRefRMetric1FLOAT0user supplied RMetric1 value used in RiskGroupID risk controls netRMetric1 sumfillQty orderRefRMetric1 underlierPerCn
orderRefRMetric2FLOAT0user supplied RMetric2 value used in RiskGroupID risk controls netRMetric2 sumfillQty orderRefRMetric2 underlierPerCn
orderRefRMetric3FLOAT0user supplied RMetric3 value used in RiskGroupID risk controls netRMetric3 sumfillQty orderRefRMetric3 underlierPerCn
orderRefRMetric4FLOAT0user supplied RMetric4 value used in RiskGroupID risk controls netRMetric4 sumfillQty orderRefRMetric4 underlierPerCn
orderRefRMetric5FLOAT0user supplied RMetric5 value used in RiskGroupID risk controls netRMetric5 sumfillQty orderRefRMetric5 underlierPerCn
orderRefRMetric6FLOAT0user supplied RMetric6 value used in ExpDay risk controls netRMetric6 sumfillQty orderRefRMetric6 underlierPerCn
orderRefRMetric7FLOAT0user supplied RMetric7 value used in SymDay risk controls netRMetric7 sumfillQty orderRefRMetric7 underlierPerCn
expDayWtVegaOffsetFLOAT-1max acctsymbol day wtVega offset target
maxExpDayWtVegaLnFLOAT-1max accntexpiration day time weighted vega long positive number1no limitrisk limit max limit current net counter offset
maxExpDayWtVegaShFLOAT-1max accntexpiration day time weighted vega short positive number1no limitrisk limit max limit current net counter offset
maxExpDayRMetric6LnFLOAT-1max acctexpiration day rMetric6 long positive number1no limitrisk limit max limit current net counter
maxExpDayRMetric6ShFLOAT-1max acctexpiration day rMetric6 short positive number1no limitrisk limit max limit current net counter
symDayDDeltaOffsetFLOAT-1max acctsymbol day delta offset target
maxSymDayDDeltaLnFLOAT-1max acctsymbol day delta long positive number1no limitrisk limit max limit current net counter offset
maxSymDayDDeltaShFLOAT-1max acctsymbol day delta short positive number1no limitrisk limit max limit current net counter offset
symDayVegaOffsetFLOAT-1max acctsymbol day vega offset target
maxSymDayVegaLnFLOAT-1max acctsymbol day vega long positive number1no limitrisk limit max limit current net counter offset
maxSymDayVegaShFLOAT-1max acctsymbol day vega short positive number1no limitrisk limit max limit current net counter offset
symDayWtVegaOffsetFLOAT-1max acctsymbol day wtVega offset target
maxSymDayWtVegaLnFLOAT-1max acctsymbol day time weighted vega long positive number1no limitrisk limit max limit current net counter offset
maxSymDayWtVegaShFLOAT-1max acctsymbol day time weighted vega short positive number1no limitrisk limit max limit current net counter offset
maxSymDayRMetric7LnFLOAT-1max acctsymbol day rMetric7 long positive number1no limitrisk limit max limit current net counter
maxSymDayRMetric7ShFLOAT-1max acctsymbol day rMetric7 short positive number1no limitrisk limit max limit current net counter
maxGrpDayDDeltaLnFLOAT-1max acctriskGroup day delta long positive number1no limitrisk limit max limit current net counter
maxGrpDayDDeltaShFLOAT-1max acctriskGroup day delta short positive number1no limitrisk limit max limit current net counter
maxGrpDayVegaLnFLOAT-1max acctriskGroup day vega long positive number1no limitrisk limit max limit current net counter
maxGrpDayVegaShFLOAT-1max acctriskGroup day vega short positive number1no limitrisk limit max limit current net counter
maxGrpDayVegaAbsFLOAT-1max acctriskGroup day vega abs positive number1no limitrisk limit max limit abscurrent net counter
grpDayVegaRatioFLOAT1.0target bot sld ratio eg ratio20 means that neutral is bot vega 2x sld vega
maxGrpDayContractsLnINT-1max acctriskGroup day opt contracts long positive number1no limitrisk limit max limit current net counter
maxGrpDayContractsShINT-1max acctriskGroup day opt contracts short positive number1no limitrisk limit max limit current net counter
maxGrpDayContractsAbsINT-1max acctriskGroup day opt contracts abs positive number1no limitrisk limit max limit abscurrent net counter
maxGrpDayRMetric1LnFLOAT-1max acctriskGroup day rMetric1 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric1ShFLOAT-1max acctriskGroup day rMetric1 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric1AbsFLOAT-1max acctriskGroup day rMetric1 abs positive number1no limitrisk limit max limit abscurrent net counter
grpDayRMetric1RatioFLOAT1.0target bot sld ratio eg ratio05 means that neutral is bot rMetric1 05x sld rMetric1
maxGrpDayRMetric2LnFLOAT-1max acctriskGroup day rMetric2 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric2ShFLOAT-1max acctriskGroup day rMetric2 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric3LnFLOAT-1max acctriskGroup day rMetric3 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric3ShFLOAT-1max acctriskGroup day rMetric3 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric4LnFLOAT-1max acctriskGroup day rMetric4 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric4ShFLOAT-1max acctriskGroup day rMetric4 short positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric5LnFLOAT-1max acctriskGroup day rMetric5 long positive number1no limitrisk limit max limit current net counter
maxGrpDayRMetric5ShFLOAT-1max acctriskGroup day rMetric5 short positive number1no limitrisk limit max limit current net counter
symEmaCxlDDeltaLnFLOAT-1max acctsymbol 60s EMA delta long positive number 0 is no limit will immediately cxl all option orders in a symbol if any order in the symbol breaches
symEmaCxlDDeltaShFLOAT-1max acctsymbol 60s EMA delta short positive number 0 is no limit
symEmaCxlWtVegaLnFLOAT-1max acctsymbol 60s EMA wtVega long positive number 0 is no limit will immediately cxl all option orders in a symbol if any order in the symbol breaches
symEmaCxlWtVegaShFLOAT-1max acctsymbol 60s EMA wtVega short positive number 0 is no limit
traderNameVARCHAR(32)''Name of the trader associated with the order
userData1TINYTEXT''client supplied data field passes through to parent and child executions and reports as well as FIX drops
userData2TINYTEXT''client supplied data field passes through to parent and child executions and reports as well as FIX drops
childDataTINYTEXT''client supplied data field passes through to down stream child orders
checksumTINYINT UNSIGNED0Must be set to 13 This helps detect some columnvalue misalignments

PRIMARY KEY DEFINITION (Unique)

FieldSequence
ticker_tk1
ticker_at2
ticker_ts3
accnt4
groupingCode5
orderSide6
clientFirm7

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgMLegOrderGateway` (
`ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None',
`ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None',
`ticker_tk` VARCHAR(12) NOT NULL DEFAULT '',
`accnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'Will automatically be set to the account associated with DB login',
`groupingCode` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000' COMMENT 'Client supplied order',
`orderSide` ENUM('None','Buy','Sell') NOT NULL DEFAULT 'Buy',
`clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
`spdrActionType` ENUM('Add','AddReplace','Replace','Cancel','Modify') NOT NULL DEFAULT 'Add' COMMENT '[Add (new order), AddReplace (add or replace order), Cancel (cxl existing), Replace (update existing only), Release (modify order active size)]',
`altOrderId` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'Alternate client order ID. This order ID will be copied to all execution reports.',
`altAutoHedgeId` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'alternate order ID for child autohedge orders (if any)',
`altAccnt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'alternate (client assigned) "long" account string (optional) [used to map between client and SR account strings]',
`altUserName` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'alternate (client assigned) user name (optional) [used to map between client and SR account strings]',
`execBrkrCode` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '(optional) override the default execBrkrCode for this order',
`strategy` VARCHAR(36) NOT NULL DEFAULT '' COMMENT 'Client strategy string. This value will appear on the SR Trade Monitor and in execution reports.',
`orderDttm` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'order entry time (from client;if any)',
`orderSize` INT NOT NULL DEFAULT -1 COMMENT 'parent order size (contracts) [-1 = no change;used when spdrActionType=Release]',
`orderActiveSize` INT NOT NULL DEFAULT -1 COMMENT 'total activated size (total size released for execution) (-1 = all available size)',
`addCumFillQuantity` ENUM('Yes','No') NOT NULL DEFAULT 'No' COMMENT 'If Yes then OrderSize is calculated @ order arrival as requested OrderSize + existing ''CumFillQuantity''.',
`exchMask` INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'eligible exchanges (0 = all)',
`maxExposureSize` INT NOT NULL DEFAULT -1 COMMENT 'maximum simultaneous cumulative child order public size exposure (-1 = orderActiveSize) [order can overfill if > orderActiveSize and numMakeExchanges > 1]',
`numMakeExchanges` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'number of exchanges (1 - 4) on which to publish public making orders. Effective number might be less than requested number if sufficient exchanges are not available.',
`publicSize` ENUM('None','Randomize','MktSize','FullSize','MktSizeA','MktSizeB','MktSizeC','FullSizeR') NOT NULL DEFAULT 'None' COMMENT 'public order size handling: None=use default size handling (usually limits public size to ''typical'' market size); Randomize=randomize public size; MktSize=expose only ''typical'' market size; FullSize=expose entire order size where possible',
`randomizeSize` ENUM('Yes','No') NOT NULL DEFAULT 'Yes' COMMENT 'randomize public order size',
`canOverlapCxlRepl` ENUM('Yes','No') NOT NULL DEFAULT 'No' COMMENT 'can execution engines overlap cancel/replace operations [order can overfill if YES] (at most one active overlapping cxl/replace operation for each parent order)',
`progressRule` ENUM('None','Twap','Vwap','TwapReset','VwapReset','FastReset','SlowReset','TwapAlpha','VwapAlpha','TwapAlphaC','VwapAlphaC','AutoComplete','AllowImmediate','Manual','SpdrPulse','IOC') NOT NULL DEFAULT 'None' COMMENT 'None = all size immediately available;TWAP = size released in time intervals;VWAP = size released in volume intervals;',
`twapSliceCnt` TINYINT UNSIGNED NOT NULL DEFAULT 4 COMMENT '[ProgressSliceCnt] number of progress slices to use (default = 4 or 8) [max 20]',
`progressExposeTime` INT NOT NULL DEFAULT 0 COMMENT 'minimum time (secs) to expose order (0 = no minimum; used to guarantee that the order is exposed at mid-market for some time before actively taking)',
`auctionResponder` ENUM('None','Any') NOT NULL DEFAULT 'None' COMMENT 'if set, parent order can be an auction responder',
`autoHedge` ENUM('None','Static','AutoMid','AutoCrx','AutoTrn','SpdrAuto','Spdr10S','Spdr30S','Spdr90S','Spdr5M','Spdr30M','SpdrDay','SmartFast','SmartNorm','FastCrx','FastDark','SlowDark','AlphaVwap1pct','AlphaVwap2pct','AlphaVwap5pct','AlphaVwap25pct','Custom','AwayAlgo') NOT NULL DEFAULT 'None',
`hedgeInstrument` ENUM('None','Default','FrontMonth','Stock','Future') NOT NULL DEFAULT 'Default' COMMENT 'Default=underlier (EQT or FUT) [Index Options use ETF]; FrontMonth=underlier (EQT) or front month (FUT) [Index Options use FM Fut]; Stock=hedgeSecKey; Future=hedgeSecKey',
`hedgeSecKey_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'EQT' COMMENT 'auto-hedge instrument (either TickerKey or ExpiryKey)',
`hedgeSecKey_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'NMS' COMMENT 'auto-hedge instrument (either TickerKey or ExpiryKey)',
`hedgeSecKey_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'auto-hedge instrument (either TickerKey or ExpiryKey)',
`hedgeSecKey_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 2000 COMMENT 'auto-hedge instrument (either TickerKey or ExpiryKey)',
`hedgeSecKey_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'auto-hedge instrument (either TickerKey or ExpiryKey)',
`hedgeSecKey_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'auto-hedge instrument (either TickerKey or ExpiryKey)',
`hedgeBetaRatio` FLOAT NOT NULL DEFAULT 1.0 COMMENT 'Portion of executed $money to auto-hedge (can be 1.0 / Beta for beta hedging) [-4.0 to +4.0]',
`hedgeScope` ENUM('None','Accnt','RiskGroup') NOT NULL DEFAULT 'RiskGroup' COMMENT 'Auto-hedge at the RiskGroup or Accnt level',
`hedgeSession` ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') NOT NULL DEFAULT 'RegMkt',
`cxlUPrcRange` ENUM('None','Yes','No','YesHalt','NoHalt') NOT NULL DEFAULT 'None' COMMENT 'cancel parent order if/when outside min/max uPrc range [_Halt = also cancel if the security/underlier has been halted]',
`minUBid` FLOAT NOT NULL DEFAULT 0 COMMENT '[optional]',
`maxUAsk` FLOAT NOT NULL DEFAULT 0 COMMENT '[optional] (< $0.01 = none)',
`minMaxType` ENUM('None','Prc','Pct') NOT NULL DEFAULT 'Prc' COMMENT 'if Prc minUBid/maxUAsk are expressed as prices; if Pct then they are expresses as pct change since parent order arrival',
`maxChildOrders` INT NOT NULL DEFAULT 1000 COMMENT 'maximum number of child orders that can be generated by this parent order [order will terminate if/when this cap is reached;zero or neg = unlimited]',
`spdrStageType` ENUM('None','ModifyAny','ModifyAlgo') NOT NULL DEFAULT 'None' COMMENT 'SizeLock = stage pending modification (can reduce size); SizeModify = stage pending modification (can increase/reduce size)',
`marketSession` ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') NOT NULL DEFAULT 'RegMkt',
`startDttm` DATETIME(6) NOT NULL DEFAULT '2000-01-01' COMMENT '[optional] (parent order start time)',
`orderDuration` INT NOT NULL DEFAULT -1 COMMENT '[optional] (number of seconds)',
`activeDuration` INT NOT NULL DEFAULT -1,
`goodTillDttm` DATETIME(6) NOT NULL DEFAULT '2000-01-01' COMMENT '[optional] (default: 2000-01-01)',
`startType` ENUM('None','WaitTrigger') NOT NULL DEFAULT 'None' COMMENT '[WaitTrigger]',
`parentOrderHandling` ENUM('None','Legger','Seeker','SeekerLegger','RFQRequest','AwayAlgo','ExchPing','BlockAuction','BlockResponse','SweepTake','CobMaker','TestParent') NOT NULL DEFAULT 'CobMaker',
`parentBalanceHandling` ENUM('None','PostWith','PostTurn','PostImprove','PostLimit','MaxIntern','PostWthF','PostImprvR','PostFlash','PostFlashW','PostPeg','PostFlashI') NOT NULL DEFAULT 'PostLimit',
`orderLimitType` ENUM('Market','MarketArrival','Prc','PrcDe','PrcDeX','RelMid','RelJoin','RelCross','RelTurn','Aux','UPrcPct') NOT NULL DEFAULT 'Market' COMMENT 'Various (Prc, PrcDe, Rel, Market);establishes the primary LimitPrice for a parent order',
`takeLimitClass` ENUM('Simple','Surface','Probability','SurfProb') NOT NULL DEFAULT 'Simple' COMMENT 'Simple = LimitPrice, Surface = BEST(LimitPrice, SurfLimit), Probability = BEST(LimitPrice, ProbLimit)',
`makeLimitClass` ENUM('Simple','Surface','Probability','SurfProb') NOT NULL DEFAULT 'Simple' COMMENT 'Simple = LimitPrice, Surface = BEST(LimitPrice, SurfLimit), Probability = BEST(LimitPrice, ProbLimit)',
`takeReachRule` ENUM('None','Delayed','Passive','WeakOnly','RespondOnly','FullSize','ISOSweep','AllOrNone','QtyOrMore','UpToQty','AtMost25','AtMost50','MinTakeFee') NOT NULL DEFAULT 'None' COMMENT 'None = reach room immediately available; Delayed = available after [1-3] seconds; Passive = available if contra side aggresses; WeakOnly = only take if available size < avgMarketSize; ISOSweep = Intermarket Sweep [requires WaitTrigger]',
`leadSide` ENUM('None','Buy','Sell') NOT NULL DEFAULT 'None' COMMENT 'for legged orders, which side to lead with. (optional, None ok)',
`maxCompletionSlippage` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Maximum price slippage to complete an open basket or a cross auction (face side slippage)',
`orderPrcLimit` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Applies if LimitType = Prc[]',
`takeSurfPrcOffset` DOUBLE NOT NULL DEFAULT 0 COMMENT 'default=0',
`takeSurfVolOffset` FLOAT NOT NULL DEFAULT 0 COMMENT 'default=0',
`orderPrcOffset` DOUBLE NOT NULL DEFAULT 0 COMMENT 'default=0',
`takeAlphaType` ENUM('None','Static','Eagle','Hawk','Falcon','Relative') NOT NULL DEFAULT 'None' COMMENT 'Applies if takeLimitClass = Probability',
`makeAlphaType` ENUM('None','Static','Eagle','Hawk','Falcon','Relative') NOT NULL DEFAULT 'None' COMMENT 'Applies if makeLimitClass = Probability',
`takeAlphaFactor` FLOAT NOT NULL DEFAULT 0 COMMENT '[-2,+2] takeProbLimit = MAX(takeProbability, takeProbAvg + takeAlphaFactor * takeProbStd) [if takeAlphaType = Relative]',
`makeAlphaFactor` FLOAT NOT NULL DEFAULT 0 COMMENT '[-2,+2] makeProbLimit = MAX(makeProbability, makeProbAvg + makeAlphaFactor * makeProbStd) [if takeAlphaType = Relative]',
`takeProbability` FLOAT NOT NULL DEFAULT 0 COMMENT 'takeProbLimit = takeProbability [if takeAlphaType = Static]',
`makeProbability` FLOAT NOT NULL DEFAULT 0 COMMENT 'makeProbLimit = makeProbability [if makeAlphaType = Static]',
`firmType` ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') NOT NULL DEFAULT 'None' COMMENT 'Used to override firmType in account config. Default: None (use SpiderRock account configuration).',
`stockSide` ENUM('None','Buy','Sell') NOT NULL DEFAULT 'None' COMMENT 'Stock Orde Side (if any).',
`ssaleFlag` ENUM('None','Long','Short','Exempt','Cover','Auto','NA') NOT NULL DEFAULT 'Auto' COMMENT 'Used to determine stock auto-hedge flags.',
`stockShares` INT NOT NULL DEFAULT 0 COMMENT 'Number of shares in spread package. Default: 0 (none).',
`altStkLegID` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'Optional stock leg ID.',
`numOptionLegs` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'The number of valid legs below. The first leg is required and the rest are optional. For each optional leg `okey_` and `mult_` must be valid values whereas `side_`, `positionType_`, and `legID_` will be assigned default values.',
`multihedge` ENUM('None','Simple','Complex','AllCash') NOT NULL DEFAULT 'None',
`optionType` ENUM('Equity','Index','Future','Binary','MapError') NOT NULL DEFAULT 'Equity',
`underliersPerCn` INT NOT NULL DEFAULT 100 COMMENT 'Default: 100.',
`okey1_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_mn` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_dy` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_xx` DOUBLE NOT NULL DEFAULT 0 COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`okey1_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Option symbol for leg #1. Must be a valid option symbol.',
`mult1` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Multiplier for leg #1. Must be greater than zero.',
`side1` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #1.',
`positionType1` ENUM('Opening','Closing','Auto') NOT NULL DEFAULT 'Auto' COMMENT 'Position type for leg #1.',
`altLegID1` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'ID for leg #1. If left blank will be assigned an auto-generated ID.',
`okey2_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'EQT' COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'NMS' COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_mn` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_dy` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_xx` DOUBLE NOT NULL DEFAULT 100 COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`okey2_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Option symbol for leg #2. Must be a valid option symbol.',
`mult2` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Multiplier for leg #2. Must be greater than zero.',
`side2` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #2.',
`positionType2` ENUM('Opening','Closing','Auto') NOT NULL DEFAULT 'Auto' COMMENT 'Position type for leg #2.',
`altLegID2` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'ID for leg #2. If left blank will be assigned an auto-generated ID.',
`okey3_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'EQT' COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'NMS' COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_mn` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_dy` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_xx` DOUBLE NOT NULL DEFAULT 100 COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`okey3_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Option symbol for leg #3. Must be a valid option symbol.',
`mult3` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Multiplier for leg #3. Must be greater than zero.',
`side3` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #3.',
`positionType3` ENUM('Opening','Closing','Auto') NOT NULL DEFAULT 'Auto' COMMENT 'Position type for leg #3.',
`altLegID3` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'ID for leg #3. If left blank will be assigned an auto-generated ID.',
`okey4_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'EQT' COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'NMS' COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_mn` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_dy` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_xx` DOUBLE NOT NULL DEFAULT 100 COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`okey4_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Option symbol for leg #4. Must be a valid option symbol.',
`mult4` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Multiplier for leg #4. Must be greater than zero.',
`side4` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #4.',
`positionType4` ENUM('Opening','Closing','Auto') NOT NULL DEFAULT 'Auto' COMMENT 'Position type for leg #4.',
`altLegID4` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'ID for leg #4. If left blank will be assigned an auto-generated ID.',
`okey5_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'EQT' COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'NMS' COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_mn` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_dy` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_xx` DOUBLE NOT NULL DEFAULT 100 COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`okey5_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Option symbol for leg #5. Must be a valid option symbol.',
`mult5` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Multiplier for leg #5. Must be greater than zero.',
`side5` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #5.',
`positionType5` ENUM('Opening','Closing','Auto') NOT NULL DEFAULT 'Auto' COMMENT 'Position type for leg #5.',
`altLegID5` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'ID for leg #5. If left blank will be assigned an auto-generated ID.',
`okey6_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'EQT' COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'NMS' COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_yr` SMALLINT UNSIGNED NOT NULL DEFAULT 1900 COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_mn` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_dy` TINYINT UNSIGNED NOT NULL DEFAULT 1 COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_xx` DOUBLE NOT NULL DEFAULT 100 COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`okey6_cp` ENUM('Call','Put','Pair') NOT NULL DEFAULT 'Call' COMMENT 'Option symbol for leg #6. Must be a valid option symbol.',
`mult6` SMALLINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Multiplier for leg #6. Must be greater than zero.',
`side6` ENUM('Buy','Sell') NOT NULL DEFAULT 'Buy' COMMENT 'Order side for leg #6.',
`positionType6` ENUM('Opening','Closing','Auto') NOT NULL DEFAULT 'Auto' COMMENT 'Position type for leg #6.',
`altLegID6` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'ID for leg #6. If left blank will be assigned an auto-generated ID.',
`optPremium` FLOAT NOT NULL DEFAULT 0 COMMENT 'The premium for the option legs, a contribution to the order premium. Valid range is [-9999.0, 9999.0]. Default: 0.',
`orderRefUPrc` FLOAT NOT NULL DEFAULT 0 COMMENT 'The stock reference price, a contribution to the order premium. Default: 0.',
`riskGroupId` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000' COMMENT 'Default: 0 (none). Required to be non-zero if `autoHedge` is something other than None.',
`reqAuxRiskGroupCtrl` ENUM('None','Yes','No') NOT NULL DEFAULT 'None',
`refRMetric1Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`refRMetric2Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`refRMetric3Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`refRMetric4Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`refRMetric5Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`refRMetric6Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`refRMetric7Src` ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') NOT NULL DEFAULT 'None',
`orderRefRMetric1` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric1 value (used in RiskGroupID risk controls) [netRMetric1 = sum(fillQty * orderRefRMetric1 * underlierPerCn)]',
`orderRefRMetric2` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric2 value (used in RiskGroupID risk controls) [netRMetric2 = sum(fillQty * orderRefRMetric2 * underlierPerCn)]',
`orderRefRMetric3` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric3 value (used in RiskGroupID risk controls) [netRMetric3 = sum(fillQty * orderRefRMetric3 * underlierPerCn)]',
`orderRefRMetric4` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric4 value (used in RiskGroupID risk controls) [netRMetric4 = sum(fillQty * orderRefRMetric4 * underlierPerCn)]',
`orderRefRMetric5` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric5 value (used in RiskGroupID risk controls) [netRMetric5 = sum(fillQty * orderRefRMetric5 * underlierPerCn)]',
`orderRefRMetric6` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric6 value (used in ExpDay risk controls) [netRMetric6 = sum(fillQty * orderRefRMetric6 * underlierPerCn)]',
`orderRefRMetric7` FLOAT NOT NULL DEFAULT 0 COMMENT 'user supplied RMetric7 value (used in SymDay risk controls) [netRMetric7 = sum(fillQty * orderRefRMetric7 * underlierPerCn)]',
`expDayWtVegaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day wtVega offset (target)',
`maxExpDayWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max accnt+expiration day (time weighted) vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
`maxExpDayWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max accnt+expiration day (time weighted) vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
`maxExpDayRMetric6Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+expiration day rMetric6 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxExpDayRMetric6Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+expiration day rMetric6 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`symDayDDeltaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day $delta offset (target)',
`maxSymDayDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day $delta long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
`maxSymDayDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day $delta short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
`symDayVegaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day vega offset (target)',
`maxSymDayVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
`maxSymDayVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
`symDayWtVegaOffset` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day wtVega offset (target)',
`maxSymDayWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day (time weighted) vega long (positive number;-1=no limit);risk limit = max limit - (current net counter - offset)',
`maxSymDayWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day (time weighted) vega short (positive number;-1=no limit);risk limit = max limit + (current net counter - offset)',
`maxSymDayRMetric7Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day rMetric7 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxSymDayRMetric7Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol day rMetric7 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day $delta long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day $delta short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day vega long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day vega short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayVegaAbs` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day vega abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)',
`grpDayVegaRatio` FLOAT NOT NULL DEFAULT 1.0 COMMENT 'target bot / sld ratio (eg ratio=2.0 means that neutral is bot vega = 2x sld vega)',
`maxGrpDayContractsLn` INT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day opt contracts long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayContractsSh` INT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day opt contracts short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayContractsAbs` INT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day opt contracts abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)',
`maxGrpDayRMetric1Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric1 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayRMetric1Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric1 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayRMetric1Abs` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric1 abs (positive number;-1=no limit);risk limit = max limit - abs(current net counter)',
`grpDayRMetric1Ratio` FLOAT NOT NULL DEFAULT 1.0 COMMENT 'target bot / sld ratio (eg ratio=0.5 means that neutral is bot rMetric1 = 0.5x sld rMetric1)',
`maxGrpDayRMetric2Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric2 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayRMetric2Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric2 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayRMetric3Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric3 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayRMetric3Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric3 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayRMetric4Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric4 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayRMetric4Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric4 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`maxGrpDayRMetric5Ln` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric5 long (positive number;-1=no limit);risk limit = max limit - current net counter',
`maxGrpDayRMetric5Sh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+riskGroup day rMetric5 short (positive number;-1=no limit);risk limit = max limit + current net counter',
`symEmaCxlDDeltaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA $delta long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]',
`symEmaCxlDDeltaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA $delta short (positive number; <= 0 is no limit)',
`symEmaCxlWtVegaLn` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA wtVega long (positive number; <= 0 is no limit) [will immediately cxl all option orders in a symbol if any order in the symbol breaches]',
`symEmaCxlWtVegaSh` FLOAT NOT NULL DEFAULT -1 COMMENT 'max acct+symbol 60s EMA wtVega short (positive number; <= 0 is no limit)',
`traderName` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'Name of the trader associated with the order',
`userData1` TINYTEXT NOT NULL DEFAULT '' COMMENT 'client supplied data field; passes through to parent and child executions and reports as well as FIX drops',
`userData2` TINYTEXT NOT NULL DEFAULT '' COMMENT 'client supplied data field; passes through to parent and child executions and reports as well as FIX drops',
`childData` TINYTEXT NOT NULL DEFAULT '' COMMENT 'client supplied data field; passes through to down stream child orders',
`checksum` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'Must be set to 13. This helps detect some column/value misalignments.',
CONSTRAINT nonnegative_groupingCode CHECK(ASCII(groupingCode) < 56),
CONSTRAINT nonnegative_riskGroupId CHECK(ASCII(riskGroupId) < 56),
PRIMARY KEY USING HASH (`ticker_tk`,`ticker_at`,`ticker_ts`,`accnt`,`groupingCode`,`orderSide`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='Records inserted, updated, or replaced into the MLegOrderGateway table are validated and then converted to SpdrParentOrder records and forwarded to the appropriate execution engine for futher processing. Parent orders can be inserted as either active/ready or in a wait start mode that requires subsequent release.\nSee the SpiderRock Execution Engine concept guide for more details.';

SELECT TABLE EXAMPLE QUERY

SELECT
`ticker_at`,
`ticker_ts`,
`ticker_tk`,
`accnt`,
`groupingCode`,
`orderSide`,
`clientFirm`,
`spdrActionType`,
`altOrderId`,
`altAutoHedgeId`,
`altAccnt`,
`altUserName`,
`execBrkrCode`,
`strategy`,
`orderDttm`,
`orderSize`,
`orderActiveSize`,
`addCumFillQuantity`,
`exchMask`,
`maxExposureSize`,
`numMakeExchanges`,
`publicSize`,
`randomizeSize`,
`canOverlapCxlRepl`,
`progressRule`,
`twapSliceCnt`,
`progressExposeTime`,
`auctionResponder`,
`autoHedge`,
`hedgeInstrument`,
`hedgeSecKey_at`,
`hedgeSecKey_ts`,
`hedgeSecKey_tk`,
`hedgeSecKey_yr`,
`hedgeSecKey_mn`,
`hedgeSecKey_dy`,
`hedgeBetaRatio`,
`hedgeScope`,
`hedgeSession`,
`cxlUPrcRange`,
`minUBid`,
`maxUAsk`,
`minMaxType`,
`maxChildOrders`,
`spdrStageType`,
`marketSession`,
`startDttm`,
`orderDuration`,
`activeDuration`,
`goodTillDttm`,
`startType`,
`parentOrderHandling`,
`parentBalanceHandling`,
`orderLimitType`,
`takeLimitClass`,
`makeLimitClass`,
`takeReachRule`,
`leadSide`,
`maxCompletionSlippage`,
`orderPrcLimit`,
`takeSurfPrcOffset`,
`takeSurfVolOffset`,
`orderPrcOffset`,
`takeAlphaType`,
`makeAlphaType`,
`takeAlphaFactor`,
`makeAlphaFactor`,
`takeProbability`,
`makeProbability`,
`firmType`,
`stockSide`,
`ssaleFlag`,
`stockShares`,
`altStkLegID`,
`numOptionLegs`,
`multihedge`,
`optionType`,
`underliersPerCn`,
`okey1_at`,
`okey1_ts`,
`okey1_tk`,
`okey1_yr`,
`okey1_mn`,
`okey1_dy`,
`okey1_xx`,
`okey1_cp`,
`mult1`,
`side1`,
`positionType1`,
`altLegID1`,
`okey2_at`,
`okey2_ts`,
`okey2_tk`,
`okey2_yr`,
`okey2_mn`,
`okey2_dy`,
`okey2_xx`,
`okey2_cp`,
`mult2`,
`side2`,
`positionType2`,
`altLegID2`,
`okey3_at`,
`okey3_ts`,
`okey3_tk`,
`okey3_yr`,
`okey3_mn`,
`okey3_dy`,
`okey3_xx`,
`okey3_cp`,
`mult3`,
`side3`,
`positionType3`,
`altLegID3`,
`okey4_at`,
`okey4_ts`,
`okey4_tk`,
`okey4_yr`,
`okey4_mn`,
`okey4_dy`,
`okey4_xx`,
`okey4_cp`,
`mult4`,
`side4`,
`positionType4`,
`altLegID4`,
`okey5_at`,
`okey5_ts`,
`okey5_tk`,
`okey5_yr`,
`okey5_mn`,
`okey5_dy`,
`okey5_xx`,
`okey5_cp`,
`mult5`,
`side5`,
`positionType5`,
`altLegID5`,
`okey6_at`,
`okey6_ts`,
`okey6_tk`,
`okey6_yr`,
`okey6_mn`,
`okey6_dy`,
`okey6_xx`,
`okey6_cp`,
`mult6`,
`side6`,
`positionType6`,
`altLegID6`,
`optPremium`,
`orderRefUPrc`,
`riskGroupId`,
`reqAuxRiskGroupCtrl`,
`refRMetric1Src`,
`refRMetric2Src`,
`refRMetric3Src`,
`refRMetric4Src`,
`refRMetric5Src`,
`refRMetric6Src`,
`refRMetric7Src`,
`orderRefRMetric1`,
`orderRefRMetric2`,
`orderRefRMetric3`,
`orderRefRMetric4`,
`orderRefRMetric5`,
`orderRefRMetric6`,
`orderRefRMetric7`,
`expDayWtVegaOffset`,
`maxExpDayWtVegaLn`,
`maxExpDayWtVegaSh`,
`maxExpDayRMetric6Ln`,
`maxExpDayRMetric6Sh`,
`symDayDDeltaOffset`,
`maxSymDayDDeltaLn`,
`maxSymDayDDeltaSh`,
`symDayVegaOffset`,
`maxSymDayVegaLn`,
`maxSymDayVegaSh`,
`symDayWtVegaOffset`,
`maxSymDayWtVegaLn`,
`maxSymDayWtVegaSh`,
`maxSymDayRMetric7Ln`,
`maxSymDayRMetric7Sh`,
`maxGrpDayDDeltaLn`,
`maxGrpDayDDeltaSh`,
`maxGrpDayVegaLn`,
`maxGrpDayVegaSh`,
`maxGrpDayVegaAbs`,
`grpDayVegaRatio`,
`maxGrpDayContractsLn`,
`maxGrpDayContractsSh`,
`maxGrpDayContractsAbs`,
`maxGrpDayRMetric1Ln`,
`maxGrpDayRMetric1Sh`,
`maxGrpDayRMetric1Abs`,
`grpDayRMetric1Ratio`,
`maxGrpDayRMetric2Ln`,
`maxGrpDayRMetric2Sh`,
`maxGrpDayRMetric3Ln`,
`maxGrpDayRMetric3Sh`,
`maxGrpDayRMetric4Ln`,
`maxGrpDayRMetric4Sh`,
`maxGrpDayRMetric5Ln`,
`maxGrpDayRMetric5Sh`,
`symEmaCxlDDeltaLn`,
`symEmaCxlDDeltaSh`,
`symEmaCxlWtVegaLn`,
`symEmaCxlWtVegaSh`,
`traderName`,
`userData1`,
`userData2`,
`childData`,
`checksum`
FROM `SRTrade`.`MsgMLegOrderGateway`
WHERE
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`ticker_at` = 'None'
AND
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`ticker_ts` = 'None'
AND
/* Replace with a VARCHAR(12) */
`ticker_tk` = 'Example_ticker_tk'
AND
/* Replace with a VARCHAR(16) */
`accnt` = 'Example_accnt'
AND
/* Replace with a CHAR(19) */
`groupingCode` = 'Example_groupingCode'
AND
/* Replace with a ENUM('None','Buy','Sell') */
`orderSide` = 'Buy'
AND
/* Replace with a VARCHAR(16) */
`clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRTrade`.`MsgMLegOrderGateway`(
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`ticker_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`ticker_ts`,
/* Replace with a VARCHAR(12) */
`ticker_tk`,
/* Replace with a VARCHAR(16) */
`accnt`,
/* Replace with a CHAR(19) */
`groupingCode`,
/* Replace with a ENUM('None','Buy','Sell') */
`orderSide`,
/* Replace with a VARCHAR(16) */
`clientFirm`,
/* Replace with a ENUM('Add','AddReplace','Replace','Cancel','Modify') */
`spdrActionType`,
/* Replace with a VARCHAR(24) */
`altOrderId`,
/* Replace with a VARCHAR(24) */
`altAutoHedgeId`,
/* Replace with a VARCHAR(32) */
`altAccnt`,
/* Replace with a VARCHAR(24) */
`altUserName`,
/* Replace with a VARCHAR(16) */
`execBrkrCode`,
/* Replace with a VARCHAR(36) */
`strategy`,
/* Replace with a DATETIME(6) */
`orderDttm`,
/* Replace with a INT */
`orderSize`,
/* Replace with a INT */
`orderActiveSize`,
/* Replace with a ENUM('Yes','No') */
`addCumFillQuantity`,
/* Replace with a INT UNSIGNED */
`exchMask`,
/* Replace with a INT */
`maxExposureSize`,
/* Replace with a TINYINT UNSIGNED */
`numMakeExchanges`,
/* Replace with a ENUM('None','Randomize','MktSize','FullSize','MktSizeA','MktSizeB','MktSizeC','FullSizeR') */
`publicSize`,
/* Replace with a ENUM('Yes','No') */
`randomizeSize`,
/* Replace with a ENUM('Yes','No') */
`canOverlapCxlRepl`,
/* Replace with a ENUM('None','Twap','Vwap','TwapReset','VwapReset','FastReset','SlowReset','TwapAlpha','VwapAlpha','TwapAlphaC','VwapAlphaC','AutoComplete','AllowImmediate','Manual','SpdrPulse','IOC') */
`progressRule`,
/* Replace with a TINYINT UNSIGNED */
`twapSliceCnt`,
/* Replace with a INT */
`progressExposeTime`,
/* Replace with a ENUM('None','Any') */
`auctionResponder`,
/* Replace with a ENUM('None','Static','AutoMid','AutoCrx','AutoTrn','SpdrAuto','Spdr10S','Spdr30S','Spdr90S','Spdr5M','Spdr30M','SpdrDay','SmartFast','SmartNorm','FastCrx','FastDark','SlowDark','AlphaVwap1pct','AlphaVwap2pct','AlphaVwap5pct','AlphaVwap25pct','Custom','AwayAlgo') */
`autoHedge`,
/* Replace with a ENUM('None','Default','FrontMonth','Stock','Future') */
`hedgeInstrument`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`hedgeSecKey_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`hedgeSecKey_ts`,
/* Replace with a VARCHAR(12) */
`hedgeSecKey_tk`,
/* Replace with a SMALLINT UNSIGNED */
`hedgeSecKey_yr`,
/* Replace with a TINYINT UNSIGNED */
`hedgeSecKey_mn`,
/* Replace with a TINYINT UNSIGNED */
`hedgeSecKey_dy`,
/* Replace with a FLOAT */
`hedgeBetaRatio`,
/* Replace with a ENUM('None','Accnt','RiskGroup') */
`hedgeScope`,
/* Replace with a ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') */
`hedgeSession`,
/* Replace with a ENUM('None','Yes','No','YesHalt','NoHalt') */
`cxlUPrcRange`,
/* Replace with a FLOAT */
`minUBid`,
/* Replace with a FLOAT */
`maxUAsk`,
/* Replace with a ENUM('None','Prc','Pct') */
`minMaxType`,
/* Replace with a INT */
`maxChildOrders`,
/* Replace with a ENUM('None','ModifyAny','ModifyAlgo') */
`spdrStageType`,
/* Replace with a ENUM('None','PreMkt','RegMkt','PostMkt','PreRegMkt','RegPostMkt','AllDay') */
`marketSession`,
/* Replace with a DATETIME(6) */
`startDttm`,
/* Replace with a INT */
`orderDuration`,
/* Replace with a INT */
`activeDuration`,
/* Replace with a DATETIME(6) */
`goodTillDttm`,
/* Replace with a ENUM('None','WaitTrigger') */
`startType`,
/* Replace with a ENUM('None','Legger','Seeker','SeekerLegger','RFQRequest','AwayAlgo','ExchPing','BlockAuction','BlockResponse','SweepTake','CobMaker','TestParent') */
`parentOrderHandling`,
/* Replace with a ENUM('None','PostWith','PostTurn','PostImprove','PostLimit','MaxIntern','PostWthF','PostImprvR','PostFlash','PostFlashW','PostPeg','PostFlashI') */
`parentBalanceHandling`,
/* Replace with a ENUM('Market','MarketArrival','Prc','PrcDe','PrcDeX','RelMid','RelJoin','RelCross','RelTurn','Aux','UPrcPct') */
`orderLimitType`,
/* Replace with a ENUM('Simple','Surface','Probability','SurfProb') */
`takeLimitClass`,
/* Replace with a ENUM('Simple','Surface','Probability','SurfProb') */
`makeLimitClass`,
/* Replace with a ENUM('None','Delayed','Passive','WeakOnly','RespondOnly','FullSize','ISOSweep','AllOrNone','QtyOrMore','UpToQty','AtMost25','AtMost50','MinTakeFee') */
`takeReachRule`,
/* Replace with a ENUM('None','Buy','Sell') */
`leadSide`,
/* Replace with a DOUBLE */
`maxCompletionSlippage`,
/* Replace with a DOUBLE */
`orderPrcLimit`,
/* Replace with a DOUBLE */
`takeSurfPrcOffset`,
/* Replace with a FLOAT */
`takeSurfVolOffset`,
/* Replace with a DOUBLE */
`orderPrcOffset`,
/* Replace with a ENUM('None','Static','Eagle','Hawk','Falcon','Relative') */
`takeAlphaType`,
/* Replace with a ENUM('None','Static','Eagle','Hawk','Falcon','Relative') */
`makeAlphaType`,
/* Replace with a FLOAT */
`takeAlphaFactor`,
/* Replace with a FLOAT */
`makeAlphaFactor`,
/* Replace with a FLOAT */
`takeProbability`,
/* Replace with a FLOAT */
`makeProbability`,
/* Replace with a ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') */
`firmType`,
/* Replace with a ENUM('None','Buy','Sell') */
`stockSide`,
/* Replace with a ENUM('None','Long','Short','Exempt','Cover','Auto','NA') */
`ssaleFlag`,
/* Replace with a INT */
`stockShares`,
/* Replace with a VARCHAR(24) */
`altStkLegID`,
/* Replace with a TINYINT UNSIGNED */
`numOptionLegs`,
/* Replace with a ENUM('None','Simple','Complex','AllCash') */
`multihedge`,
/* Replace with a ENUM('Equity','Index','Future','Binary','MapError') */
`optionType`,
/* Replace with a INT */
`underliersPerCn`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`okey1_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`okey1_ts`,
/* Replace with a VARCHAR(12) */
`okey1_tk`,
/* Replace with a SMALLINT UNSIGNED */
`okey1_yr`,
/* Replace with a TINYINT UNSIGNED */
`okey1_mn`,
/* Replace with a TINYINT UNSIGNED */
`okey1_dy`,
/* Replace with a DOUBLE */
`okey1_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`okey1_cp`,
/* Replace with a SMALLINT UNSIGNED */
`mult1`,
/* Replace with a ENUM('Buy','Sell') */
`side1`,
/* Replace with a ENUM('Opening','Closing','Auto') */
`positionType1`,
/* Replace with a VARCHAR(24) */
`altLegID1`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`okey2_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`okey2_ts`,
/* Replace with a VARCHAR(12) */
`okey2_tk`,
/* Replace with a SMALLINT UNSIGNED */
`okey2_yr`,
/* Replace with a TINYINT UNSIGNED */
`okey2_mn`,
/* Replace with a TINYINT UNSIGNED */
`okey2_dy`,
/* Replace with a DOUBLE */
`okey2_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`okey2_cp`,
/* Replace with a SMALLINT UNSIGNED */
`mult2`,
/* Replace with a ENUM('Buy','Sell') */
`side2`,
/* Replace with a ENUM('Opening','Closing','Auto') */
`positionType2`,
/* Replace with a VARCHAR(24) */
`altLegID2`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`okey3_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`okey3_ts`,
/* Replace with a VARCHAR(12) */
`okey3_tk`,
/* Replace with a SMALLINT UNSIGNED */
`okey3_yr`,
/* Replace with a TINYINT UNSIGNED */
`okey3_mn`,
/* Replace with a TINYINT UNSIGNED */
`okey3_dy`,
/* Replace with a DOUBLE */
`okey3_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`okey3_cp`,
/* Replace with a SMALLINT UNSIGNED */
`mult3`,
/* Replace with a ENUM('Buy','Sell') */
`side3`,
/* Replace with a ENUM('Opening','Closing','Auto') */
`positionType3`,
/* Replace with a VARCHAR(24) */
`altLegID3`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`okey4_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`okey4_ts`,
/* Replace with a VARCHAR(12) */
`okey4_tk`,
/* Replace with a SMALLINT UNSIGNED */
`okey4_yr`,
/* Replace with a TINYINT UNSIGNED */
`okey4_mn`,
/* Replace with a TINYINT UNSIGNED */
`okey4_dy`,
/* Replace with a DOUBLE */
`okey4_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`okey4_cp`,
/* Replace with a SMALLINT UNSIGNED */
`mult4`,
/* Replace with a ENUM('Buy','Sell') */
`side4`,
/* Replace with a ENUM('Opening','Closing','Auto') */
`positionType4`,
/* Replace with a VARCHAR(24) */
`altLegID4`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`okey5_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`okey5_ts`,
/* Replace with a VARCHAR(12) */
`okey5_tk`,
/* Replace with a SMALLINT UNSIGNED */
`okey5_yr`,
/* Replace with a TINYINT UNSIGNED */
`okey5_mn`,
/* Replace with a TINYINT UNSIGNED */
`okey5_dy`,
/* Replace with a DOUBLE */
`okey5_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`okey5_cp`,
/* Replace with a SMALLINT UNSIGNED */
`mult5`,
/* Replace with a ENUM('Buy','Sell') */
`side5`,
/* Replace with a ENUM('Opening','Closing','Auto') */
`positionType5`,
/* Replace with a VARCHAR(24) */
`altLegID5`,
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`okey6_at`,
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`okey6_ts`,
/* Replace with a VARCHAR(12) */
`okey6_tk`,
/* Replace with a SMALLINT UNSIGNED */
`okey6_yr`,
/* Replace with a TINYINT UNSIGNED */
`okey6_mn`,
/* Replace with a TINYINT UNSIGNED */
`okey6_dy`,
/* Replace with a DOUBLE */
`okey6_xx`,
/* Replace with a ENUM('Call','Put','Pair') */
`okey6_cp`,
/* Replace with a SMALLINT UNSIGNED */
`mult6`,
/* Replace with a ENUM('Buy','Sell') */
`side6`,
/* Replace with a ENUM('Opening','Closing','Auto') */
`positionType6`,
/* Replace with a VARCHAR(24) */
`altLegID6`,
/* Replace with a FLOAT */
`optPremium`,
/* Replace with a FLOAT */
`orderRefUPrc`,
/* Replace with a CHAR(19) */
`riskGroupId`,
/* Replace with a ENUM('None','Yes','No') */
`reqAuxRiskGroupCtrl`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric1Src`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric2Src`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric3Src`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric4Src`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric5Src`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric6Src`,
/* Replace with a ENUM('None','User','Vega','WVega','WTVega','TVega','Theta','Gamma','DGamma','DDeltaIvS','BDDelta','OptDDelta','Premium','Notional') */
`refRMetric7Src`,
/* Replace with a FLOAT */
`orderRefRMetric1`,
/* Replace with a FLOAT */
`orderRefRMetric2`,
/* Replace with a FLOAT */
`orderRefRMetric3`,
/* Replace with a FLOAT */
`orderRefRMetric4`,
/* Replace with a FLOAT */
`orderRefRMetric5`,
/* Replace with a FLOAT */
`orderRefRMetric6`,
/* Replace with a FLOAT */
`orderRefRMetric7`,
/* Replace with a FLOAT */
`expDayWtVegaOffset`,
/* Replace with a FLOAT */
`maxExpDayWtVegaLn`,
/* Replace with a FLOAT */
`maxExpDayWtVegaSh`,
/* Replace with a FLOAT */
`maxExpDayRMetric6Ln`,
/* Replace with a FLOAT */
`maxExpDayRMetric6Sh`,
/* Replace with a FLOAT */
`symDayDDeltaOffset`,
/* Replace with a FLOAT */
`maxSymDayDDeltaLn`,
/* Replace with a FLOAT */
`maxSymDayDDeltaSh`,
/* Replace with a FLOAT */
`symDayVegaOffset`,
/* Replace with a FLOAT */
`maxSymDayVegaLn`,
/* Replace with a FLOAT */
`maxSymDayVegaSh`,
/* Replace with a FLOAT */
`symDayWtVegaOffset`,
/* Replace with a FLOAT */
`maxSymDayWtVegaLn`,
/* Replace with a FLOAT */
`maxSymDayWtVegaSh`,
/* Replace with a FLOAT */
`maxSymDayRMetric7Ln`,
/* Replace with a FLOAT */
`maxSymDayRMetric7Sh`,
/* Replace with a FLOAT */
`maxGrpDayDDeltaLn`,
/* Replace with a FLOAT */
`maxGrpDayDDeltaSh`,
/* Replace with a FLOAT */
`maxGrpDayVegaLn`,
/* Replace with a FLOAT */
`maxGrpDayVegaSh`,
/* Replace with a FLOAT */
`maxGrpDayVegaAbs`,
/* Replace with a FLOAT */
`grpDayVegaRatio`,
/* Replace with a INT */
`maxGrpDayContractsLn`,
/* Replace with a INT */
`maxGrpDayContractsSh`,
/* Replace with a INT */
`maxGrpDayContractsAbs`,
/* Replace with a FLOAT */
`maxGrpDayRMetric1Ln`,
/* Replace with a FLOAT */
`maxGrpDayRMetric1Sh`,
/* Replace with a FLOAT */
`maxGrpDayRMetric1Abs`,
/* Replace with a FLOAT */
`grpDayRMetric1Ratio`,
/* Replace with a FLOAT */
`maxGrpDayRMetric2Ln`,
/* Replace with a FLOAT */
`maxGrpDayRMetric2Sh`,
/* Replace with a FLOAT */
`maxGrpDayRMetric3Ln`,
/* Replace with a FLOAT */
`maxGrpDayRMetric3Sh`,
/* Replace with a FLOAT */
`maxGrpDayRMetric4Ln`,
/* Replace with a FLOAT */
`maxGrpDayRMetric4Sh`,
/* Replace with a FLOAT */
`maxGrpDayRMetric5Ln`,
/* Replace with a FLOAT */
`maxGrpDayRMetric5Sh`,
/* Replace with a FLOAT */
`symEmaCxlDDeltaLn`,
/* Replace with a FLOAT */
`symEmaCxlDDeltaSh`,
/* Replace with a FLOAT */
`symEmaCxlWtVegaLn`,
/* Replace with a FLOAT */
`symEmaCxlWtVegaSh`,
/* Replace with a VARCHAR(32) */
`traderName`,
/* Replace with a TINYTEXT */
`userData1`,
/* Replace with a TINYTEXT */
`userData2`,
/* Replace with a TINYTEXT */
`childData`,
/* Replace with a TINYINT UNSIGNED */
`checksum`
)
VALUES(
'None',
'None',
'Example_ticker_tk',
'Example_accnt',
'Example_groupingCode',
'Buy',
'Example_clientFirm',
'Add',
'Example_altOrderId',
'Example_altAutoHedgeId',
'Example_altAccnt',
'Example_altUserName',
'Example_execBrkrCode',
'Example_strategy',
'2022-01-01 12:34:56.000000',
5,
5,
'No',
0,
5,
1,
'None',
'Yes',
'No',
'None',
1,
5,
'None',
'None',
'Default',
'EQT',
'NMS',
'Example_hedgeSecKey_tk',
123,
1,
1,
1.23,
'RiskGroup',
'RegMkt',
'None',
1.23,
1.23,
'Prc',
5,
'None',
'RegMkt',
'2022-01-01 12:34:56.000000',
5,
5,
'2022-01-01 12:34:56.000000',
'None',
'CobMaker',
'PostLimit',
'Market',
'Simple',
'Simple',
'None',
'None',
4.56,
4.56,
4.56,
1.23,
4.56,
'None',
'None',
1.23,
1.23,
1.23,
1.23,
'None',
'None',
'Auto',
5,
'Example_altStkLegID',
1,
'None',
'Equity',
5,
'None',
'None',
'Example_okey1_tk',
123,
1,
1,
4.56,
'Call',
123,
'Buy',
'Auto',
'Example_altLegID1',
'EQT',
'NMS',
'Example_okey2_tk',
123,
1,
1,
4.56,
'Call',
123,
'Buy',
'Auto',
'Example_altLegID2',
'EQT',
'NMS',
'Example_okey3_tk',
123,
1,
1,
4.56,
'Call',
123,
'Buy',
'Auto',
'Example_altLegID3',
'EQT',
'NMS',
'Example_okey4_tk',
123,
1,
1,
4.56,
'Call',
123,
'Buy',
'Auto',
'Example_altLegID4',
'EQT',
'NMS',
'Example_okey5_tk',
123,
1,
1,
4.56,
'Call',
123,
'Buy',
'Auto',
'Example_altLegID5',
'EQT',
'NMS',
'Example_okey6_tk',
123,
1,
1,
4.56,
'Call',
123,
'Buy',
'Auto',
'Example_altLegID6',
1.23,
1.23,
'Example_riskGroupId',
'None',
'None',
'None',
'None',
'None',
'None',
'None',
'None',
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
5,
5,
5,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
1.23,
'Example_traderName',
'dummy tiny text',
'dummy tiny text',
'dummy tiny text',
1
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRTrade`.`MsgMLegOrderGateway` 
WHERE
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */
`ticker_at` = 'None'
AND
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','NXOS','NXP','EUREX','CEDX','ICEFE') */
`ticker_ts` = 'None'
AND
/* Replace with a VARCHAR(12) */
`ticker_tk` = 'Example_ticker_tk'
AND
/* Replace with a VARCHAR(16) */
`accnt` = 'Example_accnt'
AND
/* Replace with a CHAR(19) */
`groupingCode` = 'Example_groupingCode'
AND
/* Replace with a ENUM('None','Buy','Sell') */
`orderSide` = 'Buy'
AND
/* Replace with a VARCHAR(16) */
`clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='MLegOrderGateway' ORDER BY ordinal_position ASC;