In batch mode multiple rows can be loaded into the database by one EagleML message. In this mode the element warehouseTransaction can contain several warehouseCloseLot complex elements. The data from each element will be loaded into a separate database row.
Click to expand a batch mode 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>
<batchKey>entity^20150306^EAGLE PACE</batchKey>
<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-06</effectiveDate>
<closeOpenEventId>TSTR10001</closeOpenEventId>
<closeEventId>TST20A</closeEventId>
<longShortIndicator>L</longShortIndicator>
<lotSelectionMethod>HORIG</lotSelectionMethod>
<localCurrency>EUR</localCurrency>
<tradeDate>2015-03-13</tradeDate>
<ledgerEffectiveDate>2015-03-13</ledgerEffectiveDate>
<settlementDate>2015-03-13</settlementDate>
<transactionCode>BUYCANCEL</transactionCode>
<masterTicketNumber>A4F68JGE54GM1</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>
Batch Key Element
The group of complex elements (so-called 'batch') is given a specific set of values - a batch key (warehouseTransaction/batchKeyelement).
For WarehouseCloseLot it is Entity Id, Effective Date and Source Name formatted as entityId^effectiveDate^sourceName
- entityId – the element warehouseTransaction/warehouseCloseLot/entityId. Should be specified if it mapped from the EagleML message directly (in the warehouseTransaction/warehouseCloseLot/entityId). If the value of entityId is defined by the warehouseTransaction/warehouseCloseLot/xrefAccountId and warehouseTransaction/warehouseCloseLot/xrefAccountIdType elements, the first part of warehouseTransaction/batchKey could be any. The batch key will be updated with the entityId calculated from xref Ids.
- effectiveDate – the element warehouseTransaction/warehouseCloseLot/effectiveDate. Should be specified in DATE format: YYYYMMDD.
- sourceName – the element warehouseTransaction/warehouseCloseLot/sourceName.
Examples of correct WarehouseCloseLot batch key:
<batchKey>COMPTST1^20140120^EAGLE PACE</batchKey>
<batchKey>entity^20140120^EAGLE PACE</batchKey>
Insert/Update
The stored procedure for batch mode supports only inserting data into the database.
To update a database row please use single row mode.