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.


ElementCommentValue TypeStar TagEagle DBDB TableDB FieldXpath
quantityWashSaleEligible
decimal405


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/quantityWashSaleEligible
origWashsaleDisallowanceL
decimal3847


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceL
origWashsaleDisallowanceB
decimal3848


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceB
washsaleDisallowanceTerm
string3851


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceTerm
washsaleDisallowanceType
string3866


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceType
totalOpenQuantity
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
washsaleClosePostDate
string4920


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleClosePostDate
washsaleCloseAcctDate
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
washsaleOriginalAcquisitionDate
string3864


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalAcquisitionDate
washsaleOpenHoldingDate
string3988


EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOpenHoldingDate
washsaleOriginalOpenTradeTicketNumber
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
washsaleTotalCloseLossLocal
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
masterTicketNumber
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
tradeDate
date35HOLDINGDBOLOT_LEVEL_POSITIONTRADE_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/tradeDate
accountingDate
date36HOLDINGDBOLOT_LEVEL_POSITIONACCOUNTING_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingDate
monthlyAccountingDate
date



EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/monthlyAccountingDate
openHldPerDate
date164HOLDINGDBOLOT_LEVEL_POSITIONOPEN_HLD_PER_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/openHldPerDate
transactionType
normalizedString2283HOLDINGDBOLOT_LEVEL_POSITIONTRANS_TYPEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/transactionType
positionId


HOLDINGDBOLOT_LEVEL_POSITIONPOSITION_IDEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/positionId
srcSysC





EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/srcSysC