Warehouse Open Lot - Wash Sale Open Lot Model Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
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.
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 |