| 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 |