Warehouse Wash Sale Trade Data Map Table

objectType

ObjectTypeEnum

not stored in DB

EagleML/accountingTransaction/warehouseWashSaleTrade/objectType

objectId

ObjectId

not stored in DB

EagleML/accountingTransaction/warehouseWashSaleTrade/objectId

objectDescription

FeedTypeEnum

not stored in DB

EagleML/accountingTransaction/warehouseWashSaleTrade/objectDescription

updateTimestamp

dateTime

1106

TRADESDBO

TRADE_WITH_WS

UPDATE_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/updateTimestamp

customElements

CustomElements

reserved for customizations

EagleML/accountingTransaction/warehouseWashSaleTrade/customElements

updateSource

string

944

TRADESDBO

TRADE_WITH_WS

UPDATE_SOURCE

VARCHAR2(32)

EagleML/accountingTransaction/warehouseWashSaleTrade/updateSource

Entity Common Id Model

EagleML/accountingTransaction/warehouseWashSaleTrade/

Entity Properties Model (extract only)

EagleML/accountingTransaction/warehouseWashSaleTrade/

accountingBasis

string

21

TRADESDBO

TRADE_WITH_WS

ACCT_BASIS

VARCHAR2(5)

EagleML/warehouseTransaction/warehouseWashSaleTrade/accountingBasis

entityIDLookupSwitch

LookupSwitchEnum

989

not stored in DB

EagleML/warehouseTransaction/warehouseWashSaleTrade/entityIDLookupSwitch

entityNameLookupSwitch

LookupSwitchEnum

990

not stored in DB

EagleML/warehouseTransaction/warehouseWashSaleTrade/entityNameLookupSwitch

securityQueryFlag

YesNoOptionEnum

1256

not stored in DB

EagleML/warehouseTransaction/warehouseWashSaleTrade/securityQueryFlag

sourceLookupSwitch

LookupSwitchEnum

not stored in DB

EagleML/warehouseTransaction/warehouseWashSaleTrade/sourceLookupSwitch

procedureMode

ProcedureFlagTypeEnum

1076

not stored in DB

EagleML/warehouseTransaction/warehouseWashSaleTrade/procedureMode

procedureFlag

ProcedureFlagTypeEnum

1078

not stored in DB

EagleML/warehouseTransaction/warehouseWashSaleTrade/procedureFlag

Asset Identifiers Model

EagleML/warehouseTransaction/warehouseWashSaleTrade/

Extended Asset Properties Model (extract only)

EagleML/warehouseTransaction/warehouseWashSaleTrade/

effectiveDate

date

221

TRADESDBO

TRADE_WITH_WS

EFFECTIVE_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/effectiveDate

baseCurrency

CurrencyCode

86

TRADESDBO

TRADE_WITH_WS

BASE_CURRENCY

VARCHAR2(3) 

EagleML/accountingTransaction/warehouseWashSaleTrade/baseCurrency

longShortIndicator

LongShortIndicatorEnum

15

TRADESDBO

TRADE_WITH_WS

LONG_SHORT_IND

VARCHAR2(2) 

EagleML/accountingTransaction/warehouseWashSaleTrade/longShortIndicator

recordType

integer 

12097

TRADESDBO

TRADE_WITH_WS

RECORD_TYPE

NUMBER(38,0) 

EagleML/accountingTransaction/warehouseWashSaleTrade/recordType

mttype

string

13280

TRADESDBO

TRADE_WITH_WS

MT_TYPE

VARCHAR2(8) 

EagleML/accountingTransaction/warehouseWashSaleTrade/mttype

transactionType

string 

2283

TRADESDBO

TRADE_WITH_WS

TRANS_TYPE

VARCHAR2(55) 

EagleML/accountingTransaction/warehouseWashSaleTrade/transactionType

eventId

string 

25

TRADESDBO

TRADE_WITH_WS

EVENT_ID

VARCHAR2(55) 

EagleML/accountingTransaction/warehouseWashSaleTrade/eventId

eventSequence

integer 

126

TRADESDBO

TRADE_WITH_WS

EVENT_SEQUENCE

NUMBER(38,0) 

EagleML/accountingTransaction/warehouseWashSaleTrade/eventSequence

postDate

date

30

TRADESDBO

TRADE_WITH_WS

POST_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/postDate

tradeDate

date

35

TRADESDBO

TRADE_WITH_WS

TRADE_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/tradeDate

accountingDate

date

7566

TRADESDBO

TRADE_WITH_WS

ACCT_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/accountingDate

origAcctDate

date

12036

TRADESDBO

TRADE_WITH_WS

ORIG_ACCT_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/origAcctDate

monthlyAccountingDate

date

12102

TRADESDBO

TRADE_WITH_WS

MONTHLY_ACCT_DATE

DATE

EagleML/accountingTransaction/warehouseWashSaleTrade/monthlyAccountingDate

siSecurityAlias

integer 

TRADESDBO

TRADE_WITH_WS

SI_SECURITY_ALIAS

NUMBER(38,0) 

EagleML/accountingTransaction/warehouseWashSaleTrade/siSecurityAlias

otherSecurityAlias

integer 

TRADESDBO

TRADE_WITH_WS

OTHER_SEC_ALIAS

NUMBER(38,0) 

EagleML/accountingTransaction/warehouseWashSaleTrade/otherSecurityAlias

targetEventId

string

7018

TRADESDBO

TRADE_WITH_WS

TARGET_EVENT_ID

VARCHAR2(55) 

EagleML/accountingTransaction/warehouseWashSaleTrade/targetEventId

washsaleUnits

decimal

TRADESDBO

TRADE_WITH_WS

WASH_SALE_UNITS

NUMBER(38,12) 

EagleML/accountingTransaction/warehouseWashSaleTrade/washsaleUnits

disallowedLossLocal

decimal

TRADESDBO

TRADE_WITH_WS

DISALLOWED_LOSS_L

NUMBER(38,12) 

EagleML/accountingTransaction/warehouseWashSaleTrade/disallowedLossLocal

disallowedLossBase

decimal

2431

TRADESDBO

TRADE_WITH_WS

DISALLOWED_LOSS_B

NUMBER(38,12) 

EagleML/accountingTransaction/warehouseWashSaleTrade/disallowedLossBase

cancelFlag

YesNoOptionEnum

10045

TRADESDBO

TRADE_WITH_WS

CANCEL_FLAG

VARCHAR2(2) 

EagleML/accountingTransaction/warehouseWashSaleTrade/cancelFlag

cancelStatus

string

10046

TRADESDBO

TRADE_WITH_WS

CANCEL_STATUS

VARCHAR2(2) 

EagleML/accountingTransaction/warehouseWashSaleTrade/cancelStatus

masterTicketNumber

string

761

TRADESDBO

TRADE_WITH_WS

MASTER_TICKET_NUMBER

VARCHAR2(255) 

EagleML/accountingTransaction/warehouseWashSaleTrade/masterTicketNumber

washsaleReversalType

string 

3867

TRADESDBO

TRADE_WITH_WS

WS_REVERSAL_TYPE

VARCHAR2(30) 

EagleML/accountingTransaction/warehouseWashSaleTrade/washsaleReversalType

washsaleDisallowedReversalLocal

decimal

3882

TRADESDBO

TRADE_WITH_WS

WS_DIS_REVERSAL_L

NUMBER(38,12) 

EagleML/accountingTransaction/warehouseWashSaleTrade/washsaleDisallowedReversalLocal

washsaleDisallowedReversalBase

decimal

3883

TRADESDBO

TRADE_WITH_WS

WS_DIS_REVERSAL_B

NUMBER(38,12) 

EagleML/accountingTransaction/warehouseWashSaleTrade/washsaleDisallowedReversalBase

positionId

integer 

830

TRADESDBO

TRADE_WITH_WS

POSITION_ID

NUMBER(38,0) 

EagleML/accountingTransaction/warehouseWashSaleTrade/positionId

instance

integer

9355

TRADESDBO

TRADE_WITH_WS

INSTANCE

NUMBER(38,0)

EagleML/accountingTransaction/warehouseWashSaleTrade/instance

srcSysC

string

98

TRADESDBO

TRADE_WITH_WS

SRC_SYS_C

VARCHAR2(25)

EagleML/accountingTransaction/warehouseWashSaleTrade/srcSysC