Warehouse Trade - UPSERT Mode, Insert Data Example
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Owned by Natalie Gesin (Deactivated)
<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" eaglemlVersion="2-0" eaglemlType="WarehouseTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="WarehouseTransactionMessage">
<warehouseTransaction>
<header>
<objectType>WarehouseTrade</objectType>
</header>
<warehouseTrade>
<objectType>WarehouseTrade</objectType>
<objectId>WarehouseTrade</objectId>
<sourceName>EAGLE PACE</sourceName>
<updateSource>MCADMIN</updateSource>
<effectiveDate>2015-03-08</effectiveDate>
<xrefAccountId>A1Q2W3R4U5K</xrefAccountId>
<xrefAccountIdType>A1Q</xrefAccountIdType>
<xrefClassCode>TF4</xrefClassCode>
<accountingBasis>GAAP</accountingBasis>
<primaryAssetId>CUSIP1A2B3CU</primaryAssetId>
<primaryAssetType>CUSIP</primaryAssetType>
<cusip>CUSIP1A2B3CU</cusip>
<isin>ISIN1A2B3CU</isin>
<sicovmId>SICOVMID1A2B3CU</sicovmId>
<assetResolutionOption>MATCH_ALL</assetResolutionOption>
<battingOrder>cusip,isin,sicovmId</battingOrder>
<brokerCode>EAGLE</brokerCode>
<clearingBrokerCode>EAGLE</clearingBrokerCode>
<status>STATUS</status>
<taxAmountLocal>892.561</taxAmountLocal>
<commissionAmount>905.482</commissionAmount>
<accruedInterest>246.766</accruedInterest>
<baseCurrency>USD</baseCurrency>
<monthEndAccountingDate>2015-02-18</monthEndAccountingDate>
<accruedInterestType>CUM</accruedInterestType>
<accruedIncomeLocal>885.587</accruedIncomeLocal>
<cancelAccountingDt>2015-02-18</cancelAccountingDt>
<cancelMthendAccountingDt>2015-02-18</cancelMthendAccountingDt>
<cancelFlag>N</cancelFlag>
<cancelStatus>A</cancelStatus>
<cancelEffectiveDt>2015-02-18</cancelEffectiveDt>
<cancelEventId>TSR80A</cancelEventId>
<cancelLinkEventId>TSR80A</cancelLinkEventId>
<currBuiltInGlSecurity>663.806</currBuiltInGlSecurity>
<currBuiltInGlCurrency>515.099</currBuiltInGlCurrency>
<currBuiltInGlDeferred>605.849</currBuiltInGlDeferred>
<currBuiltInGlOid>463.521</currBuiltInGlOid>
<currBuiltInGlMktDisc>208.855</currBuiltInGlMktDisc>
<gainCurrency>537.996</gainCurrency>
<gainSecurityLocal>193.128</gainSecurityLocal>
<totalGain>893.57</totalGain>
<fromAccount>ENTST001</fromAccount>
<fromAssetid>24126749</fromAssetid>
<fromLongShort>Y</fromLongShort>
<fromSourceSystem>Y</fromSourceSystem>
<fromCostBasisType>C</fromCostBasisType>
<fromWashSaleEligInd>N</fromWashSaleEligInd>
<lossCurrency>185.284</lossCurrency>
<lossSecurityLocal>768.24</lossSecurityLocal>
<totalLoss>595.553</totalLoss>
<originalAcquisitionCostBase>818.366</originalAcquisitionCostBase>
<originalAcquisitionCostLocal>998.717</originalAcquisitionCostLocal>
<originalFaceValue>785.64</originalFaceValue>
<originalBuiltInGlMktDisc>593.93</originalBuiltInGlMktDisc>
<originalTradePrice>742.018</originalTradePrice>
<originalBuiltInGlCurrency>787.477</originalBuiltInGlCurrency>
<originalBuiltInGlDeferred>486.493</originalBuiltInGlDeferred>
<originalBuiltInGlOid>647.502</originalBuiltInGlOid>
<originalBuiltInGlSecurity>934.244</originalBuiltInGlSecurity>
<originalSettlementDate>2015-02-18</originalSettlementDate>
<originalQuantity>734.445</originalQuantity>
<openCostBase>589.178</openCostBase>
<openHldPerDate>2015-02-18</openHldPerDate>
<performanceFlow>879.44</performanceFlow>
<performancePrice>481.915</performancePrice>
<premiumLAllocated>388.732</premiumLAllocated>
<premiumBAllocated>515.709</premiumBAllocated>
<settlementAmount>628.796</settlementAmount>
<toAccount>ENTST002</toAccount>
<toAssetid>24126750</toAssetid>
<toLongShort>N</toLongShort>
<toSourceSystem>N</toSourceSystem>
<toCostBasisType>P</toCostBasisType>
<toCashEventType>N</toCashEventType>
<toWashSaleEligInd>Y</toWashSaleEligInd>
<userChar1>USER_CHAR1</userChar1>
<userChar2>USER_CHAR2</userChar2>
<userChar3>USER_CHAR3</userChar3>
<userDefinedFloat1>292.604</userDefinedFloat1>
<userDefinedFloat2>923.46</userDefinedFloat2>
<userDefinedFloat3>637.912</userDefinedFloat3>
<costMethod>A</costMethod>
<lotSelectionMethod>FIFO</lotSelectionMethod>
<transactionCode>BUY</transactionCode>
<factor>663.219</factor>
<netAmountLocal>839.853</netAmountLocal>
<netAmountBase>720.808</netAmountBase>
<principalB>260.116</principalB>
<quantityPre>925.137</quantityPre>
<tradeYield>403.015</tradeYield>
<dirtyPrincipalLocal>755.67</dirtyPrincipalLocal>
<dirtyPrincipalBase>657.47</dirtyPrincipalBase>
<estimateVsFinal>FIN</estimateVsFinal>
<reportingReplayInd>N</reportingReplayInd>
<cashEventType>RECPT</cashEventType>
<transactionNotes>BUY</transactionNotes>
<partflag>Y</partflag>
<scrubType>A</scrubType>
<glAccount>GL_ACCOUNT</glAccount>
<custodianBankCode>CODE</custodianBankCode>
<custodyBankAccountNum>ACCOUNT</custodyBankAccountNum>
<custodyBankSubAccount>SUB_ACCT</custodyBankSubAccount>
<corporateActionType>EXCHANGE OFFER</corporateActionType>
<cashEventSpawned>Y</cashEventSpawned>
<bankAlias>242756</bankAlias>
<changedflag>C</changedflag>
<eventId>TSTR7986G</eventId>
<corporateActionInstance>108366</corporateActionInstance>
<sellToBuyFXRate>784.373</sellToBuyFXRate>
<lotNumber>LOTN</lotNumber>
<masterTicketNumber>A4F68JGE54GN</masterTicketNumber>
<acqTransNumber>397099</acqTransNumber>
<postType>TYPE</postType>
<tradeMemo1>TRADE_MEMO1</tradeMemo1>
<tradeMemo2>TRADE_MEMO2</tradeMemo2>
<fxRate>214.05</fxRate>
<checkedDate>2015-02-18</checkedDate>
<instructedDate>2015-02-25T06:02:47</instructedDate>
<dispInterestReceived>124.951</dispInterestReceived>
<userWhoApprovedTrade>USER</userWhoApprovedTrade>
<prepaySpeed>719.425</prepaySpeed>
<settlementExchangeRate>246.113</settlementExchangeRate>
<touchCount>642886</touchCount>
<authorizedDate>2015-02-25T06:02:47</authorizedDate>
<localCommissionAmount>784.026</localCommissionAmount>
<salesPerson>SALES_PERSON</salesPerson>
<broker>BROKER</broker>
<settlementCurrency>USD</settlementCurrency>
<discountRate>859.935</discountRate>
<comments1>COMMENTS1</comments1>
<price>429.023</price>
<principal>438.916</principal>
<comments>COMMENTS</comments>
<prepared>PREPARED</prepared>
<preparedDate>2015-02-25T06:02:47</preparedDate>
<settlementLocation>LOCATION</settlementLocation>
<trader>TRADER</trader>
<yield>268.127</yield>
<fromQuantity>825.597</fromQuantity>
<sellToBaseFxRate>113.427</sellToBaseFxRate>
<toQuantity>549.864</toQuantity>
<toAmountLocal>804.93</toAmountLocal>
<toCashType>CASH_TYPE</toCashType>
<fromAmountLocal>971.145</fromAmountLocal>
<fromCashType>CASH_TYPE</fromCashType>
<settlementInstructions1>SETTLEMENT_INSTRUCTIONS1</settlementInstructions1>
<settlementInstructions2>SETTLEMENT_INSTRUCTIONS2</settlementInstructions2>
<settlementInstructions3>SETTLEMENT_INSTRUCTIONS3</settlementInstructions3>
<settlementInstructions4>SETTLEMENT_INSTRUCTIONS4</settlementInstructions4>
<strategy>STRATEGY</strategy>
<settlementDate>2015-02-18</settlementDate>
<tradeExchangeRate>412.665</tradeExchangeRate>
<postDate>2015-02-18</postDate>
<custodianBankDesc>CUSTODIAN_BANK_DESC</custodianBankDesc>
<openCostLocal>323.91</openCostLocal>
<tradeAmount>792.136</tradeAmount>
<smInactiveFlag>N</smInactiveFlag>
<clientId>TSTR210A</clientId>
<covFlag>N</covFlag>
<eventSubPriority>800009</eventSubPriority>
<ioIssuerAlias>IO_ISSUER_ALIAS</ioIssuerAlias>
<ioIssuerId>TSTR820A</ioIssuerId>
<origAcctDate>2015-02-18</origAcctDate>
<origMonthlyAcctDate>2015-02-18</origMonthlyAcctDate>
<pendingTradeId>841918</pendingTradeId>
<qtyWashSaleEligible>890.105</qtyWashSaleEligible>
<washSaleEligibleInd>N</washSaleEligibleInd>
<aiaNetB>336.63</aiaNetB>
<aiaNetL>329.022</aiaNetL>
<buySellFlag>BUY</buySellFlag>
<bookValue>800.295</bookValue>
<bookValueLocal>134.357</bookValueLocal>
<cpNetB>337.575</cpNetB>
<cpNetL>539.859</cpNetL>
<creditLossB>147.784</creditLossB>
<creditLossL>701.405</creditLossL>
<costBasisType>F</costBasisType>
<futureFeeNetB>118.93</futureFeeNetB>
<futureFeeNetL>221.959</futureFeeNetL>
<impairmentLtdBase>429.515</impairmentLtdBase>
<impairmentLtdLocal>423.229</impairmentLtdLocal>
<mbaNetB>547.444</mbaNetB>
<mbaNetL>700.545</mbaNetL>
<naiaNetB>649.861</naiaNetB>
<naiaNetL>657.304</naiaNetL>
<nonCreditLossB>381.697</nonCreditLossB>
<nonCreditLossL>187.558</nonCreditLossL>
<bookCost>795.18</bookCost>
<cashCategory>CASH_CATEGORY</cashCategory>
<cancelType>C</cancelType>
<exchangeFeeBase>430.715</exchangeFeeBase>
<federalTaxWithholdBase>179.171</federalTaxWithholdBase>
<mttype>MTCLOSE</mttype>
<netCash>144.692</netCash>
<origAcqDate>2015-02-18</origAcqDate>
<positionId>536730</positionId>
<scrubId>903071</scrubId>
<secFeesBase>340.802</secFeesBase>
<termLoanFeeExpB>880.006</termLoanFeeExpB>
<termLoanFeeExpL>239.702</termLoanFeeExpL>
<termLoanFeeIncB>483.79</termLoanFeeIncB>
<termLoanFeeIncL>594.268</termLoanFeeIncL>
<targetEventId>TSTR821A</targetEventId>
<updateUserId>TSTR8210A</updateUserId>
<accruedInterestOverride>ACCRUED_INTEREST_OVR</accruedInterestOverride>
<acquisitionType>C</acquisitionType>
<amortizedCostPrevBase>250.703</amortizedCostPrevBase>
<amortizedCostPrevLocal>206.852</amortizedCostPrevLocal>
<alluprate>168.707</alluprate>
<asOfTradeTime>AS_OF_TRADE_TIME</asOfTradeTime>
<authorized>AUTHORIZED</authorized>
<autoexTradeFlag>FLAG</autoexTradeFlag>
<baseCommissionAmount>372.662</baseCommissionAmount>
<batchInstance>405902</batchInstance>
<balance>734.073</balance>
<bnchYld1>150.879</bnchYld1>
<bnchYld2>955.763</bnchYld2>
<bloombergProduct>PRODUCT</bloombergProduct>
<buyToBaseFxRate>305.344</buyToBaseFxRate>
<calcYieldIntIndicator>143323</calcYieldIntIndicator>
<cancelDueToCorrection>CANC</cancelDueToCorrection>
<cashflowdate>2015-02-18</cashflowdate>
<checked>CHECKED</checked>
<clearingBroker>CLEARING_BROKER</clearingBroker>
<closeoutpl0>100.526</closeoutpl0>
<closeoutpl1>334.342</closeoutpl1>
<commentType>TYPE</commentType>
<compared>COMPARED</compared>
<compareddate>2015-02-18</compareddate>
<costPrevBase>388.004</costPrevBase>
<costPrevLocal>179.697</costPrevLocal>
<cleanPrice>245.801</cleanPrice>
<commissionCode>CODE</commissionCode>
<commissionReasonCode>REASON</commissionReasonCode>
<commissionTypeCode>NO</commissionTypeCode>
<customerAcctNumb>CUSTOMER_ACCT_NUMB</customerAcctNumb>
<dispBookValueGaap>240.85</dispBookValueGaap>
<dispBookValueStat>596.497</dispBookValueStat>
<disallowGainB>680.534</disallowGainB>
<disallowGainL>957.888</disallowGainL>
<disallowLossB>751.265</disallowLossB>
<disallowLossL>474.507</disallowLossL>
<dispAccruedIncome>197.591</dispAccruedIncome>
<electedShareAmt>149.022</electedShareAmt>
<electedSharePerc>968.775</electedSharePerc>
<exchangeCodeTrd>CODE_TRD</exchangeCodeTrd>
<exchangeCurrency>USD</exchangeCurrency>
<exchangeTypeCode>TYPE_COD</exchangeTypeCode>
<exchangeCode>CODE</exchangeCode>
<exchangeFee>285.617</exchangeFee>
<fairMarketValueBase>598.319</fairMarketValueBase>
<fairMarketValueFlag>N</fairMarketValueFlag>
<fairMarketValueLocal>830.836</fairMarketValueLocal>
<fairMarketValuePrice>421.428</fairMarketValuePrice>
<feeamt>749.022</feeamt>
<feerate>851.654</feerate>
<fromEffectiveDate>2015-02-18</fromEffectiveDate>
<fwdCleanPrice>404.101</fwdCleanPrice>
<gaapRealizedGl>935.651</gaapRealizedGl>
<gaapSecType>TYP</gaapSecType>
<goodMillionNum>710003</goodMillionNum>
<haircutFlag>Y</haircutFlag>
<haircutPct>669.725</haircutPct>
<holdTradeStatus>A</holdTradeStatus>
<identifier2>IDENTIFIER2</identifier2>
<impairmentAmortOffsetB>352.868</impairmentAmortOffsetB>
<impairmentAmortOffsetL>579.734</impairmentAmortOffsetL>
<impairmentCostOffsetB>789.035</impairmentCostOffsetB>
<impairmentCostOffsetL>513.376</impairmentCostOffsetL>
<impairmentCostPrevB>537.023</impairmentCostPrevB>
<impairmentCostPrevL>789.561</impairmentCostPrevL>
<inceptionamt>747.719</inceptionamt>
<instructed>INSTRUCTED</instructed>
<interest>825.027</interest>
<invertFlag>N</invertFlag>
<interestadj>783.224</interestadj>
<interestAdjBase>807.486</interestAdjBase>
<ledgerEffectiveDate>2015-02-18</ledgerEffectiveDate>
<ledgerDate>2015-02-18</ledgerDate>
<letterconfirm>LETTERCONF</letterconfirm>
<lettered>LETTERED</lettered>
<lettereddate>2015-02-18</lettereddate>
<lmtGlElg>N</lmtGlElg>
<lmtGlInd>N</lmtGlInd>
<margin>171.691</margin>
<marginpoints>838.041</marginpoints>
<mortgageFlag>Y</mortgageFlag>
<muniFlag>Y</muniFlag>
<netsettleamt>403.984</netsettleamt>
<navId>795930</navId>
<numberOfAccuredDays>969.215</numberOfAccuredDays>
<netCashLocal>140.699</netCashLocal>
<notionalamt>807.487</notionalamt>
<notionalflag>N</notionalflag>
<otherFee>118.238</otherFee>
<origTranNum>ORIG_TRAN_NUM</origTranNum>
<ownershipTransferDate>2015-02-18</ownershipTransferDate>
<oidYield>923.44</oidYield>
<otherFeeBase>993.105</otherFeeBase>
<paceTradeEventId>TS210</paceTradeEventId>
<positionIdTrd>279546</positionIdTrd>
<productSubType>SUB_TYPE</productSubType>
<poolNumber>POOL_NUMBER</poolNumber>
<priceCurrency>USD</priceCurrency>
<principalFactor>605.933</principalFactor>
<realizedGlBase>632.601</realizedGlBase>
<realizedGlCrB>215.198</realizedGlCrB>
<realizedGlCrL>807.922</realizedGlCrL>
<realizedGlLocal>256.571</realizedGlLocal>
<realizedGlNcrB>698.889</realizedGlNcrB>
<realizedGlNcrL>974.756</realizedGlNcrL>
<recdPayAcct1>RECD_PAY_ACCT1</recdPayAcct1>
<recdPayAcct2>RECD_PAY_ACCT2</recdPayAcct2>
<recdPayEventType>RECD_PAY_EVENT_TYPE</recdPayEventType>
<recdPayPostingPlanType>RECD_PAY_POSTING_PLAN_TYPE</recdPayPostingPlanType>
<refrate>736.305</refrate>
<repoRate>487.926</repoRate>
<retailFeed>RETAIL_FEED</retailFeed>
<salesPersonLogin>SALES_PERSON_LOGIN</salesPersonLogin>
<secidType>SECID_TYPE</secidType>
<sequencedate>2015-02-18</sequencedate>
<settleamt0>488.133</settleamt0>
<settleamt1>273.329</settleamt1>
<settled>SETTLED</settled>
<settleAmtAtMaturity>191.454</settleAmtAtMaturity>
<settlementMethod>METHOD</settlementMethod>
<shortTermId>998357</shortTermId>
<sourceSystem>S</sourceSystem>
<systemTradeTime>SYSTEM_TRADE_TIME</systemTradeTime>
<sentTradeStatus>A</sentTradeStatus>
<starTag151>STAR_TAG151</starTag151>
<starTag182>STAR_TAG182</starTag182>
<stateTaxWithholdBase>874.679</stateTaxWithholdBase>
<starLsInd>L</starLsInd>
<targetPurchaseDate>2015-02-18</targetPurchaseDate>
<targetPurchasePrice>984.014</targetPurchasePrice>
<targetTradeTicketNumber>NUMBER</targetTradeTicketNumber>
<taxesBase>626.687</taxesBase>
<timeOfTrade>261.29</timeOfTrade>
<toFxRate>650.206</toFxRate>
<toLocalCommissionAmt>422.618</toLocalCommissionAmt>
<toSettleToBaseFxRate>144.472</toSettleToBaseFxRate>
<toSettlementCurrency>EUR</toSettlementCurrency>
<transactionId>TSTR8210A</transactionId>
<turnaroundIndicator>N</turnaroundIndicator>
<totalGainLocal>162.71</totalGainLocal>
<totalAmortLocal>528.312</totalAmortLocal>
<totalAmortBase>137.178</totalAmortBase>
<totalLossLocal>593.233</totalLossLocal>
<tdUserChar1>TD_USER1</tdUserChar1>
<tdUserChar2>TD_USER_CHAR2</tdUserChar2>
<tdUserDate1>2015-02-18</tdUserDate1>
<tdUserDate2>2015-02-18</tdUserDate2>
<tdUserInt1>279644</tdUserInt1>
<tdUserInt2>702491</tdUserInt2>
<tdUserInt3>801944</tdUserInt3>
<tdUserInt4>882783</tdUserInt4>
<tdUserInt5>313103</tdUserInt5>
<tdUserInt6>802727</tdUserInt6>
<tdUserInt7>706385</tdUserInt7>
<tdUserInt8>665022</tdUserInt8>
<tradeMemo3>TRADE_MEMO3</tradeMemo3>
<tradeMemo4>TRADE_MEMO4</tradeMemo4>
<tradeMemo5>CANCEL</tradeMemo5>
<thirdCurrencyFx>768.861</thirdCurrencyFx>
<timeOfSalesTicket>TIME_OF_SALES_TICKET</timeOfSalesTicket>
<timeOfSlate>TIME_OF_SLATE</timeOfSlate>
<tradeChar1>TRADE_CHAR1</tradeChar1>
<tradeFlat>Y</tradeFlat>
<tradersLogin>LOGIN</tradersLogin>
<transcost4Amount>522.328</transcost4Amount>
<transcost4Code>CODE4</transcost4Code>
<transcost4Currency>EUR</transcost4Currency>
<transcost4TypeCode>TYPE5</transcost4TypeCode>
<transcost5Amount>602.724</transcost5Amount>
<transcost5Code>CODE5</transcost5Code>
<transcost5Currency>USD</transcost5Currency>
<transcost5TypeCode>TYPE5</transcost5TypeCode>
<updateSourceTrd>MCADMIN</updateSourceTrd>
<underlyingAccrIntB>395.549</underlyingAccrIntB>
<underlyingAccrIntL>597.585</underlyingAccrIntL>
<underlyingAccrIntLMat>166.897</underlyingAccrIntLMat>
<withholdCode>W_CODE</withholdCode>
<withholdCurrency>EUR</withholdCurrency>
<withholdTypeCode>CODE</withholdTypeCode>
<workoutDate>2015-02-18</workoutDate>
<workoutPrice>632.133</workoutPrice>
<withholdingTax>642.057</withholdingTax>
<batchEventId>TSTR825</batchEventId>
<secFee>618.734</secFee>
<tradeDate>2015-02-18</tradeDate>
<recordType>TYPE</recordType>
<linkEventId>TSTR820A</linkEventId>
<orderNumber>ORDER_NUMBER</orderNumber>
<priceMethod>PRIC</priceMethod>
</warehouseTrade>
</warehouseTransaction>
</EagleML>