Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleImportant Note
Wash Sale Open Lot model is extract-only and not extracted by default. To add it to your extract you should have the IncludeWashSales task parameter set to Y on your RTR.


Optional  OptionalOptional Optional Optional Optional Optional OptionalOptional  Optional OptionalOptional    OptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptionalOptional 
ElementOptional/RequiredCommentValue TypeStar TagEagle DBDB TableDB FieldXpath
quantityWashSaleEligible
decimal405  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/quantityWashSaleEligible
origWashsaleDisallowanceLOptional
decimal3847  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceL
origWashsaleDisallowanceB
decimal3848   


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceB
washsaleDisallowanceTermOptional
string3851   


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceTerm
washsaleDisallowanceType
string3866   


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceType
totalOpenQuantityOptional
decimal4923  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/totalOpenQuantity
washsaleCloseTradeTicketNumber
string3861  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseTradeTicketNumber
washsaleCloseTradeDate
string3863  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseTradeDate
washsaleCloseQuantity
decimal3865  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseQuantity
washsaleCloseSecurityAlias
string4911  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseSecurityAlias
washsaleCloseEventID
string4917   


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseEventID
washsaleCloseEventType
string4919  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseEventType
washsaleClosePostDateOptional
string4920   


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleClosePostDate
washsaleCloseAcctDateOptional
string4921  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseAcctDate
washsaleCloseMonthlyAccountingDate
string4922  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseMonthlyAccountingDate
totalCloseQuantity
decimal4924   


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/totalCloseQuantity
washsaleOriginalOpenEventID
string3862  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalOpenEventID
washsaleOriginalAcquisitionDateOptional
string3864  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalAcquisitionDate
washsaleOpenHoldingDateOptional
string3988  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOpenHoldingDate
washsaleOriginalOpenTradeTicketNumberOptional
string4925  


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalOpenTradeTicketNumber
washsaleQuantity
decimal 
HOLDINGDBOLOT_LEVEL_WS_POSITIONWASH_SALE_QTYEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleQuantity
parOrShares
decimal163HOLDINGDBOLOT_LEVEL_POSITIONPAR_OR_SHARESEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/parOrShares
currentWashsaleDisallowanceBase
string3850TRADESDBOTRADE_WITH_WSORIG_WS_DIS_LOSS_BEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/currentWashsaleDisallowanceBase
currentWashsaleDisallowanceLocal
string3849TRADESDBOTRADE_WITH_WSORIG_WS_DIS_LOSS_LEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/currentWashsaleDisallowanceLocal
washsaleTotalCloseLossLocalOptional
decimal4999HOLDINGDBOLOT_LEVEL_WS_POSITIONWS_CLS_TOTAL_LOSS_LEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleTotalCloseLossLocal
washsaleTotalCloseLossBase
decimal4998HOLDINGDBOLOT_LEVEL_WS_POSITIONWS_CLS_TOTAL_LOSS_BEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleTotalCloseLossBase
accountingBasis
string21HOLDINGDBOLOT_LEVEL_POSITIONACCT_BASISEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingBasis
baseCurrency
CurrencyCode86HOLDINGDBOLOT_LEVEL_POSITIONCURRENCYEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/baseCurrency
origLotNumber
string151HOLDINGDBOLOT_LEVEL_POSITIONORIG_LOT_NUMBEREagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origLotNumber
masterTicketNumberOptional
string761HOLDINGDBOLOT_LEVEL_POSITIONMASTER_TICKET_NUMBEREagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/masterTicketNumber
siSecurityAlias
integer 
SECURITYDBOBROKER_RATESSI_SECURITY_ALIASEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/siSecurityAlias
postDate
date    



EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/postDate
tradeDateOptional
date35HOLDINGDBOLOT_LEVEL_POSITIONTRADE_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/tradeDate
accountingDate
date36HOLDINGDBOLOT_LEVEL_POSITIONACCOUNTING_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingDate
monthlyAccountingDateOptional
date    



EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/monthlyAccountingDate
openHldPerDateOptional
date164HOLDINGDBOLOT_LEVEL_POSITIONOPEN_HLD_PER_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/openHldPerDate
transactionType
normalizedString2283HOLDINGDBOLOT_LEVEL_POSITIONTRANS_TYPEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/transactionType
positionIdOptional  


HOLDINGDBOLOT_LEVEL_POSITIONPOSITION_IDEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/positionId
srcSysCOptional    





EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/srcSysC

...