Please note that if pendingTradeFlag=Y, records are loaded into tradesdbo.pending_trades table
<EagleML xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" eaglemlVersion="2-0" eaglemlType="AccountingTransactionMessage" xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd" xsi:type="AccountingTransactionMessage"> <accountingTransaction> <header> <objectType>AccountingTrade</objectType> </header> <accountingTrade> <objectType>AccountingTrade</objectType> <objectId>AccountingTrade</objectId> <objectDescription>ACCOUNTING</objectDescription> <updateSource>MCADMIN</updateSource> <entityId>12456AE2</entityId> <primaryAssetId>C12456_A2</primaryAssetId> <primaryAssetType>CUSIP</primaryAssetType> <primaryExchangeCode>US</primaryExchangeCode> <buySellIndicator>BUY</buySellIndicator> <tradeDate>2018-06-01</tradeDate> <settlementDate>2018-06-02</settlementDate> <sharesParQuantity>1000</sharesParQuantity> <price>2</price> <brokerName>EAGLE PACE</brokerName> <originalTradeTicketNumber>12456_testtag761_buy_A2</originalTradeTicketNumber> <calculateLocalAmountsFlag>Y</calculateLocalAmountsFlag> <payRecAccount>Test</payRecAccount> <pendingTradeFlag>Y</pendingTradeFlag> </accountingTrade> </accountingTransaction> </EagleML>