Warehouse Close Lot - 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>WarehouseCloseLot</objectType>
</header>
<warehouseCloseLot>
<objectType>WarehouseCloseLot</objectType>
<objectId>WarehouseCloseLot</objectId>
<sourceName>EAGLE PACE</sourceName>
<updateSource>MCADMIN</updateSource>
<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>
<effectiveDate>2015-03-08</effectiveDate>
<closeOpenEventId>TSTR10001</closeOpenEventId>
<closeEventId>TST20A</closeEventId>
<longShortIndicator>L</longShortIndicator>
<lotSelectionMethod>HORIG</lotSelectionMethod>
<smInactiveFlag>N</smInactiveFlag>
<localCurrency>EUR</localCurrency>
<tradeDate>2015-03-13</tradeDate>
<ledgerEffectiveDate>2015-03-13</ledgerEffectiveDate>
<settlementDate>2015-03-13</settlementDate>
<transactionCode>BUYCANCEL</transactionCode>
<masterTicketNumber>A4F68JGE54GN</masterTicketNumber>
<numberofLots>175402</numberofLots>
<exchangeCode>EX CODE</exchangeCode>
<postType>TYPE</postType>
<targetEventId>TSTR821</targetEventId>
<linkEventId>TS21A</linkEventId>
<postDate>2015-03-13</postDate>
<originalFaceValue>901.415</originalFaceValue>
<settlementLocation>LOCATION</settlementLocation>
<taxes>471.065</taxes>
<localCommissionAmount>240.095</localCommissionAmount>
<exchangeFee>872.783</exchangeFee>
<accruedInterest>102.767</accruedInterest>
<netCash>651.662</netCash>
<otherFee>346.971</otherFee>
<tradeStatus>STATUS</tradeStatus>
<trade_memo2>TRADE_MEMO2</trade_memo2>
<settlementCurrency>USD</settlementCurrency>
<settlementAmount>343.517</settlementAmount>
<settlement_exchange_rate>556.049</settlement_exchange_rate>
<fxRateOpen>242.189</fxRateOpen>
<fxRate>262.516</fxRate>
<brokerCode>EAGLE</brokerCode>
<unitCostBase>624.726</unitCostBase>
<costLocal>132.631</costLocal>
<costBase>694.041</costBase>
<unitOpenPrice>503.328</unitOpenPrice>
<unitCostLocal>567.779</unitCostLocal>
<price>830.174</price>
<tradeAmount>881.794</tradeAmount>
<settleAmount0>756.941</settleAmount0>
<closeHoldingPeriodDate>2015-03-13</closeHoldingPeriodDate>
<parOrShares>409.858</parOrShares>
<premiumAllocatedLocal>266.994</premiumAllocatedLocal>
<premiumAllocated>648.85</premiumAllocated>
<origAcqDate>2015-03-13</origAcqDate>
<gainLossTerm>G</gainLossTerm>
<openCostBasisType>C</openCostBasisType>
<closeCostBasisType>A</closeCostBasisType>
<tradeBaseAmount>876.885</tradeBaseAmount>
<amortLocal>342.864</amortLocal>
<amortBase>638.219</amortBase>
<clientId>T820A</clientId>
<feeAmt>399.189</feeAmt>
<principalFactor>673.728</principalFactor>
<tipIncomeLtdLocal>402.266</tipIncomeLtdLocal>
<tipIncomeLtdBase>684.22</tipIncomeLtdBase>
<bookValueLocal>727.79</bookValueLocal>
<bookValue>189.016</bookValue>
<monthEndDate>2015-03-13</monthEndDate>
<oidLocal>600.953</oidLocal>
<oidBase>379.453</oidBase>
<totalAmortLocal>435.988</totalAmortLocal>
<totalAmortBase>185.42</totalAmortBase>
<gainCurrency988>622.971</gainCurrency988>
<lossCurrency988>806.003</lossCurrency988>
<originalSourceCode>ORIGINAL_SOURCE_CODE</originalSourceCode>
<currencyGainInt>327.609</currencyGainInt>
<currencyLossInt>699.453</currencyLossInt>
<gainCurrency>919.532</gainCurrency>
<gainSecurityLocal>766.301</gainSecurityLocal>
<gainSecurity>732.085</gainSecurity>
<lossCurrency>613.574</lossCurrency>
<lossSecurityLocal>269.63</lossSecurityLocal>
<lossSecurity>299.865</lossSecurity>
<openCostLocal>357.716</openCostLocal>
<openCostBase>151.426</openCostBase>
<totalGain>870.772</totalGain>
<totalLoss>581.54</totalLoss>
<currBuiltinGlSec>232.386</currBuiltinGlSec>
<currBuiltinGlCurrency>433.59</currBuiltinGlCurrency>
<currBuiltinGlDeferred>372.392</currBuiltinGlDeferred>
<currBuiltinGlOid>475.25</currBuiltinGlOid>
<currBuiltinGlMktDisc>971.809</currBuiltinGlMktDisc>
<acquisitionType>A</acquisitionType>
<allocProceedsBase>369.44</allocProceedsBase>
<allocProceedsLocal>876.1</allocProceedsLocal>
<allUpRate>284.965</allUpRate>
<amortizationBase>857.135</amortizationBase>
<amortizationLocal>192.333</amortizationLocal>
<balance>869.185</balance>
<baseCommissionAmount>584.926</baseCommissionAmount>
<baseCostLot>195.316</baseCostLot>
<baseRealizedGlCurr>470.139</baseRealizedGlCurr>
<baseRealizedGlMkt>778.345</baseRealizedGlMkt>
<baseInterestAdj>445.27</baseInterestAdj>
<bnchYld1>469.525</bnchYld1>
<bnchYld2>401.317</bnchYld2>
<buyLotNbr>BUY LOT</buyLotNbr>
<cancelDueToCorrection>CANC</cancelDueToCorrection>
<closeOutPl0>251.274</closeOutPl0>
<closeoutpl1>611.1</closeoutpl1>
<clsOpenCumExInd>N</clsOpenCumExInd>
<compared>COMPARED</compared>
<covFlag>N</covFlag>
<creditLossB>914.737</creditLossB>
<creditLossL>170.807</creditLossL>
<disallowGainB>377.402</disallowGainB>
<disallowGainL>646.823</disallowGainL>
<disallowLossB>598.347</disallowLossB>
<disallowLossL>547.032</disallowLossL>
<discountRate>846.688</discountRate>
<dispBookValueGaap>856.063</dispBookValueGaap>
<dispBookValueStat>512.424</dispBookValueStat>
<eventSubPriority>351570</eventSubPriority>
<exchangeFeeBase>644.81</exchangeFeeBase>
<fairMarketValueBase>965.018</fairMarketValueBase>
<fairMarketValueFlag>Y</fairMarketValueFlag>
<fairMarketValueLocal>623.962</fairMarketValueLocal>
<fairMarketValuePrice>120.062</fairMarketValuePrice>
<federalTaxWithholdBase>936.828</federalTaxWithholdBase>
<feeamtBase>893.403</feeamtBase>
<gaapCostValue>810.128</gaapCostValue>
<gaapSecType>TYPE</gaapSecType>
<gaapUnitCost>221.794</gaapUnitCost>
<gainCurrencyAvg>664.505</gainCurrencyAvg>
<gainCurrencyId>816.428</gainCurrencyId>
<gainSecurityAvg>904.945</gainSecurityAvg>
<gainSecurityAvgLocal>249.432</gainSecurityAvgLocal>
<gainSecurityId>911.744</gainSecurityId>
<gainSecurityIdLocal>375.085</gainSecurityIdLocal>
<interestSold>927.777</interestSold>
<invertFlag>N</invertFlag>
<letterConfirm>LETTER</letterConfirm>
<lettered>LETTERED</lettered>
<localCostLot>357.015</localCostLot>
<localGaapCostValue>658.576</localGaapCostValue>
<localGaapUnitCost>243.062</localGaapUnitCost>
<localRealizedGl>422.255</localRealizedGl>
<lossCurrencyAvg>269.677</lossCurrencyAvg>
<lossCurrencyId>157.8</lossCurrencyId>
<lossSecurityAvg>407.028</lossSecurityAvg>
<lossSecurityAvgLocal>461.045</lossSecurityAvgLocal>
<lossSecurityId>618.589</lossSecurityId>
<lossSecurityIdLocal>905.375</lossSecurityIdLocal>
<margin>908.077</margin>
<marginPoints>379.244</marginPoints>
<monthlyAccountingDate>2015-03-13</monthlyAccountingDate>
<mtType>MT_TYPE</mtType>
<nonCreditLossB>675.406</nonCreditLossB>
<nonCreditLossL>334.469</nonCreditLossL>
<notionalAmt>910.672</notionalAmt>
<openAcctDate>2015-03-13</openAcctDate>
<openEventId>TSTR821</openEventId>
<openMonthlyAcctDate>2015-03-13</openMonthlyAcctDate>
<originalAcctDate>2015-03-13</originalAcctDate>
<originalEventId>TSTR210A</originalEventId>
<originalmonthlyAcctDate>2015-03-13</originalmonthlyAcctDate>
<otherFeeBase>899.341</otherFeeBase>
<ownershipTransferDate>2015-03-13</ownershipTransferDate>
<paceTradeEventId>TSTR821</paceTradeEventId>
<poolNumber>POOL_NUMBER</poolNumber>
<positionId>762246</positionId>
<priceCurrency>EUR</priceCurrency>
<qtyWashSaleEligible>922.815</qtyWashSaleEligible>
<quantity>439.866</quantity>
<realizedGlBase>667.192</realizedGlBase>
<realizedGlCrB>986.213</realizedGlCrB>
<realizedGlCrL>351.611</realizedGlCrL>
<realizedGlLocal>856.243</realizedGlLocal>
<realizedGlNcrB>827.957</realizedGlNcrB>
<realizedGlNcrL>522.592</realizedGlNcrL>
<recordType>TYPE</recordType>
<settleAmt1>514.82</settleAmt1>
<shortTermId>844847</shortTermId>
<stateTaxWithholdBase>598.463</stateTaxWithholdBase>
<targetPurchaseDate>2015-03-13</targetPurchaseDate>
<targetPurchasePrice>856.751</targetPurchasePrice>
<taxesBase>251.876</taxesBase>
<termLength>LENGTH</termLength>
<totalCurrentLoss>959.508</totalCurrentLoss>
<totalGainAvg>475.341</totalGainAvg>
<totalGainId>157.252</totalGainId>
<totalLossAvg>781.553</totalLossAvg>
<totalLossId>668.552</totalLossId>
<tradeFlat>Y</tradeFlat>
<tradersLogin>LOGIN</tradersLogin>
<unitPriceOpen>646.624</unitPriceOpen>
<updateUserId>TSTR821</updateUserId>
<userDate1>2015-03-13</userDate1>
<userFloat1>573.602</userFloat1>
<userFloat10>895.302</userFloat10>
<userFloat11>368.884</userFloat11>
<userFloat12>938.508</userFloat12>
<userFloat13>708.611</userFloat13>
<userFloat14>995.37</userFloat14>
<userFloat15>210.785</userFloat15>
<userFloat2>332.049</userFloat2>
<userFloat3>757.618</userFloat3>
<userFloat4>133.601</userFloat4>
<userFloat5>671.915</userFloat5>
<userFloat6>424.811</userFloat6>
<userFloat7>933.78</userFloat7>
<userFloat8>837.492</userFloat8>
<userFloat9>195.022</userFloat9>
</warehouseCloseLot>
</warehouseTransaction>
</EagleML>