Warehouse Open Lot - 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>WarehouseOpenLot</objectType>
        </header>
        <warehouseOpenLot>
            <objectType>WarehouseOpenLot</objectType>
            <objectId>WarehouseOpenLot</objectId>
            <sourceName>EAGLE PACE</sourceName>
            <updateSource>MCADMIN</updateSource>
            <linkEventId>TSR80A</linkEventId>
            <localCurrency>USD</localCurrency>
            <effectiveDate>2014-01-21</effectiveDate>
            <longShortIndicator>L</longShortIndicator>
            <xrefAccountId>A1Q2W3R4U5K</xrefAccountId>
            <xrefAccountIdType>A1Q</xrefAccountIdType>
            <xrefClassCode>TF4</xrefClassCode>
            <accountingBasis>GAAP</accountingBasis>
            <procedureFlag>N</procedureFlag>
            <primaryAssetId>CUSIP_DKTEST2MA</primaryAssetId>
            <primaryAssetType>CUSIP</primaryAssetType>
            <cusip>CUSIP_DKTEST2MA</cusip>
            <isin>ISIN_DKTEST2MA</isin>
            <sedol>SEDOL_DKTEST2MA</sedol>
            <sicovmId>SICOVM_DKTEST2MA</sicovmId>
            <xrefIdentifiers>
                <xId1>
                    <xId>TSTID1_DKTEST2MA</xId>
                    <xIdType>TESTID1</xIdType>
                </xId1>
                <xId2>
                    <xId>TSTID2_DKTEST2MA</xId>
                    <xIdType>TESTID2</xIdType>
                </xId2>
            </xrefIdentifiers>
            <assetResolutionOption>CUSIP</assetResolutionOption>
            <battingOrder>cusip,xId1,isin,xId2,sicovmId,sedol</battingOrder>
            <baseCurrency>USD</baseCurrency>
            <transactionType>SHORTSELL</transactionType>
            <urglSecurityBase>673</urglSecurityBase>
            <urglCurrencyBase>25.47</urglCurrencyBase>
            <closeOpenEventId>TSTR825</closeOpenEventId>
            <closeEventId>TSR80A</closeEventId>
            <updateDate>2014-12-12</updateDate>
            <closeIndexWeight>8.9</closeIndexWeight>
            <closeTipsIncomeLtdLocal>35.8</closeTipsIncomeLtdLocal>
            <closeTipsIncomeLtdBase>96.6</closeTipsIncomeLtdBase>
            <marketValueLocal>67</marketValueLocal>
            <marketValueBase>15</marketValueBase>
            <marketValueIncomeLocal>297.519</marketValueIncomeLocal>
            <notionalMarketValueBase>963.515</notionalMarketValueBase>
            <notionalUnrealizedGlBase>653.28</notionalUnrealizedGlBase>
            <notionalCostLocal>706.742</notionalCostLocal>
            <notionalCostBase>302.738</notionalCostBase>
            <notionalMarketValueLocal>446.019</notionalMarketValueLocal>
            <notionalUnrealizedGlLocal>416.695</notionalUnrealizedGlLocal>
            <notionalUnrealizedCurrGl>653.167</notionalUnrealizedCurrGl>
            <notionalUnrealizedSecGl>271.51</notionalUnrealizedSecGl>
            <sourceLongShortInd>S</sourceLongShortInd>
            <settledQuantity>274.783</settledQuantity>
            <settleLocation>SETTLE_LOC</settleLocation>
            <accountingDate>2014-11-28</accountingDate>
            <amortizedLtdBase>78.9</amortizedLtdBase>
            <amortizedLtdLocal>374.578</amortizedLtdLocal>
            <amortizedPtdBase>811.57</amortizedPtdBase>
            <amortizedPtdLocal>12.4</amortizedPtdLocal>
            <closeAmortizedLocal>503.856</closeAmortizedLocal>
            <closeAmortizedBase>942.918</closeAmortizedBase>
            <amortizedCostBase>631.732</amortizedCostBase>
            <accruedInterestType>CUM</accruedInterestType>
            <accruedLtdBase>114.949</accruedLtdBase>
            <accruedLtdLocal>306.995</accruedLtdLocal>
            <accruedIncomeLocal>570.705</accruedIncomeLocal>
            <accruedIncome>318.626</accruedIncome>
            <acquisitionCode>ACQ_CODE</acquisitionCode>
            <currBuiltInGlSecurity>552.51</currBuiltInGlSecurity>
            <currBuiltInGlCurrency>386.413</currBuiltInGlCurrency>
            <currBuiltInGlDeferred>652.659</currBuiltInGlDeferred>
            <currBuiltInGlOid>450.061</currBuiltInGlOid>
            <currBuiltInGlMktDisc>555.575</currBuiltInGlMktDisc>
            <currFxRate>531.109</currFxRate>
            <departmentAcquisitionDate>2014-11-28</departmentAcquisitionDate>
            <expenses>490.914</expenses>
            <exchangeRate>539.532</exchangeRate>
            <executionBroker>Test_D</executionBroker>
            <federalTaxCostUnknown>F_T_C_UN</federalTaxCostUnknown>
            <gaapPremDisInd>G_P_D_IN</gaapPremDisInd>
            <gaapSettle>2014-11-28</gaapSettle>
            <gaapTrade>2014-11-28</gaapTrade>
            <gaapTradeDate>2014-11-28</gaapTradeDate>
            <idCost>642.594</idCost>
            <incomeDue>454.43</incomeDue>
            <intPurchased>192.813</intPurchased>
            <lastUpdateSrcDate>2014-11-28</lastUpdateSrcDate>
            <leg1NxtPmtAmt>349.337</leg1NxtPmtAmt>
            <leg1NxtPmtDate>2014-11-28</leg1NxtPmtDate>
            <leg2NxtPmtAmt>657.169</leg2NxtPmtAmt>
            <leg2NxtPmtDate>2014-11-28</leg2NxtPmtDate>
            <lastSaleSettle>2014-11-28</lastSaleSettle>
            <locationCode>Test_E</locationCode>
            <lastSaleTrade>2014-11-28</lastSaleTrade>
            <managedFl>MANA_FL</managedFl>
            <marketValueIncome>452.798</marketValueIncome>
            <netcashflwsNxtPmt>2014-11-28</netcashflwsNxtPmt>
            <netcashflwsNxtPmtDate>2014-11-28</netcashflwsNxtPmtDate>
            <otherCharges>666.033</otherCharges>
            <originalAcquisitionCostBase>224.303</originalAcquisitionCostBase>
            <originalAcquisitionCostLocal>624.308</originalAcquisitionCostLocal>
            <originalBuiltInGlMktDisc>832.129</originalBuiltInGlMktDisc>
            <originalBuiltInGlCurrency>313.052</originalBuiltInGlCurrency>
            <originalBuiltInGlDeferred>497.714</originalBuiltInGlDeferred>
            <originalBuiltInGlOid>206.708</originalBuiltInGlOid>
            <originalBuiltInGlSecurity>938.588</originalBuiltInGlSecurity>
            <originalTradePrice>188.198</originalTradePrice>
            <originalSourceCode>Test_F</originalSourceCode>
            <originalAcquisitionDate>2014-11-28</originalAcquisitionDate>
            <originalFace>524.53</originalFace>
            <origLotNumber>Test_G</origLotNumber>
            <origOpenSettleDate>2014-11-28</origOpenSettleDate>
            <origEventId>TSR821</origEventId>
            <performanceFlow>111.222</performanceFlow>
            <performancePrice>840.198</performancePrice>
            <performanceFlag>PF</performanceFlag>
            <price>896.457</price>
            <smInactiveFlag>N</smInactiveFlag>
            <purchaseQuantity>840.892</purchaseQuantity>
            <purYld>324.871</purYld>
            <pledgeFlag>PLE_FLAG</pledgeFlag>
            <prYrAccrIncome>129.05</prYrAccrIncome>
            <purchAccruedInterestAmt>307.37</purchAccruedInterestAmt>
            <reason>SPLIT</reason>
            <recParOrShares>681.709</recParOrShares>
            <registrationCode>BMCD</registrationCode>
            <reinvestCode>BVCFDS</reinvestCode>
            <restrictionCode>GFRDE</restrictionCode>
            <statPremDiscInd>S_P_D_IN</statPremDiscInd>
            <statSettle>2014-11-28</statSettle>
            <statTrade>2014-11-28</statTrade>
            <stateAcquisitionDate>2014-11-28</stateAcquisitionDate>
            <taxAcquisitionDate>2014-11-28</taxAcquisitionDate>
            <taxPremDiscInd>Test_H</taxPremDiscInd>
            <taxSettle>2014-11-28</taxSettle>
            <taxStatus>Test_I</taxStatus>
            <taxTrade>2014-11-28</taxTrade>
            <termIndicator>657.431</termIndicator>
            <intReceived>166.86</intReceived>
            <income>126.785</income>
            <votingAuthorityCode>VOAUC</votingAuthorityCode>
            <clientId>TSTR825</clientId>
            <covFlag>N</covFlag>
            <eventSubPriority>416743</eventSubPriority>
            <factor>613.171</factor>
            <ioIssuerAlias>Test_K</ioIssuerAlias>
            <ioIssuerId>TSTR210A</ioIssuerId>
            <origAcctDate>2014-11-28</origAcctDate>
            <origMonthlyAcctDate>2014-11-28</origMonthlyAcctDate>
            <parOrShares>965.969</parOrShares>
            <pendingTradeId>504244</pendingTradeId>
            <qtyWashSaleEligible>330.847</qtyWashSaleEligible>
            <strategy>Test_L</strategy>
            <tradeYield>239.2</tradeYield>
            <washSaleEligibleInd>N</washSaleEligibleInd>
            <aiaNetB>351.522</aiaNetB>
            <aiaNetL>177.79</aiaNetL>
            <buySellFlag>BUY</buySellFlag>
            <bookValue>15</bookValue>
            <bookValueLocal>776.052</bookValueLocal>
            <cpNetB>959.298</cpNetB>
            <cpNetL>538.021</cpNetL>
            <creditLossB>530.218</creditLossB>
            <creditLossL>769.722</creditLossL>
            <costBasisType>F</costBasisType>
            <futureFeeNetB>755.089</futureFeeNetB>
            <futureFeeNetL>798.772</futureFeeNetL>
            <impairmentLtdBase>414.216</impairmentLtdBase>
            <impairmentLtdLocal>280.34</impairmentLtdLocal>
            <mbaNetB>394.449</mbaNetB>
            <mbaNetL>971.647</mbaNetL>
            <naiaNetB>347.2</naiaNetB>
            <naiaNetL>421.234</naiaNetL>
            <nonCreditLossB>933.96</nonCreditLossB>
            <nonCreditLossL>767.559</nonCreditLossL>
            <adjustedShares>990.614</adjustedShares>
            <baseGaapMarketValue>350.704</baseGaapMarketValue>
            <baseStatMarketValue>294.697</baseStatMarketValue>
            <cashEquivalents>823.299</cashEquivalents>
            <cirBrkFees>152.549</cirBrkFees>
            <closeOidIncome>174.634</closeOidIncome>
            <closeOidIncomeLocal>322.017</closeOidIncomeLocal>
            <closeTipsIncomeLocal>978.696</closeTipsIncomeLocal>
            <closeTipsIncome>578.878</closeTipsIncome>
            <deferredIncomeTotalPtdB>466.831</deferredIncomeTotalPtdB>
            <deferredIncomeTotalPtdL>217.897</deferredIncomeTotalPtdL>
            <deltaAdjQty>394.804</deltaAdjQty>
            <dlta>632.319</dlta>
            <expoPrice>295.687</expoPrice>
            <earnThruDate>2014-11-28</earnThruDate>
            <execBrkFees>298.928</execBrkFees>
            <fedTaxCostValue>322.338</fedTaxCostValue>
            <gaapUnitBookValue>168.952</gaapUnitBookValue>
            <gaapUnitCost>650.915</gaapUnitCost>
            <gaapBookValue>752.556</gaapBookValue>
            <gaapCostValue>838.674</gaapCostValue>
            <hedgedCusip>Test_M</hedgedCusip>
            <hedgeTrading>Test_N</hedgeTrading>
            <interestEarned>757.761</interestEarned>
            <lastSettlementDate>2014-11-28</lastSettlementDate>
            <localGaapCostValue>421.612</localGaapCostValue>
            <localGaapUnitCost>551.414</localGaapUnitCost>
            <localGaapBookValue>171.979</localGaapBookValue>
            <localGaapUnitBookValue>601.952</localGaapUnitBookValue>
            <localGaapMarketValue>845.863</localGaapMarketValue>
            <localTaxUnitBookValue>957.592</localTaxUnitBookValue>
            <localStatUnitCost>763.119</localStatUnitCost>
            <localStatBookValue>181.064</localStatBookValue>
            <localStatCostValue>891.553</localStatCostValue>
            <localStatMarketValue>530.679</localStatMarketValue>
            <localStatUnitBookValue>985.645</localStatUnitBookValue>
            <localTaxBookValue>156.224</localTaxBookValue>
            <localTaxCostValue>725.376</localTaxCostValue>
            <localTaxUnitCost>808.945</localTaxUnitCost>
            <nonCreditLossAmortLtdB>208.773</nonCreditLossAmortLtdB>
            <nonCreditLossAmortLtdL>800.01</nonCreditLossAmortLtdL>
            <oidPtdBase>944.928</oidPtdBase>
            <oidPtdLocal>187.47</oidPtdLocal>
            <oidLtdIncomeLocal>292.856</oidLtdIncomeLocal>
            <oidLtdIncomeBase>411.76</oidLtdIncomeBase>
            <openMktPrice>219.334</openMktPrice>
            <origAccrPtdBase>587.66</origAccrPtdBase>
            <origSoldInterestBase>944.079</origSoldInterestBase>
            <origTradedInterestBase>415.021</origTradedInterestBase>
            <originalCostAmount>786.588</originalCostAmount>
            <payEpAccrued>180.385</payEpAccrued>
            <payRecInd>R</payRecInd>
            <posnFullyEarned>D</posnFullyEarned>
            <purchasePrincipalBase>832.941</purchasePrincipalBase>
            <purchasePrincipalLocal>236.615</purchasePrincipalLocal>
            <pv01total>923.197</pv01total>
            <preTaxAdjYld>168.521</preTaxAdjYld>
            <recEpAccrued>601.995</recEpAccrued>
            <statCostValue>995.176</statCostValue>
            <soldInterestBase>670.473</soldInterestBase>
            <scrubFlag>SF</scrubFlag>
            <sourceInternalAssetId>TS21A</sourceInternalAssetId>
            <statBookValue>433.593</statBookValue>
            <statUnitBookValue>528.924</statUnitBookValue>
            <soldInterestLocal>672.256</soldInterestLocal>
            <statUnitCost>778.238</statUnitCost>
            <stateCostValue>514.57</stateCostValue>
            <swapAccrMethod>I</swapAccrMethod>
            <totalUnrealizedGainLossLocal>503.616</totalUnrealizedGainLossLocal>
            <totalUnrealizedGainLossBase>237.482</totalUnrealizedGainLossBase>
            <tipsPtdBase>751.22</tipsPtdBase>
            <tipsPtdLocal>217.593</tipsPtdLocal>
            <taxBookValue>182.411</taxBookValue>
            <taxCostValue>752.657</taxCostValue>
            <taxUnitBookValue>410.449</taxUnitBookValue>
            <taxUnitCost>494.172</taxUnitCost>
            <tradeFxRate>871.991</tradeFxRate>
            <undPrice>898.109</undPrice>
            <uniqueAssetFlag>UN_A_FLA</uniqueAssetFlag>
            <bankAlias>200979</bankAlias>
            <batchEventId>TSTR821A</batchEventId>
            <brokerCode>EAGLE</brokerCode>
            <clearingBrokerCode>EAGLE</clearingBrokerCode>
            <commissionAmount>179.512</commissionAmount>
            <lotNumber>Test_O</lotNumber>
            <masterTicketNumber>Test_P</masterTicketNumber>
            <monthEndAccountingDate>2014-11-28</monthEndAccountingDate>
            <secFee>549.501</secFee>
            <settlementDate>2014-11-28</settlementDate>
            <tradeDate>2014-11-28</tradeDate>
            <transactionCode>REC</transactionCode>
            <userChar1>USER1</userChar1>
            <userChar2>USER2</userChar2>
            <userChar3>USER3</userChar3>
            <userDefinedFloat1>248.033</userDefinedFloat1>
            <userDefinedFloat2>151.497</userDefinedFloat2>
            <userDefinedFloat3>510.408</userDefinedFloat3>
            <pclUserDate1>2014-11-28</pclUserDate1>
            <pclUserDate2>2014-11-28</pclUserDate2>
            <pclUserDate3>2014-11-28</pclUserDate3>
            <userGroup1>USER_GR1</userGroup1>
            <userGroup2>USER_GR2</userGroup2>
            <userGroup3>USER_GR3</userGroup3>
            <userGroup4>USER_GR4</userGroup4>
            <userGroup5>USER_GR5</userGroup5>
            <userGroup6>USER_GR6</userGroup6>
            <userGroup7>USER_GR7</userGroup7>
            <userGroup8>USER_GR8</userGroup8>
            <userGroup9>USER_GR9</userGroup9>
            <userGroup10>USER_GR10</userGroup10>
            <userGroup11>USER_GR11</userGroup11>
            <userGroup12>USER_GR12</userGroup12>
            <userGroup13>USER_GR13</userGroup13>
            <userGroup14>USER_GR14</userGroup14>
            <userGroup15>USER_GR15</userGroup15>
            <userGroup16>USER_GR16</userGroup16>
            <userGroup17>USER_GR17</userGroup17>
            <userGroup18>USER_GR18</userGroup18>
        </warehouseOpenLot>
    </warehouseTransaction>
</EagleML>