| Info | ||
|---|---|---|
| ||
Wash Sale Open Lot model is extract-only and not extracted by default. To add it to your extract you should have the IncludeWashSales taskthe IncludeWashSales task parameter set to Y on your RTR. |
Element | Comment | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Xpath |
|---|---|---|---|---|---|---|---|
quantityWashSaleEligible | decimal | 405 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/quantityWashSaleEligible | ||||
origWashsaleDisallowanceL | decimal | 3847 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceL | ||||
origWashsaleDisallowanceB | decimal | 3848 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origWashsaleDisallowanceB | ||||
washsaleDisallowanceTerm | string | 3851 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceTerm | ||||
washsaleDisallowanceType | string | 3866 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleDisallowanceType | ||||
totalOpenQuantity | decimal | 4923 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/totalOpenQuantity | ||||
washsaleCloseTradeTicketNumber | string | 3861 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseTradeTicketNumber | ||||
washsaleCloseTradeDate | string | 3863 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseTradeDate | ||||
washsaleCloseQuantity | decimal | 3865 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseQuantity | ||||
washsaleCloseSecurityAlias | string | 4911 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseSecurityAlias | ||||
washsaleCloseEventID | string | 4917 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseEventID | ||||
washsaleCloseEventType | string | 4919 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseEventType | ||||
washsaleClosePostDate | string | 4920 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleClosePostDate | ||||
washsaleCloseAcctDate | string | 4921 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseAcctDate | ||||
washsaleCloseMonthlyAccountingDate | string | 4922 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleCloseMonthlyAccountingDate | ||||
totalCloseQuantity | decimal | 4924 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/totalCloseQuantity | ||||
washsaleOriginalOpenEventID | string | 3862 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalOpenEventID | ||||
washsaleOriginalAcquisitionDate | string | 3864 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalAcquisitionDate | ||||
washsaleOpenHoldingDate | string | 3988 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOpenHoldingDate | ||||
washsaleOriginalOpenTradeTicketNumber | string | 4925 | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleOriginalOpenTradeTicketNumber | ||||
washsaleQuantity | decimal | HOLDINGDBO | LOT_LEVEL_WS_POSITION | WASH_SALE_QTY | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleQuantity | ||
parOrShares | decimal | 163 | HOLDINGDBO | LOT_LEVEL_POSITION | PAR_OR_SHARES | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/parOrShares | |
currentWashsaleDisallowanceBase | string | 3850 | TRADESDBO | TRADE_WITH_WS | ORIG_WS_DIS_LOSS_B | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/currentWashsaleDisallowanceBase | |
currentWashsaleDisallowanceLocal | string | 3849 | TRADESDBO | TRADE_WITH_WS | ORIG_WS_DIS_LOSS_L | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/currentWashsaleDisallowanceLocal | |
washsaleTotalCloseLossLocal | decimal | 4999 | HOLDINGDBO | LOT_LEVEL_WS_POSITION | WS_CLS_TOTAL_LOSS_L | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleTotalCloseLossLocal | |
washsaleTotalCloseLossBase | decimal | 4998 | HOLDINGDBO | LOT_LEVEL_WS_POSITION | WS_CLS_TOTAL_LOSS_B | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/washsaleTotalCloseLossBase | |
accountingBasis | string | 21 | HOLDINGDBO | LOT_LEVEL_POSITION | ACCT_BASIS | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingBasis | |
baseCurrency | CurrencyCode | 86 | HOLDINGDBO | LOT_LEVEL_POSITION | CURRENCY | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/baseCurrency | |
origLotNumber | string | 151 | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_LOT_NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/origLotNumber | |
masterTicketNumber | string | 761 | HOLDINGDBO | LOT_LEVEL_POSITION | MASTER_TICKET_NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/masterTicketNumber | |
siSecurityAlias | integer | SECURITYDBO | BROKER_RATES | SI_SECURITY_ALIAS | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/siSecurityAlias | ||
postDate | date | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/postDate | |||||
tradeDate | date | 35 | HOLDINGDBO | LOT_LEVEL_POSITION | TRADE_DATE | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/tradeDate | |
accountingDate | date | 36 | HOLDINGDBO | LOT_LEVEL_POSITION | ACCOUNTING_DATE | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/accountingDate | |
monthlyAccountingDate | date | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/monthlyAccountingDate | |||||
openHldPerDate | date | 164 | HOLDINGDBO | LOT_LEVEL_POSITION | OPEN_HLD_PER_DATE | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/openHldPerDate | |
transactionType | normalizedString | 2283 | HOLDINGDBO | LOT_LEVEL_POSITION | TRANS_TYPE | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/transactionType | |
positionId | HOLDINGDBO | LOT_LEVEL_POSITION | POSITION_ID | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/positionId | |||
srcSysC | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/srcSysC |