Skip to content

Instantly share code, notes, and snippets.

@yagop
Forked from jeremybeard/gist:97c067a68f1a3fbc88af
Created October 26, 2015 11:09
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save yagop/1cc54fe183f84345e958 to your computer and use it in GitHub Desktop.
CREATE VIEW fix_view AS
SELECT
tag[1] AS Account
, tag[2] AS AdvId
, tag[3] AS AdvRefID
, tag[4] AS AdvSide
, tag[5] AS AdvTransType
, tag[6] AS AvgPx
, tag[7] AS BeginSeqNo
, tag[8] AS BeginString
, tag[9] AS BodyLength
, tag[10] AS CheckSum
, tag[11] AS ClOrdID
, tag[12] AS Commission
, tag[13] AS CommType
, tag[14] AS CumQty
, tag[15] AS Currency
, tag[16] AS EndSeqNo
, tag[17] AS ExecID
, tag[18] AS ExecInst
, tag[19] AS ExecRefID
, tag[20] AS ExecTransType
, tag[21] AS HandlInst
, tag[22] AS SecurityIDSource
, tag[23] AS IOIID
, tag[25] AS IOIQltyInd
, tag[26] AS IOIRefID
, tag[27] AS IOIQty
, tag[28] AS IOITransType
, tag[29] AS LastCapacity
, tag[30] AS LastMkt
, tag[31] AS LastPx
, tag[32] AS LastQty
, tag[33] AS NoLinesOfText
, tag[34] AS MsgSeqNum
, tag[35] AS MsgType
, tag[36] AS NewSeqNo
, tag[37] AS OrderID
, tag[38] AS OrderQty
, tag[39] AS OrdStatus
, tag[40] AS OrdType
, tag[41] AS OrigClOrdID
, tag[42] AS OrigTime
, tag[43] AS PossDupFlag
, tag[44] AS Price
, tag[45] AS RefSeqNum
, tag[48] AS SecurityID
, tag[49] AS SenderCompID
, tag[50] AS SenderSubID
, tag[52] AS SendingTime
, tag[53] AS Quantity
, tag[54] AS Side
, tag[55] AS Symbol
, tag[56] AS TargetCompID
, tag[57] AS TargetSubID
, tag[58] AS Text
, tag[59] AS TimeInForce
, tag[60] AS TransactTime
, tag[61] AS Urgency
, tag[62] AS ValidUntilTime
, tag[63] AS SettlType
, tag[64] AS SettlDate
, tag[65] AS SymbolSfx
, tag[66] AS ListID
, tag[67] AS ListSeqNo
, tag[68] AS TotNoOrders
, tag[69] AS ListExecInst
, tag[70] AS AllocID
, tag[71] AS AllocTransType
, tag[72] AS RefAllocID
, tag[73] AS NoOrders
, tag[74] AS AvgPxPrecision
, tag[75] AS TradeDate
, tag[76] AS ExecBroker
, tag[77] AS PositionEffect
, tag[78] AS NoAllocs
, tag[79] AS AllocAccount
, tag[80] AS AllocQty
, tag[81] AS ProcessCode
, tag[82] AS NoRpts
, tag[83] AS RptSeq
, tag[84] AS CxlQty
, tag[85] AS NoDlvyInst
, tag[86] AS DlvyInst
, tag[87] AS AllocStatus
, tag[88] AS AllocRejCode
, tag[89] AS Signature
, tag[90] AS SecureDataLen
, tag[91] AS SecureData
, tag[92] AS BrokerOfCredit
, tag[93] AS SignatureLength
, tag[94] AS EmailType
, tag[95] AS RawDataLength
, tag[96] AS RawData
, tag[97] AS PossResend
, tag[98] AS EncryptMethod
, tag[99] AS StopPx
, tag[100] AS ExDestination
, tag[102] AS CxlRejReason
, tag[103] AS OrdRejReason
, tag[104] AS IOIQualifier
, tag[105] AS WaveNo
, tag[106] AS Issuer
, tag[107] AS SecurityDesc
, tag[108] AS HeartBtInt
, tag[109] AS ClientID
, tag[110] AS MinQty
, tag[111] AS MaxFloor
, tag[112] AS TestReqID
, tag[113] AS ReportToExch
, tag[114] AS LocateReqd
, tag[115] AS OnBehalfOfCompID
, tag[116] AS OnBehalfOfSubID
, tag[117] AS QuoteID
, tag[118] AS NetMoney
, tag[119] AS SettlCurrAmt
, tag[120] AS SettlCurrency
, tag[121] AS ForexReq
, tag[122] AS OrigSendingTime
, tag[123] AS GapFillFlag
, tag[124] AS NoExecs
, tag[125] AS CxlType
, tag[126] AS ExpireTime
, tag[127] AS DKReason
, tag[128] AS DeliverToCompID
, tag[129] AS DeliverToSubID
, tag[130] AS IOINaturalFlag
, tag[131] AS QuoteReqID
, tag[132] AS BidPx
, tag[133] AS OfferPx
, tag[134] AS BidSize
, tag[135] AS OfferSize
, tag[136] AS NoMiscFees
, tag[137] AS MiscFeeAmt
, tag[138] AS MiscFeeCurr
, tag[139] AS MiscFeeType
, tag[140] AS PrevClosePx
, tag[141] AS ResetSeqNumFlag
, tag[142] AS SenderLocationID
, tag[143] AS TargetLocationID
, tag[144] AS OnBehalfOfLocationID
, tag[145] AS DeliverToLocationID
, tag[146] AS NoRelatedSym
, tag[147] AS Subject
, tag[148] AS Headline
, tag[149] AS URLLink
, tag[150] AS ExecType
, tag[151] AS LeavesQty
, tag[152] AS CashOrderQty
, tag[153] AS AllocAvgPx
, tag[154] AS AllocNetMoney
, tag[155] AS SettlCurrFxRate
, tag[156] AS SettlCurrFxRateCalc
, tag[157] AS NumDaysInterest
, tag[158] AS AccruedInterestRate
, tag[159] AS AccruedInterestAmt
, tag[160] AS SettlInstMode
, tag[161] AS AllocText
, tag[162] AS SettlInstID
, tag[163] AS SettlInstTransType
, tag[164] AS EmailThreadID
, tag[165] AS SettlInstSource
, tag[166] AS SettlLocation
, tag[167] AS SecurityType
, tag[168] AS EffectiveTime
, tag[169] AS StandInstDbType
, tag[170] AS StandInstDbName
, tag[171] AS StandInstDbID
, tag[172] AS SettlDeliveryType
, tag[173] AS SettlDepositoryCode
, tag[174] AS SettlBrkrCode
, tag[175] AS SettlInstCode
, tag[176] AS SecuritySettlAgentName
, tag[177] AS SecuritySettlAgentCode
, tag[178] AS SecuritySettlAgentAcctNum
, tag[179] AS SecuritySettlAgentAcctName
, tag[180] AS SecuritySettlAgentContactName
, tag[181] AS SecuritySettlAgentContactPhone
, tag[182] AS CashSettlAgentName
, tag[183] AS CashSettlAgentCode
, tag[184] AS CashSettlAgentAcctNum
, tag[185] AS CashSettlAgentAcctName
, tag[186] AS CashSettlAgentContactName
, tag[187] AS CashSettlAgentContactPhone
, tag[188] AS BidSpotRate
, tag[189] AS BidForwardPoints
, tag[190] AS OfferSpotRate
, tag[191] AS OfferForwardPoints
, tag[192] AS OrderQty2
, tag[193] AS SettlDate2
, tag[194] AS LastSpotRate
, tag[195] AS LastForwardPoints
, tag[196] AS AllocLinkID
, tag[197] AS AllocLinkType
, tag[198] AS SecondaryOrderID
, tag[199] AS NoIOIQualifiers
, tag[200] AS MaturityMonthYear
, tag[201] AS PutOrCall
, tag[202] AS StrikePrice
, tag[203] AS CoveredOrUncovered
, tag[204] AS CustomerOrFirm
, tag[205] AS MaturityDay
, tag[206] AS OptAttribute
, tag[207] AS SecurityExchange
, tag[208] AS NotifyBrokerOfCredit
, tag[209] AS AllocHandlInst
, tag[210] AS MaxShow
, tag[211] AS PegOffsetValue
, tag[212] AS XmlDataLen
, tag[213] AS XmlData
, tag[214] AS SettlInstRefID
, tag[215] AS NoRoutingIDs
, tag[216] AS RoutingType
, tag[217] AS RoutingID
, tag[218] AS Spread
, tag[219] AS Benchmark
, tag[220] AS BenchmarkCurveCurrency
, tag[221] AS BenchmarkCurveName
, tag[222] AS BenchmarkCurvePoint
, tag[223] AS CouponRate
, tag[224] AS CouponPaymentDate
, tag[225] AS IssueDate
, tag[226] AS RepurchaseTerm
, tag[227] AS RepurchaseRate
, tag[228] AS Factor
, tag[229] AS TradeOriginationDate
, tag[230] AS ExDate
, tag[231] AS ContractMultiplier
, tag[232] AS NoStipulations
, tag[233] AS StipulationType
, tag[234] AS StipulationValue
, tag[235] AS YieldType
, tag[236] AS Yield
, tag[237] AS TotalTakedown
, tag[238] AS Concession
, tag[239] AS RepoCollateralSecurityType
, tag[240] AS RedemptionDate
, tag[241] AS UnderlyingCouponPaymentDate
, tag[242] AS UnderlyingIssueDate
, tag[243] AS UnderlyingRepoCollateralSecurityType
, tag[244] AS UnderlyingRepurchaseTerm
, tag[245] AS UnderlyingRepurchaseRate
, tag[246] AS UnderlyingFactor
, tag[247] AS UnderlyingRedemptionDate
, tag[248] AS LegCouponPaymentDate
, tag[249] AS LegIssueDate
, tag[250] AS LegRepoCollateralSecurityType
, tag[251] AS LegRepurchaseTerm
, tag[252] AS LegRepurchaseRate
, tag[253] AS LegFactor
, tag[254] AS LegRedemptionDate
, tag[255] AS CreditRating
, tag[256] AS UnderlyingCreditRating
, tag[257] AS LegCreditRating
, tag[258] AS TradedFlatSwitch
, tag[259] AS BasisFeatureDate
, tag[260] AS BasisFeaturePrice
, tag[262] AS MDReqID
, tag[263] AS SubscriptionRequestType
, tag[264] AS MarketDepth
, tag[265] AS MDUpdateType
, tag[266] AS AggregatedBook
, tag[267] AS NoMDEntryTypes
, tag[268] AS NoMDEntries
, tag[269] AS MDEntryType
, tag[270] AS MDEntryPx
, tag[271] AS MDEntrySize
, tag[272] AS MDEntryDate
, tag[273] AS MDEntryTime
, tag[274] AS TickDirection
, tag[275] AS MDMkt
, tag[276] AS QuoteCondition
, tag[277] AS TradeCondition
, tag[278] AS MDEntryID
, tag[279] AS MDUpdateAction
, tag[280] AS MDEntryRefID
, tag[281] AS MDReqRejReason
, tag[282] AS MDEntryOriginator
, tag[283] AS LocationID
, tag[284] AS DeskID
, tag[285] AS DeleteReason
, tag[286] AS OpenCloseSettlFlag
, tag[287] AS SellerDays
, tag[288] AS MDEntryBuyer
, tag[289] AS MDEntrySeller
, tag[290] AS MDEntryPositionNo
, tag[291] AS FinancialStatus
, tag[292] AS CorporateAction
, tag[293] AS DefBidSize
, tag[294] AS DefOfferSize
, tag[295] AS NoQuoteEntries
, tag[296] AS NoQuoteSets
, tag[297] AS QuoteStatus
, tag[298] AS QuoteCancelType
, tag[299] AS QuoteEntryID
, tag[300] AS QuoteRejectReason
, tag[301] AS QuoteResponseLevel
, tag[302] AS QuoteSetID
, tag[303] AS QuoteRequestType
, tag[304] AS TotNoQuoteEntries
, tag[305] AS UnderlyingSecurityIDSource
, tag[306] AS UnderlyingIssuer
, tag[307] AS UnderlyingSecurityDesc
, tag[308] AS UnderlyingSecurityExchange
, tag[309] AS UnderlyingSecurityID
, tag[310] AS UnderlyingSecurityType
, tag[311] AS UnderlyingSymbol
, tag[312] AS UnderlyingSymbolSfx
, tag[313] AS UnderlyingMaturityMonthYear
, tag[314] AS UnderlyingMaturityDay
, tag[315] AS UnderlyingPutOrCall
, tag[316] AS UnderlyingStrikePrice
, tag[317] AS UnderlyingOptAttribute
, tag[318] AS UnderlyingCurrency
, tag[319] AS RatioQty
, tag[320] AS SecurityReqID
, tag[321] AS SecurityRequestType
, tag[322] AS SecurityResponseID
, tag[323] AS SecurityResponseType
, tag[324] AS SecurityStatusReqID
, tag[325] AS UnsolicitedIndicator
, tag[326] AS SecurityTradingStatus
, tag[327] AS HaltReason
, tag[328] AS InViewOfCommon
, tag[329] AS DueToRelated
, tag[330] AS BuyVolume
, tag[331] AS SellVolume
, tag[332] AS HighPx
, tag[333] AS LowPx
, tag[334] AS Adjustment
, tag[335] AS TradSesReqID
, tag[336] AS TradingSessionID
, tag[337] AS ContraTrader
, tag[338] AS TradSesMethod
, tag[339] AS TradSesMode
, tag[340] AS TradSesStatus
, tag[341] AS TradSesStartTime
, tag[342] AS TradSesOpenTime
, tag[343] AS TradSesPreCloseTime
, tag[344] AS TradSesCloseTime
, tag[345] AS TradSesEndTime
, tag[346] AS NumberOfOrders
, tag[347] AS MessageEncoding
, tag[348] AS EncodedIssuerLen
, tag[349] AS EncodedIssuer
, tag[350] AS EncodedSecurityDescLen
, tag[351] AS EncodedSecurityDesc
, tag[352] AS EncodedListExecInstLen
, tag[353] AS EncodedListExecInst
, tag[354] AS EncodedTextLen
, tag[355] AS EncodedText
, tag[356] AS EncodedSubjectLen
, tag[357] AS EncodedSubject
, tag[358] AS EncodedHeadlineLen
, tag[359] AS EncodedHeadline
, tag[360] AS EncodedAllocTextLen
, tag[361] AS EncodedAllocText
, tag[362] AS EncodedUnderlyingIssuerLen
, tag[363] AS EncodedUnderlyingIssuer
, tag[364] AS EncodedUnderlyingSecurityDescLen
, tag[365] AS EncodedUnderlyingSecurityDesc
, tag[366] AS AllocPrice
, tag[367] AS QuoteSetValidUntilTime
, tag[368] AS QuoteEntryRejectReason
, tag[369] AS LastMsgSeqNumProcessed
, tag[370] AS OnBehalfOfSendingTime
, tag[371] AS RefTagID
, tag[372] AS RefMsgType
, tag[373] AS SessionRejectReason
, tag[374] AS BidRequestTransType
, tag[375] AS ContraBroker
, tag[376] AS ComplianceID
, tag[377] AS SolicitedFlag
, tag[378] AS ExecRestatementReason
, tag[379] AS BusinessRejectRefID
, tag[380] AS BusinessRejectReason
, tag[381] AS GrossTradeAmt
, tag[382] AS NoContraBrokers
, tag[383] AS MaxMessageSize
, tag[384] AS NoMsgTypes
, tag[385] AS MsgDirection
, tag[386] AS NoTradingSessions
, tag[387] AS TotalVolumeTraded
, tag[388] AS DiscretionInst
, tag[389] AS DiscretionOffsetValue
, tag[390] AS BidID
, tag[391] AS ClientBidID
, tag[392] AS ListName
, tag[393] AS TotNoRelatedSym
, tag[394] AS BidType
, tag[395] AS NumTickets
, tag[396] AS SideValue1
, tag[397] AS SideValue2
, tag[398] AS NoBidDescriptors
, tag[399] AS BidDescriptorType
, tag[400] AS BidDescriptor
, tag[401] AS SideValueInd
, tag[402] AS LiquidityPctLow
, tag[403] AS LiquidityPctHigh
, tag[404] AS LiquidityValue
, tag[405] AS EFPTrackingError
, tag[406] AS FairValue
, tag[407] AS OutsideIndexPct
, tag[408] AS ValueOfFutures
, tag[409] AS LiquidityIndType
, tag[410] AS WtAverageLiquidity
, tag[411] AS ExchangeForPhysical
, tag[412] AS OutMainCntryUIndex
, tag[413] AS CrossPercent
, tag[414] AS ProgRptReqs
, tag[415] AS ProgPeriodInterval
, tag[416] AS IncTaxInd
, tag[417] AS NumBidders
, tag[418] AS BidTradeType
, tag[419] AS BasisPxType
, tag[420] AS NoBidComponents
, tag[421] AS Country
, tag[422] AS TotNoStrikes
, tag[423] AS PriceType
, tag[424] AS DayOrderQty
, tag[425] AS DayCumQty
, tag[426] AS DayAvgPx
, tag[427] AS GTBookingInst
, tag[428] AS NoStrikes
, tag[429] AS ListStatusType
, tag[430] AS NetGrossInd
, tag[431] AS ListOrderStatus
, tag[432] AS ExpireDate
, tag[433] AS ListExecInstType
, tag[434] AS CxlRejResponseTo
, tag[435] AS UnderlyingCouponRate
, tag[436] AS UnderlyingContractMultiplier
, tag[437] AS ContraTradeQty
, tag[438] AS ContraTradeTime
, tag[439] AS ClearingFirm
, tag[440] AS ClearingAccount
, tag[441] AS LiquidityNumSecurities
, tag[442] AS MultiLegReportingType
, tag[443] AS StrikeTime
, tag[444] AS ListStatusText
, tag[445] AS EncodedListStatusTextLen
, tag[446] AS EncodedListStatusText
, tag[447] AS PartyIDSource
, tag[448] AS PartyID
, tag[449] AS TotalVolumeTradedDate
, tag[450] AS TotalVolumeTradedTime
, tag[451] AS NetChgPrevDay
, tag[452] AS PartyRole
, tag[453] AS NoPartyIDs
, tag[454] AS NoSecurityAltID
, tag[455] AS SecurityAltID
, tag[456] AS SecurityAltIDSource
, tag[457] AS NoUnderlyingSecurityAltID
, tag[458] AS UnderlyingSecurityAltID
, tag[459] AS UnderlyingSecurityAltIDSource
, tag[460] AS Product
, tag[461] AS CFICode
, tag[462] AS UnderlyingProduct
, tag[463] AS UnderlyingCFICode
, tag[464] AS TestMessageIndicator
, tag[465] AS QuantityType
, tag[466] AS BookingRefID
, tag[467] AS IndividualAllocID
, tag[468] AS RoundingDirection
, tag[469] AS RoundingModulus
, tag[470] AS CountryOfIssue
, tag[471] AS StateOrProvinceOfIssue
, tag[472] AS LocaleOfIssue
, tag[473] AS NoRegistDtls
, tag[474] AS MailingDtls
, tag[475] AS InvestorCountryOfResidence
, tag[476] AS PaymentRef
, tag[477] AS DistribPaymentMethod
, tag[478] AS CashDistribCurr
, tag[479] AS CommCurrency
, tag[480] AS CancellationRights
, tag[481] AS MoneyLaunderingStatus
, tag[482] AS MailingInst
, tag[483] AS TransBkdTime
, tag[484] AS ExecPriceType
, tag[485] AS ExecPriceAdjustment
, tag[486] AS DateOfBirth
, tag[487] AS TradeReportTransType
, tag[488] AS CardHolderName
, tag[489] AS CardNumber
, tag[490] AS CardExpDate
, tag[491] AS CardIssNum
, tag[492] AS PaymentMethod
, tag[493] AS RegistAcctType
, tag[494] AS Designation
, tag[495] AS TaxAdvantageType
, tag[496] AS RegistRejReasonText
, tag[497] AS FundRenewWaiv
, tag[498] AS CashDistribAgentName
, tag[499] AS CashDistribAgentCode
, tag[500] AS CashDistribAgentAcctNumber
, tag[501] AS CashDistribPayRef
, tag[502] AS CashDistribAgentAcctName
, tag[503] AS CardStartDate
, tag[504] AS PaymentDate
, tag[505] AS PaymentRemitterID
, tag[506] AS RegistStatus
, tag[507] AS RegistRejReasonCode
, tag[508] AS RegistRefID
, tag[509] AS RegistDtls
, tag[510] AS NoDistribInsts
, tag[511] AS RegistEmail
, tag[512] AS DistribPercentage
, tag[513] AS RegistID
, tag[514] AS RegistTransType
, tag[515] AS ExecValuationPoint
, tag[516] AS OrderPercent
, tag[517] AS OwnershipType
, tag[518] AS NoContAmts
, tag[519] AS ContAmtType
, tag[520] AS ContAmtValue
, tag[521] AS ContAmtCurr
, tag[522] AS OwnerType
, tag[523] AS PartySubID
, tag[524] AS NestedPartyID
, tag[525] AS NestedPartyIDSource
, tag[526] AS SecondaryClOrdID
, tag[527] AS SecondaryExecID
, tag[528] AS OrderCapacity
, tag[529] AS OrderRestrictions
, tag[530] AS MassCancelRequestType
, tag[531] AS MassCancelResponse
, tag[532] AS MassCancelRejectReason
, tag[533] AS TotalAffectedOrders
, tag[534] AS NoAffectedOrders
, tag[535] AS AffectedOrderID
, tag[536] AS AffectedSecondaryOrderID
, tag[537] AS QuoteType
, tag[538] AS NestedPartyRole
, tag[539] AS NoNestedPartyIDs
, tag[540] AS TotalAccruedInterestAmt
, tag[541] AS MaturityDate
, tag[542] AS UnderlyingMaturityDate
, tag[543] AS InstrRegistry
, tag[544] AS CashMargin
, tag[545] AS NestedPartySubID
, tag[546] AS Scope
, tag[547] AS MDImplicitDelete
, tag[548] AS CrossID
, tag[549] AS CrossType
, tag[550] AS CrossPrioritization
, tag[551] AS OrigCrossID
, tag[552] AS NoSides
, tag[553] AS Username
, tag[554] AS Password
, tag[555] AS NoLegs
, tag[556] AS LegCurrency
, tag[557] AS TotNoSecurityTypes
, tag[558] AS NoSecurityTypes
, tag[559] AS SecurityListRequestType
, tag[560] AS SecurityRequestResult
, tag[561] AS RoundLot
, tag[562] AS MinTradeVol
, tag[563] AS MultiLegRptTypeReq
, tag[564] AS LegPositionEffect
, tag[565] AS LegCoveredOrUncovered
, tag[566] AS LegPrice
, tag[567] AS TradSesStatusRejReason
, tag[568] AS TradeRequestID
, tag[569] AS TradeRequestType
, tag[570] AS PreviouslyReported
, tag[571] AS TradeReportID
, tag[572] AS TradeReportRefID
, tag[573] AS MatchStatus
, tag[574] AS MatchType
, tag[575] AS OddLot
, tag[576] AS NoClearingInstructions
, tag[577] AS ClearingInstruction
, tag[578] AS TradeInputSource
, tag[579] AS TradeInputDevice
, tag[580] AS NoDates
, tag[581] AS AccountType
, tag[582] AS CustOrderCapacity
, tag[583] AS ClOrdLinkID
, tag[584] AS MassStatusReqID
, tag[585] AS MassStatusReqType
, tag[586] AS OrigOrdModTime
, tag[587] AS LegSettlType
, tag[588] AS LegSettlDate
, tag[589] AS DayBookingInst
, tag[590] AS BookingUnit
, tag[591] AS PreallocMethod
, tag[592] AS UnderlyingCountryOfIssue
, tag[593] AS UnderlyingStateOrProvinceOfIssue
, tag[594] AS UnderlyingLocaleOfIssue
, tag[595] AS UnderlyingInstrRegistry
, tag[596] AS LegCountryOfIssue
, tag[597] AS LegStateOrProvinceOfIssue
, tag[598] AS LegLocaleOfIssue
, tag[599] AS LegInstrRegistry
, tag[600] AS LegSymbol
, tag[601] AS LegSymbolSfx
, tag[602] AS LegSecurityID
, tag[603] AS LegSecurityIDSource
, tag[604] AS NoLegSecurityAltID
, tag[605] AS LegSecurityAltID
, tag[606] AS LegSecurityAltIDSource
, tag[607] AS LegProduct
, tag[608] AS LegCFICode
, tag[609] AS LegSecurityType
, tag[610] AS LegMaturityMonthYear
, tag[611] AS LegMaturityDate
, tag[612] AS LegStrikePrice
, tag[613] AS LegOptAttribute
, tag[614] AS LegContractMultiplier
, tag[615] AS LegCouponRate
, tag[616] AS LegSecurityExchange
, tag[617] AS LegIssuer
, tag[618] AS EncodedLegIssuerLen
, tag[619] AS EncodedLegIssuer
, tag[620] AS LegSecurityDesc
, tag[621] AS EncodedLegSecurityDescLen
, tag[622] AS EncodedLegSecurityDesc
, tag[623] AS LegRatioQty
, tag[624] AS LegSide
, tag[625] AS TradingSessionSubID
, tag[626] AS AllocType
, tag[627] AS NoHops
, tag[628] AS HopCompID
, tag[629] AS HopSendingTime
, tag[630] AS HopRefID
, tag[631] AS MidPx
, tag[632] AS BidYield
, tag[633] AS MidYield
, tag[634] AS OfferYield
, tag[635] AS ClearingFeeIndicator
, tag[636] AS WorkingIndicator
, tag[637] AS LegLastPx
, tag[638] AS PriorityIndicator
, tag[639] AS PriceImprovement
, tag[640] AS Price2
, tag[641] AS LastForwardPoints2
, tag[642] AS BidForwardPoints2
, tag[643] AS OfferForwardPoints2
, tag[644] AS RFQReqID
, tag[645] AS MktBidPx
, tag[646] AS MktOfferPx
, tag[647] AS MinBidSize
, tag[648] AS MinOfferSize
, tag[649] AS QuoteStatusReqID
, tag[650] AS LegalConfirm
, tag[651] AS UnderlyingLastPx
, tag[652] AS UnderlyingLastQty
, tag[653] AS SecDefStatus
, tag[654] AS LegRefID
, tag[655] AS ContraLegRefID
, tag[656] AS SettlCurrBidFxRate
, tag[657] AS SettlCurrOfferFxRate
, tag[658] AS QuoteRequestRejectReason
, tag[659] AS SideComplianceID
, tag[660] AS AcctIDSource
, tag[661] AS AllocAcctIDSource
, tag[662] AS BenchmarkPrice
, tag[663] AS BenchmarkPriceType
, tag[664] AS ConfirmID
, tag[665] AS ConfirmStatus
, tag[666] AS ConfirmTransType
, tag[667] AS ContractSettlMonth
, tag[668] AS DeliveryForm
, tag[669] AS LastParPx
, tag[670] AS NoLegAllocs
, tag[671] AS LegAllocAccount
, tag[672] AS LegIndividualAllocID
, tag[673] AS LegAllocQty
, tag[674] AS LegAllocAcctIDSource
, tag[675] AS LegSettlCurrency
, tag[676] AS LegBenchmarkCurveCurrency
, tag[677] AS LegBenchmarkCurveName
, tag[678] AS LegBenchmarkCurvePoint
, tag[679] AS LegBenchmarkPrice
, tag[680] AS LegBenchmarkPriceType
, tag[681] AS LegBidPx
, tag[682] AS LegIOIQty
, tag[683] AS NoLegStipulations
, tag[684] AS LegOfferPx
, tag[685] AS LegOrderQty
, tag[686] AS LegPriceType
, tag[687] AS LegQty
, tag[688] AS LegStipulationType
, tag[689] AS LegStipulationValue
, tag[690] AS LegSwapType
, tag[691] AS Pool
, tag[692] AS QuotePriceType
, tag[693] AS QuoteRespID
, tag[694] AS QuoteRespType
, tag[695] AS QuoteQualifier
, tag[696] AS YieldRedemptionDate
, tag[697] AS YieldRedemptionPrice
, tag[698] AS YieldRedemptionPriceType
, tag[699] AS BenchmarkSecurityID
, tag[700] AS ReversalIndicator
, tag[701] AS YieldCalcDate
, tag[702] AS NoPositions
, tag[703] AS PosType
, tag[704] AS LongQty
, tag[705] AS ShortQty
, tag[706] AS PosQtyStatus
, tag[707] AS PosAmtType
, tag[708] AS PosAmt
, tag[709] AS PosTransType
, tag[710] AS PosReqID
, tag[711] AS NoUnderlyings
, tag[712] AS PosMaintAction
, tag[713] AS OrigPosReqRefID
, tag[714] AS PosMaintRptRefID
, tag[715] AS ClearingBusinessDate
, tag[716] AS SettlSessID
, tag[717] AS SettlSessSubID
, tag[718] AS AdjustmentType
, tag[719] AS ContraryInstructionIndicator
, tag[720] AS PriorSpreadIndicator
, tag[721] AS PosMaintRptID
, tag[722] AS PosMaintStatus
, tag[723] AS PosMaintResult
, tag[724] AS PosReqType
, tag[725] AS ResponseTransportType
, tag[726] AS ResponseDestination
, tag[727] AS TotalNumPosReports
, tag[728] AS PosReqResult
, tag[729] AS PosReqStatus
, tag[730] AS SettlPrice
, tag[731] AS SettlPriceType
, tag[732] AS UnderlyingSettlPrice
, tag[733] AS UnderlyingSettlPriceType
, tag[734] AS PriorSettlPrice
, tag[735] AS NoQuoteQualifiers
, tag[736] AS AllocSettlCurrency
, tag[737] AS AllocSettlCurrAmt
, tag[738] AS InterestAtMaturity
, tag[739] AS LegDatedDate
, tag[740] AS LegPool
, tag[741] AS AllocInterestAtMaturity
, tag[742] AS AllocAccruedInterestAmt
, tag[743] AS DeliveryDate
, tag[744] AS AssignmentMethod
, tag[745] AS AssignmentUnit
, tag[746] AS OpenInterest
, tag[747] AS ExerciseMethod
, tag[748] AS TotNumTradeReports
, tag[749] AS TradeRequestResult
, tag[750] AS TradeRequestStatus
, tag[751] AS TradeReportRejectReason
, tag[752] AS SideMultiLegReportingType
, tag[753] AS NoPosAmt
, tag[754] AS AutoAcceptIndicator
, tag[755] AS AllocReportID
, tag[756] AS NoNested2PartyIDs
, tag[757] AS Nested2PartyID
, tag[758] AS Nested2PartyIDSource
, tag[759] AS Nested2PartyRole
, tag[760] AS Nested2PartySubID
, tag[761] AS BenchmarkSecurityIDSource
, tag[762] AS SecuritySubType
, tag[763] AS UnderlyingSecuritySubType
, tag[764] AS LegSecuritySubType
, tag[765] AS AllowableOneSidednessPct
, tag[766] AS AllowableOneSidednessValue
, tag[767] AS AllowableOneSidednessCurr
, tag[768] AS NoTrdRegTimestamps
, tag[769] AS TrdRegTimestamp
, tag[770] AS TrdRegTimestampType
, tag[771] AS TrdRegTimestampOrigin
, tag[772] AS ConfirmRefID
, tag[773] AS ConfirmType
, tag[774] AS ConfirmRejReason
, tag[775] AS BookingType
, tag[776] AS IndividualAllocRejCode
, tag[777] AS SettlInstMsgID
, tag[778] AS NoSettlInst
, tag[779] AS LastUpdateTime
, tag[780] AS AllocSettlInstType
, tag[781] AS NoSettlPartyIDs
, tag[782] AS SettlPartyID
, tag[783] AS SettlPartyIDSource
, tag[784] AS SettlPartyRole
, tag[785] AS SettlPartySubID
, tag[786] AS SettlPartySubIDType
, tag[787] AS DlvyInstType
, tag[788] AS TerminationType
, tag[789] AS NextExpectedMsgSeqNum
, tag[790] AS OrdStatusReqID
, tag[791] AS SettlInstReqID
, tag[792] AS SettlInstReqRejCode
, tag[793] AS SecondaryAllocID
, tag[794] AS AllocReportType
, tag[795] AS AllocReportRefID
, tag[796] AS AllocCancReplaceReason
, tag[797] AS CopyMsgIndicator
, tag[798] AS AllocAccountType
, tag[799] AS OrderAvgPx
, tag[800] AS OrderBookingQty
, tag[801] AS NoSettlPartySubIDs
, tag[802] AS NoPartySubIDs
, tag[803] AS PartySubIDType
, tag[804] AS NoNestedPartySubIDs
, tag[805] AS NestedPartySubIDType
, tag[806] AS NoNested2PartySubIDs
, tag[807] AS Nested2PartySubIDType
, tag[808] AS AllocIntermedReqType
, tag[810] AS UnderlyingPx
, tag[811] AS PriceDelta
, tag[812] AS ApplQueueMax
, tag[813] AS ApplQueueDepth
, tag[814] AS ApplQueueResolution
, tag[815] AS ApplQueueAction
, tag[816] AS NoAltMDSource
, tag[817] AS AltMDSourceID
, tag[818] AS SecondaryTradeReportID
, tag[819] AS AvgPxIndicator
, tag[820] AS TradeLinkID
, tag[821] AS OrderInputDevice
, tag[822] AS UnderlyingTradingSessionID
, tag[823] AS UnderlyingTradingSessionSubID
, tag[824] AS TradeLegRefID
, tag[825] AS ExchangeRule
, tag[826] AS TradeAllocIndicator
, tag[827] AS ExpirationCycle
, tag[828] AS TrdType
, tag[829] AS TrdSubType
, tag[830] AS TransferReason
, tag[831] AS AsgnReqID
, tag[832] AS TotNumAssignmentReports
, tag[833] AS AsgnRptID
, tag[834] AS ThresholdAmount
, tag[835] AS PegMoveType
, tag[836] AS PegOffsetType
, tag[837] AS PegLimitType
, tag[838] AS PegRoundDirection
, tag[839] AS PeggedPrice
, tag[840] AS PegScope
, tag[841] AS DiscretionMoveType
, tag[842] AS DiscretionOffsetType
, tag[843] AS DiscretionLimitType
, tag[844] AS DiscretionRoundDirection
, tag[845] AS DiscretionPrice
, tag[846] AS DiscretionScope
, tag[847] AS TargetStrategy
, tag[848] AS TargetStrategyParameters
, tag[849] AS ParticipationRate
, tag[850] AS TargetStrategyPerformance
, tag[851] AS LastLiquidityInd
, tag[852] AS PublishTrdIndicator
, tag[853] AS ShortSaleReason
, tag[854] AS QtyType
, tag[855] AS SecondaryTrdType
, tag[856] AS TradeReportType
, tag[857] AS AllocNoOrdersType
, tag[858] AS SharedCommission
, tag[859] AS ConfirmReqID
, tag[860] AS AvgParPx
, tag[861] AS ReportedPx
, tag[862] AS NoCapacities
, tag[863] AS OrderCapacityQty
, tag[864] AS NoEvents
, tag[865] AS EventType
, tag[866] AS EventDate
, tag[867] AS EventPx
, tag[868] AS EventText
, tag[869] AS PctAtRisk
, tag[870] AS NoInstrAttrib
, tag[871] AS InstrAttribType
, tag[872] AS InstrAttribValue
, tag[873] AS DatedDate
, tag[874] AS InterestAccrualDate
, tag[875] AS CPProgram
, tag[876] AS CPRegType
, tag[877] AS UnderlyingCPProgram
, tag[878] AS UnderlyingCPRegType
, tag[879] AS UnderlyingQty
, tag[880] AS TrdMatchID
, tag[881] AS SecondaryTradeReportRefID
, tag[882] AS UnderlyingDirtyPrice
, tag[883] AS UnderlyingEndPrice
, tag[884] AS UnderlyingStartValue
, tag[885] AS UnderlyingCurrentValue
, tag[886] AS UnderlyingEndValue
, tag[887] AS NoUnderlyingStips
, tag[888] AS UnderlyingStipType
, tag[889] AS UnderlyingStipValue
, tag[890] AS MaturityNetMoney
, tag[891] AS MiscFeeBasis
, tag[892] AS TotNoAllocs
, tag[893] AS LastFragment
, tag[894] AS CollReqID
, tag[895] AS CollAsgnReason
, tag[896] AS CollInquiryQualifier
, tag[897] AS NoTrades
, tag[898] AS MarginRatio
, tag[899] AS MarginExcess
, tag[900] AS TotalNetValue
, tag[901] AS CashOutstanding
, tag[902] AS CollAsgnID
, tag[903] AS CollAsgnTransType
, tag[904] AS CollRespID
, tag[905] AS CollAsgnRespType
, tag[906] AS CollAsgnRejectReason
, tag[907] AS CollAsgnRefID
, tag[908] AS CollRptID
, tag[909] AS CollInquiryID
, tag[910] AS CollStatus
, tag[911] AS TotNumReports
, tag[912] AS LastRptRequested
, tag[913] AS AgreementDesc
, tag[914] AS AgreementID
, tag[915] AS AgreementDate
, tag[916] AS StartDate
, tag[917] AS EndDate
, tag[918] AS AgreementCurrency
, tag[919] AS DeliveryType
, tag[920] AS EndAccruedInterestAmt
, tag[921] AS StartCash
, tag[922] AS EndCash
, tag[923] AS UserRequestID
, tag[924] AS UserRequestType
, tag[925] AS NewPassword
, tag[926] AS UserStatus
, tag[927] AS UserStatusText
, tag[928] AS StatusValue
, tag[929] AS StatusText
, tag[930] AS RefCompID
, tag[931] AS RefSubID
, tag[932] AS NetworkResponseID
, tag[933] AS NetworkRequestID
, tag[934] AS LastNetworkResponseID
, tag[935] AS NetworkRequestType
, tag[936] AS NoCompIDs
, tag[937] AS NetworkStatusResponseType
, tag[938] AS NoCollInquiryQualifier
, tag[939] AS TrdRptStatus
, tag[940] AS AffirmStatus
, tag[941] AS UnderlyingStrikeCurrency
, tag[942] AS LegStrikeCurrency
, tag[943] AS TimeBracket
, tag[944] AS CollAction
, tag[945] AS CollInquiryStatus
, tag[946] AS CollInquiryResult
, tag[947] AS StrikeCurrency
, tag[948] AS NoNested3PartyIDs
, tag[949] AS Nested3PartyID
, tag[950] AS Nested3PartyIDSource
, tag[951] AS Nested3PartyRole
, tag[952] AS NoNested3PartySubIDs
, tag[953] AS Nested3PartySubID
, tag[954] AS Nested3PartySubIDType
, tag[955] AS LegContractSettlMonth
, tag[956] AS LegInterestAccrualDate
, tag[957] AS NoStrategyParameters
, tag[958] AS StrategyParameterName
, tag[959] AS StrategyParameterType
, tag[960] AS StrategyParameterValue
, tag[961] AS HostCrossID
, tag[962] AS SideTimeInForce
, tag[963] AS MDReportID
, tag[964] AS SecurityReportID
, tag[965] AS SecurityStatus
, tag[966] AS SettleOnOpenFlag
, tag[967] AS StrikeMultiplier
, tag[968] AS StrikeValue
, tag[969] AS MinPriceIncrement
, tag[970] AS PositionLimit
, tag[971] AS NTPositionLimit
, tag[972] AS UnderlyingAllocationPercent
, tag[973] AS UnderlyingCashAmount
, tag[974] AS UnderlyingCashType
, tag[975] AS UnderlyingSettlementType
, tag[976] AS QuantityDate
, tag[977] AS ContIntRptID
, tag[978] AS LateIndicator
, tag[979] AS InputSource
, tag[980] AS SecurityUpdateAction
, tag[981] AS NoExpiration
, tag[982] AS ExpType
, tag[983] AS ExpQty
, tag[984] AS NoUnderlyingAmounts
, tag[985] AS UnderlyingPayAmount
, tag[986] AS UnderlyingCollectAmount
, tag[987] AS UnderlyingSettlementDate
, tag[988] AS UnderlyingSettlementStatus
, tag[989] AS SecondaryIndividualAllocID
, tag[990] AS LegReportID
, tag[991] AS RndPx
, tag[992] AS IndividualAllocType
, tag[993] AS AllocCustomerCapacity
, tag[994] AS TierCode
, tag[996] AS UnitofMeasure
, tag[997] AS TimeUnit
, tag[998] AS UnderlyingUnitofMeasure
, tag[999] AS LegUnitofMeasure
, tag[1000] AS UnderlyingTimeUnit
, tag[1001] AS LegTimeUnit
, tag[1002] AS AllocMethod
, tag[1003] AS TradeID
, tag[1005] AS SideTradeReportID
, tag[1006] AS SideFillStationCd
, tag[1007] AS SideReasonCd
, tag[1008] AS SideTrdSubTyp
, tag[1009] AS SideQty
, tag[1011] AS MessageEventSource
, tag[1012] AS SideTrdRegTimestamp
, tag[1013] AS SideTrdRegTimestampType
, tag[1014] AS SideTrdRegTimestampSrc
, tag[1015] AS AsOfIndicator
, tag[1016] AS NoSideTrdRegTS
, tag[1017] AS LegOptionRatio
, tag[1018] AS NoInstrumentParties
, tag[1019] AS InstrumentPartyID
, tag[1020] AS TradeVolume
, tag[1021] AS MDBookType
, tag[1022] AS MDFeedType
, tag[1023] AS MDPriceLevel
, tag[1024] AS MDOriginType
, tag[1025] AS FirstPx
, tag[1026] AS MDEntrySpotRate
, tag[1027] AS MDEntryForwardPoints
, tag[1028] AS ManualOrderIndicator
, tag[1029] AS CustDirectedOrder
, tag[1030] AS ReceivedDeptID
, tag[1031] AS CustOrderHandlingInst
, tag[1032] AS OrderHandlingInstSource
, tag[1033] AS DeskType
, tag[1034] AS DeskTypeSource
, tag[1035] AS DeskOrderHandlingInst
, tag[1036] AS ExecAckStatus
, tag[1037] AS UnderlyingDeliveryAmount
, tag[1038] AS UnderlyingCapValue
, tag[1039] AS UnderlyingSettlMethod
, tag[1040] AS SecondaryTradeID
, tag[1041] AS FirmTradeID
, tag[1042] AS SecondaryFirmTradeID
, tag[1043] AS CollApplType
, tag[1044] AS UnderlyingAdjustedQuantity
, tag[1045] AS UnderlyingFXRate
, tag[1046] AS UnderlyingFXRateCalc
, tag[1047] AS AllocPositionEffect
, tag[1048] AS DealingCapacity
, tag[1049] AS InstrmtAssignmentMethod
, tag[1050] AS InstrumentPartyIDSource
, tag[1051] AS InstrumentPartyRole
, tag[1052] AS NoInstrumentPartySubIDs
, tag[1053] AS InstrumentPartySubID
, tag[1054] AS InstrumentPartySubIDType
, tag[1055] AS PositionCurrency
, tag[1056] AS CalculatedCcyLastQty
, tag[1057] AS AggressorIndicator
, tag[1058] AS NoUndlyInstrumentParties
, tag[1059] AS UndlyInstrumentPartyID
, tag[1060] AS UndlyInstrumentPartyIDSource
, tag[1061] AS UndlyInstrumentPartyRole
, tag[1062] AS NoUndlyInstrumentPartySubIDs
, tag[1063] AS UndlyInstrumentPartySubID
, tag[1064] AS UndlyInstrumentPartySubIDType
, tag[1065] AS BidSwapPoints
, tag[1066] AS OfferSwapPoints
, tag[1067] AS LegBidForwardPoints
, tag[1068] AS LegOfferForwardPoints
, tag[1069] AS SwapPoints
, tag[1070] AS MDQuoteType
, tag[1071] AS LastSwapPoints
, tag[1072] AS SideGrossTradeAmt
, tag[1073] AS LegLastForwardPoints
, tag[1074] AS LegCalculatedCcyLastQty
, tag[1075] AS LegGrossTradeAmt
, tag[1079] AS MaturityTime
, tag[1080] AS RefOrderID
, tag[1081] AS RefOrderIDSource
, tag[1082] AS SecondaryDisplayQty
, tag[1083] AS DisplayWhen
, tag[1084] AS DisplayMethod
, tag[1085] AS DisplayLowQty
, tag[1086] AS DisplayHighQty
, tag[1087] AS DisplayMinIncr
, tag[1088] AS RefreshQty
, tag[1089] AS MatchIncrement
, tag[1090] AS MaxPriceLevels
, tag[1091] AS PreTradeAnonymity
, tag[1092] AS PriceProtectionScope
, tag[1093] AS LotType
, tag[1094] AS PegPriceType
, tag[1095] AS PeggedRefPrice
, tag[1096] AS PegSecurityIDSource
, tag[1097] AS PegSecurityID
, tag[1098] AS PegSymbol
, tag[1099] AS PegSecurityDesc
, tag[1100] AS TriggerType
, tag[1101] AS TriggerAction
, tag[1102] AS TriggerPrice
, tag[1103] AS TriggerSymbol
, tag[1104] AS TriggerSecurityID
, tag[1105] AS TriggerSecurityIDSource
, tag[1106] AS TriggerSecurityDesc
, tag[1107] AS TriggerPriceType
, tag[1108] AS TriggerPriceTypeScope
, tag[1109] AS TriggerPriceDirection
, tag[1110] AS TriggerNewPrice
, tag[1111] AS TriggerOrderType
, tag[1112] AS TriggerNewQty
, tag[1113] AS TriggerTradingSessionID
, tag[1114] AS TriggerTradingSessionSubID
, tag[1115] AS OrderCategory
, tag[1116] AS NoRootPartyIDs
, tag[1117] AS RootPartyID
, tag[1118] AS RootPartyIDSource
, tag[1119] AS RootPartyRole
, tag[1120] AS NoRootPartySubIDs
, tag[1121] AS RootPartySubID
, tag[1122] AS RootPartySubIDType
, tag[1123] AS TradeHandlingInstr
, tag[1124] AS OrigTradeHandlingInstr
, tag[1125] AS OrigTradeDate
, tag[1126] AS OrigTradeID
, tag[1127] AS OrigSecondaryTradeID
, tag[1128] AS ApplVerID
, tag[1129] AS CstmApplVerID
, tag[1130] AS RefApplVerID
, tag[1131] AS RefCstmApplVerID
, tag[1132] AS TZTransactTime
, tag[1133] AS ExDestinationIDSource
, tag[1134] AS ReportedPxDiff
, tag[1135] AS RptSys
, tag[1136] AS AllocClearingFeeIndicator
, tag[1137] AS DefaultApplVerID
, tag[1138] AS DisplayQty
, tag[1139] AS ExchangeSpecialInstructions
FROM fix_map;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment