Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 2 Next »

Important 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.
ElementOptional/RequiredValue TypeStar TagEagle DBDB TableDB FieldXpath
quantityWashSaleEligibleOptionaldecimal405   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/quantityWashSaleEligible
origWashsaleDisallowanceLOptionaldecimal3847   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceL
origWashsaleDisallowanceBOptionaldecimal3848   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceB
washsaleDisallowanceTermOptionalstring3851   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceTerm
washsaleDisallowanceTypeOptionalstring3866   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceType
totalOpenQuantityOptionaldecimal4923   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/totalOpenQuantity
washsaleCloseTradeTicketNumberOptionalstring3861   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseTradeTicketNumber
washsaleCloseTradeDateOptionalstring3863   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseTradeDate
washsaleCloseQuantityOptionaldecimal3865   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseQuantity
washsaleCloseSecurityAliasOptionalstring4911   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseSecurityAlias
washsaleCloseEventIDOptionalstring4917   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseEventID
washsaleCloseEventTypeOptionalstring4919   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseEventType
washsaleClosePostDateOptionalstring4920   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleClosePostDate
washsaleCloseAcctDateOptionalstring4921   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseAcctDate
washsaleCloseMonthlyAccountingDateOptionalstring4922   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseMonthlyAccountingDate
totalCloseQuantityOptionaldecimal4924   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/totalCloseQuantity
washsaleOriginalOpenEventIDOptionalstring3862   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalOpenEventID
washsaleOriginalAcquisitionDateOptionalstring3864   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalAcquisitionDate
washsaleOpenHoldingDateOptionalstring3988   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOpenHoldingDate
washsaleOriginalOpenTradeTicketNumberOptionalstring4925   EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalOpenTradeTicketNumber
washsaleQuantityOptionaldecimal HOLDINGDBOLOT_LEVEL_WS_POSITIONWASH_SALE_QTYEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleQuantity
parOrSharesOptionaldecimal163HOLDINGDBOLOT_LEVEL_POSITIONPAR_OR_SHARESEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/parOrShares
currentWashsaleDisallowanceBaseOptionalstring3850TRADESDBOTRADE_WITH_WSORIG_WS_DIS_LOSS_BEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/currentWashsaleDisallowanceBase
currentWashsaleDisallowanceLocalOptionalstring3849TRADESDBOTRADE_WITH_WSORIG_WS_DIS_LOSS_LEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/currentWashsaleDisallowanceLocal
washsaleTotalCloseLossLocalOptionaldecimal4999HOLDINGDBOLOT_LEVEL_WS_POSITIONWS_CLS_TOTAL_LOSS_LEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleTotalCloseLossLocal
washsaleTotalCloseLossBaseOptionaldecimal4998HOLDINGDBOLOT_LEVEL_WS_POSITIONWS_CLS_TOTAL_LOSS_BEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleTotalCloseLossBase
accountingBasisOptionalstring21HOLDINGDBOLOT_LEVEL_POSITIONACCT_BASISEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingBasis
baseCurrencyOptionalCurrencyCode86HOLDINGDBOLOT_LEVEL_POSITIONCURRENCYEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/baseCurrency
origLotNumberOptionalstring151HOLDINGDBOLOT_LEVEL_POSITIONORIG_LOT_NUMBEREagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origLotNumber
masterTicketNumberOptionalstring761HOLDINGDBOLOT_LEVEL_POSITIONMASTER_TICKET_NUMBEREagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/masterTicketNumber
siSecurityAliasOptionalinteger SECURITYDBOBROKER_RATESSI_SECURITY_ALIASEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/siSecurityAlias
postDateOptionaldate    EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/postDate
tradeDateOptionaldate35HOLDINGDBOLOT_LEVEL_POSITIONTRADE_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/tradeDate
accountingDateOptionaldate36HOLDINGDBOLOT_LEVEL_POSITIONACCOUNTING_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingDate
monthlyAccountingDateOptionaldate    EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/monthlyAccountingDate
openHldPerDateOptionaldate164HOLDINGDBOLOT_LEVEL_POSITIONOPEN_HLD_PER_DATEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/openHldPerDate
transactionTypeOptionalnormalizedString2283HOLDINGDBOLOT_LEVEL_POSITIONTRANS_TYPEEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/transactionType
positionIdOptional  HOLDINGDBOLOT_LEVEL_POSITIONPOSITION_IDEagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/positionId
srcSysCOptional     EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/srcSysC
  • No labels