Warehouse Trade - UPSERT Mode, Insert Data Example

<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>