Versions Compared

Old Version 27

changes.mady.by.user Alexey Chunikhin

Saved on

compared with

New Version 28

changes.mady.by.user Kinga Huszno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
titleNote
  • Some elements are available only for certain versions of the environment - these are denoted like this: (supported in v17)

  • To include the Wash Sale Open Lot you need IncludeWashSales task parameter set to Y in your RTR for extract

  • Anchor
    sourceLongShortInd_and_longShortInd
    sourceLongShortInd_and_longShortInd
    sourceLongShortInd and longShortIndicator are mapped into the same tag15 in_long_short_ind. If both nodes are not null in the incoming message, the value of longShortIndicator has a higher priority.
  • Anchor
    procedureMode_and_procedureFlag_note
    procedureMode_and_procedureFlag_note
    procedureMode and procedureFlag specify type of action (INSERT, UPDATE, DELETE)

...

ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeXPath
objectType
ObjectTypeEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/objectType
objectId
ObjectId


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/objectId
objectDescription
FeedTypeEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/objectDescription
updateTimestamp
dateTime


HOLDINGDBOLOT_LEVEL_POSITIONUPDATE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/updateTimestamp
customElementsNot recommendedCustomElements - Complex Type


reserved for customizations
EagleML/warehouseTransaction/warehouseOpenLot/customElements
sourceName
string1102in_short_descSPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/warehouseTransaction/warehouseOpenLot/sourceName
updateSource
string944in_update_sourceSHOLDINGDBOLOT_LEVEL_POSITIONUPDATE_SOURCECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/updateSource
batchCollectErrorsFlag
YesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/batchCollectErrorsFlag
singleRowCommitFlag
YesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/singleRowCommitFlag
linkEventId
TransactionId28in_link_event_idSHOLDINGDBOLOT_LEVEL_POSITIONLINK_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/linkEventId
localCurrency
CurrencyCode85in_local_currencySHOLDINGDBOLOT_LEVEL_POSITIONLOCAL_CURRENCYCHAR(3)EagleML/warehouseTransaction/warehouseOpenLot/localCurrency
effectiveDate
date221in_effective_dateSHOLDINGDBOPOSITION_COST_LOTEFFECTIVE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/effectiveDate
maturityDateRequireddate


not stored in DB - needed for resolution logics
EagleML/warehouseTransaction/warehouseOpenLot/maturityDate
Anchor
longShortIndicator
longShortIndicator
longShortIndicator		Optional
(see Note)		LongShortIndicatorEnum15in_long_short_indSHOLDINGDBOLOT_LEVEL_POSITIONLONG_SHORT_INDCHAR(4)EagleML/warehouseTransaction/warehouseOpenLot/longShortIndicator
Entity Common Id ModelEagleML/warehouseTransaction/warehouseOpenLot/
Entity Properties Model (extract only)EagleML/warehouseTransaction/warehouseOpenLot/
accountingBasis
string21IN_ACCOUNTSHOLDINGDBOPOSITIONACCT_BASISVARCHAR2(5)EagleML/warehouseTransaction/warehouseOpenLot/accountingBasis
entityIDLookupSwitch
LookupSwitchEnum989

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/entityIDLookupSwitch
entityNameLookupSwitch
LookupSwitchEnum990

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/entityNameLookupSwitch
securityQueryFlag
YesNoOptionEnum1256

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/securityQueryFlag
sourceLookupSwitch
LookupSwitchEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/sourceLookupSwitch
Anchor
procedureMode
procedureMode
procedureMode		Optional
(see Note)		ProcedureFlagTypeEnum1078in_procedure_modeSnot stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/procedureMode
Anchor
procedureFlag
procedureFlag
procedureFlag		Optional
(see Note)		ProcedureFlagTypeEnum1076in_mode_flagSnot stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/procedureFlag
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseOpenLot/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/warehouseOpenLot/
baseCurrency
CurrencyCode86in_base_currencySHOLDINGDBOLOT_LEVEL_POSITIONCURRENCYCHAR(3)EagleML/warehouseTransaction/warehouseOpenLot/baseCurrency
srcIntfcInst
decimal1168

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/srcIntfcInst
transactionType
string2283in_trans_typeSHOLDINGDBOLOT_LEVEL_POSITIONTRANS_TYPEVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/transactionType
rollupFlag
YesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/rollupFlag
urglSecurityBase
decimal491in_unrealized_sec_glNHOLDINGDBOLOT_LEVEL_POSITIONUNREALIZED_SEC_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/urglSecurityBase
urglCurrencyBase
decimal493in_unrealized_curr_glNHOLDINGDBOLOT_LEVEL_POSITIONUNREALIZED_CURR_GLNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/urglCurrencyBase
updateDate
date1106in_update_dateSHOLDINGDBOLOT_LEVEL_POSITIONUPDATE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/updateDate
closeOpenEventId
TransactionId181

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/closeOpenEventId
closeEventId
TransactionId182

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/closeEventId
closeIndexWeight
decimal4483in_indx_weightNHOLDINGDBOLOT_LEVEL_POSITIONINDX_WEIGHTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/closeIndexWeight
closeTipsIncomeLtdLocal
decimal4440in_tip_ltd_income_localNHOLDINGDBOLOT_LEVEL_POSITIONTIP_LTD_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdLocal
closeTipsIncomeLtdBase
decimal4445in_tip_ltd_incomeNHOLDINGDBOLOT_LEVEL_POSITIONTIP_LTD_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdBase
marketValueLocal
decimal487in_local_market_valueNHOLDINGDBOLOT_LEVEL_POSITIONLOCAL_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueLocal
marketValueBase
decimal488in_market_valueNHOLDINGDBOLOT_LEVEL_POSITIONMARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueBase
marketValueIncomeLocal
decimal9424in_market_value_income_localNHOLDINGDBOLOT_LEVEL_POSITIONMARKET_VALUE_INCOME_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncomeLocal
notionalMarketValueBase
decimal10794in_notional_market_valueNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueBase
notionalUnrealizedGlBase
decimal10796in_notional_unrealized_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_UNREALIZED_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlBase
notionalCostLocal
decimal10791in_notional_cost_localNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_COST_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalCostLocal
notionalCostBase
decimal10792in_notional_costNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_COSTNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalCostBase
notionalMarketValueLocal
decimal10793in_notional_market_value_localNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_MARKET_VALUE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueLocal
notionalUnrealizedGlLocal
decimal10795in_notional_local_unrealiz_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_LOCAL_UNREALIZED_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlLocal
notionalUnrealizedCurrGl
decimal10797in_notional_unrealized_curr_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_UNREALIZED_CURR_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedCurrGl
notionalUnrealizedSecGl
decimal10798in_notional_unrealized_sec_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_UNREALIZED_SEC_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedSecGl
Anchor
sourceLongShortInd
sourceLongShortInd
sourceLongShortInd		Optional
(see Note)		string15in_long_short_indSHOLDINGDBOLOT_LEVEL_POSITIONLONG_SHORT_INDCHAR(4)EagleML/warehouseTransaction/warehouseOpenLot/sourceLongShortInd
settledQuantity
decimal274in_settle_quantityNHOLDINGDBOLOT_LEVEL_POSITIONSETTLE_QUANTITYNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/settledQuantity
settleLocation
string43in_settlement_locationSHOLDINGDBOPOSITION_COST_LOTSETTLEMENT_LOCATIONCHAR(12)EagleML/warehouseTransaction/warehouseOpenLot/settleLocation
accountingDate
date36in_accounting_dateSHOLDINGDBOLOT_LEVEL_POSITIONACCOUNTING_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/accountingDate
amortizedLtdBase
decimal595in_amortization_ltd_baseNHOLDINGDBOLOT_LEVEL_POSITIONAMORTIZATION_LTD_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedLtdBase
amortizedLtdLocal
decimal580in_amortization_ltd_localNHOLDINGDBOLOT_LEVEL_POSITIONAMORTIZATION_LTD_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedLtdLocal
amortizedPtdBase
decimal598in_amort_ptd_baseNHOLDINGDBOPOSITION_COST_LOTAMORT_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedPtdBase
amortizedPtdLocal
decimal583in_amort_ptd_localNHOLDINGDBOPOSITION_COST_LOTAMORT_PTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedPtdLocal
closeAmortizedLocal
decimal521in_cls_amort_localNHOLDINGDBOLOT_LEVEL_POSITIONCLS_AMORT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeAmortizedLocal
closeAmortizedBase
decimal522in_cls_amort_baseNHOLDINGDBOLOT_LEVEL_POSITIONCLS_AMORT_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeAmortizedBase
amortizedCostBase
decimal2694in_amortized_costNHOLDINGDBOLOT_LEVEL_POSITIONAMORTIZED_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedCostBase
accruedInterestType
string3715in_accrued_interest_typeSHOLDINGDBOLOT_LEVEL_POSITIONACCRUED_INTEREST_TYPEVARCHAR2(3)EagleML/warehouseTransaction/warehouseOpenLot/accruedInterestType
accruedLtdBase
decimal585in_accr_ltd_baseNHOLDINGDBOPOSITION_COST_LOTACCR_LTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedLtdBase
accruedLtdLocal
decimal462in_accr_ltd_localNHOLDINGDBOPOSITION_COST_LOTACCR_LTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedLtdLocal
accruedIncomeLocal
decimal718in_accrued_income_localNHOLDINGDBOLOT_LEVEL_POSITIONACCRUED_INCOME_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedIncomeLocal
accruedIncome
decimal726in_accrued_incomeNHOLDINGDBOLOT_LEVEL_POSITIONACCRUED_INCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedIncome
acquisitionCode
string13044in_acquisition_codeSHOLDINGDBOLOT_LEVEL_POSITIONACQUISITION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/acquisitionCode
currBuiltInGlSecurity
decimal9761in_curr_builtin_gl_secNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_SECNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlSecurity
currBuiltInGlCurrency
decimal10917in_curr_builtin_gl_currencyNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_CURRENCYNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlCurrency
currBuiltInGlDeferred
decimal10918in_curr_builtin_gl_deferredNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_DEFERREDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlDeferred
currBuiltInGlOid
decimal10919in_curr_builtin_gl_oidNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_OIDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlOid
currBuiltInGlMktDisc
decimal10920in_curr_builtin_gl_mkt_discNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_MKT_DISCNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlMktDisc
currFxRate
decimal484in_curr_fx_rateNHOLDINGDBOLOT_LEVEL_POSITIONCURR_FX_RATENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/currFxRate
departmentAcquisitionDate
date7560in_department_acquisition_dateSHOLDINGDBOLOT_LEVEL_POSITIONDEPARTMENT_ACQUISITION_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/departmentAcquisitionDate
expenses
decimal48in_expensesNHOLDINGDBOLOT_LEVEL_POSITIONEXPENSESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/expenses
exchangeRate
decimal87in_exchange_rateNHOLDINGDBOLOT_LEVEL_POSITIONEXCHANGE_RATENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/exchangeRate
executionBroker
string10987in_execution_brokerSHOLDINGDBOLOT_LEVEL_POSITIONEXECUTION_BROKERVARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/executionBroker
federalTaxCostUnknown
string1545in_federal_tax_cost_unknownSHOLDINGDBOLOT_LEVEL_POSITIONFEDERAL_TAX_COST_UNKNOWNCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/federalTaxCostUnknown
gaapPremDisInd
string13048in_gaap_prem_disc_indSHOLDINGDBOPOSITION_COST_LOTGAAP_PREM_DISC_INDCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/gaapPremDisInd
gaapSettle
date13992in_gaap_settleSHOLDINGDBOPOSITION_COST_LOTGAAP_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/gaapSettle
gaapTrade
date13991in_gaap_tradeSHOLDINGDBOPOSITION_COST_LOTGAAP_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/gaapTrade
gaapTradeDate
date9669in_gaap_trade_dateSHOLDINGDBOLOT_LEVEL_POSITIONGAAP_TRADE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/gaapTradeDate
idCost
decimal247in_id_costNHOLDINGDBOLOT_LEVEL_POSITIONID_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/idCost
incomeDue
decimal114in_income_dueNHOLDINGDBOLOT_LEVEL_POSITIONINCOME_DUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/incomeDue
intPurchased
decimal49in_int_purchasedNHOLDINGDBOLOT_LEVEL_POSITIONINT_PURCHASEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/intPurchased
lastUpdateSrcDate
date1775in_last_update_src_dateSHOLDINGDBOLOT_LEVEL_POSITIONLAST_UPDATE_SRC_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastUpdateSrcDate
leg1NxtPmtAmt
decimal1398in_leg1_nxt_pmt_amtNHOLDINGDBOLOT_LEVEL_POSITIONLEG1_NXT_PMT_AMTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/leg1NxtPmtAmt
leg1NxtPmtDate
date1397in_leg1_nxt_pmt_dateSHOLDINGDBOLOT_LEVEL_POSITIONLEG1_NXT_PMT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/leg1NxtPmtDate
leg2NxtPmtAmt
decimal1400in_leg2_nxt_pmt_amtNHOLDINGDBOLOT_LEVEL_POSITIONLEG2_NXT_PMT_AMTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/leg2NxtPmtAmt
leg2NxtPmtDate
date1399in_leg2_nxt_pmt_dateSHOLDINGDBOLOT_LEVEL_POSITIONLEG2_NXT_PMT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/leg2NxtPmtDate
lastSaleSettle
date13998in_last_sale_settleSHOLDINGDBOPOSITION_COST_LOTLAST_SALE_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastSaleSettle
locationCode
string13039in_location_codeSHOLDINGDBOLOT_LEVEL_POSITIONLOCATION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/locationCode
lastSaleTrade
date13997in_last_sale_tradeSHOLDINGDBOPOSITION_COST_LOTLAST_SALE_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastSaleTrade
managedFl
string13038in_managed_flSHOLDINGDBOLOT_LEVEL_POSITIONMANAGED_FLCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/managedFl
marketValueIncome
decimal9426in_market_value_incomeNHOLDINGDBOLOT_LEVEL_POSITIONMARKET_VALUE_INCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncome
netcashflwsNxtPmt
decimal


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmt
netcashflwsNxtPmtDate
date1373in_netcashflws_nxt_pmt_dateSHOLDINGDBOLOT_LEVEL_POSITIONNETCASHFLWS_NXT_PMT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmtDate
netcashflwsNxtPmtDate2
date1402in_netcashflws_nxt_pmtSHOLDINGDBOLOT_LEVEL_POSITIONNETCASHFLWS_NXT_PMTDATEEagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmtDate2
otherCharges
decimal51in_other_chargesNHOLDINGDBOPOSITION_COST_LOTOTHER_CHARGESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/otherCharges
originalAcquisitionCostBase
decimal3746in_orig_acq_cost_baseNHOLDINGDBOPOSITION_COST_LOTORIG_ACQ_COST_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionCostBase
originalAcquisitionCostLocal
decimal3747in_orig_acq_cost_localNHOLDINGDBOPOSITION_COST_LOTORIG_ACQ_COST_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionCostLocal
originalBuiltInGlMktDisc
decimal10915in_orig_builtin_gl_mkt_discNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_MKT_DISCNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlMktDisc
originalBuiltInGlCurrency
decimal10912in_orig_builtin_gl_currencyNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_CURRENCYNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlCurrency
originalBuiltInGlDeferred
decimal10913in_orig_builtin_gl_deferredNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_DEFERREDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlDeferred
originalBuiltInGlOid
decimal10914in_orig_builtin_gl_oidNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_OIDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlOid
originalBuiltInGlSecurity
decimal9762in_orig_builtin_gl_secNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_SECNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlSecurity
originalTradePrice
decimal10906in_orig_trade_priceNHOLDINGDBOLOT_LEVEL_POSITIONORIG_TRADE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalTradePrice
originalSourceCode
string9143in_original_source_codeSHOLDINGDBOLOT_LEVEL_POSITIONORIGINAL_SOURCE_CODEVARCHAR2(25)EagleML/warehouseTransaction/warehouseOpenLot/originalSourceCode
originalAcquisitionDate
date216in_orig_acq_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_ACQ_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionDate
originalFace
decimal41in_orig_faceNHOLDINGDBOLOT_LEVEL_POSITIONORIG_FACENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalFace
origLotNumber
string151in_orig_lot_numberSHOLDINGDBOLOT_LEVEL_POSITIONORIG_LOT_NUMBERVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/origLotNumber
origOpenSettleDate
date154in_orig_open_settle_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_OPEN_SETTLE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/origOpenSettleDate
origEventId
string457in_orig_event_idSHOLDINGDBOLOT_LEVEL_POSITIONORIG_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/origEventId
performanceFlow
string4597in_performance_valueNHOLDINGDBOLOT_LEVEL_POSITIONPERFORMANCE_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/performanceFlow
performancePrice
decimal4598in_performance_priceNHOLDINGDBOLOT_LEVEL_POSITIONPERFORMANCE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/performancePrice
performanceFlag
YesNoOptionEnum9985in_perform_flagSHOLDINGDBOPOSITIONPERFORM_FLAGCHAR(2)EagleML/warehouseTransaction/warehouseOpenLot/performanceFlag
price
decimal481in_priceNHOLDINGDBOLOT_LEVEL_POSITIONPRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/price
smInactiveFlag
YesNoOptionEnum11043in_sm_inactive_flagSnot stored in DB - needed for resolution logics
EagleML/warehouseTransaction/warehouseOpenLot/smInactiveFlag
purchaseQuantity
decimal159in_purchase_quantityNHOLDINGDBOLOT_LEVEL_POSITIONPURCHASE_QUANTITYNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchaseQuantity
purYld
decimal75in_pur_yldNHOLDINGDBOLOT_LEVEL_POSITIONPUR_YLDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purYld
pledgeFlag
YesNoOptionEnum13046in_pledge_flagSHOLDINGDBOLOT_LEVEL_POSITIONPLEDGE_FLAGCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/pledgeFlag
prYrAccrIncome
decimal5801in_pr_yr_accr_incomeNHOLDINGDBOLOT_LEVEL_POSITIONPR_YR_ACCR_INCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/prYrAccrIncome
purchAccruedInterestAmt
decimal10736in_purch_accrued_interest_amtNHOLDINGDBOLOT_LEVEL_POSITIONPURCH_ACCRUED_INTEREST_AMTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchAccruedInterestAmt
reason
string56in_reason_codeSHOLDINGDBOLOT_LEVEL_POSITIONREASON_CODEVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/reason
recParOrShares
decimal122in_rec_par_or_sharesNHOLDINGDBOLOT_LEVEL_POSITIONREC_PAR_OR_SHARESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/recParOrShares
registrationCode
string13040in_registration_codeSHOLDINGDBOLOT_LEVEL_POSITIONREGISTRATION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/registrationCode
reinvestCode
string13045in_reinvest_codeSHOLDINGDBOLOT_LEVEL_POSITIONREINVEST_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/reinvestCode
restrictionCode
string13041in_restriction_codeSHOLDINGDBOLOT_LEVEL_POSITIONRESTRICTION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/restrictionCode
statPremDiscInd
string13049in_stat_prem_disc_indSHOLDINGDBOPOSITION_COST_LOTSTAT_PREM_DISC_INDCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/statPremDiscInd
statSettle
date13994in_stat_settleSHOLDINGDBOPOSITION_COST_LOTSTAT_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/statSettle
statTrade
date13993in_stat_tradeSHOLDINGDBOPOSITION_COST_LOTSTAT_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/statTrade
stateAcquisitionDate
date3863in_state_acquisition_dateSHOLDINGDBOLOT_LEVEL_POSITIONSTATE_ACQUISITION_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/stateAcquisitionDate
taxAcquisitionDate
date3864in_tax_acquisition_dateSHOLDINGDBOLOT_LEVEL_POSITIONTAX_ACQUISITION_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/taxAcquisitionDate
taxPremDiscInd
string13050in_tax_prem_disc_indSHOLDINGDBOPOSITION_COST_LOTTAX_PREM_DISC_INDCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/taxPremDiscInd
taxSettle
date13996in_tax_settleSHOLDINGDBOPOSITION_COST_LOTTAX_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/taxSettle
taxStatus
string1143in_tax_statusSHOLDINGDBOLOT_LEVEL_POSITIONTAX_STATUSCHAR(10)EagleML/warehouseTransaction/warehouseOpenLot/taxStatus
taxTrade
date13995in_tax_tradeSHOLDINGDBOPOSITION_COST_LOTTAX_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/taxTrade
termIndicator
decimal8133in_term_indicatorSHOLDINGDBOLOT_LEVEL_POSITIONTERM_INDICATORNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/termIndicator
intReceived
decimal475in_int_receivedNHOLDINGDBOLOT_LEVEL_POSITIONINT_RECEIVEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/intReceived
income
decimal588in_incomeNHOLDINGDBOLOT_LEVEL_POSITIONINCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/income
votingAuthorityCode
string13043in_voting_authority_codeSHOLDINGDBOLOT_LEVEL_POSITIONVOTING_AUTHORITY_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/votingAuthorityCode
clientId
string1632in_client_idSHOLDINGDBOLOT_LEVEL_POSITIONCLIENT_IDVARCHAR2(20)EagleML/warehouseTransaction/warehouseOpenLot/clientId
covFlag
YesNoOptionEnum2819in_cov_flagSHOLDINGDBOLOT_LEVEL_POSITIONCOV_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/covFlag
eventSubPriority
integer2862in_event_sub_priorityNHOLDINGDBOLOT_LEVEL_POSITIONEVENT_SUB_PRIORITYNUMBER(38)EagleML/warehouseTransaction/warehouseOpenLot/eventSubPriority
factor
decimal91in_factorNHOLDINGDBOPOSITION_COST_LOTFACTORNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/factor
ioIssuerAlias
string1147in_io_issuer_aliasSHOLDINGDBOLOT_LEVEL_POSITIONIO_ISSUER_ALIASVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/ioIssuerAlias
ioIssuerId
string1144in_io_issuer_idSHOLDINGDBOLOT_LEVEL_POSITIONIO_ISSUER_IDVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/ioIssuerId
origAcctDate
date31in_orig_acct_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_ACCT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/origAcctDate
origMonthlyAcctDate
date5022in_orig_monthly_acct_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_MONTHLY_ACCT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/origMonthlyAcctDate
parOrShares
decimal163in_par_or_sharesNHOLDINGDBOLOT_LEVEL_POSITIONPAR_OR_SHARESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/parOrShares
originalQuantity
decimal


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/originalQuantity
pendingTradeId
integer3696in_pending_trade_idNHOLDINGDBOLOT_LEVEL_POSITIONPENDING_TRADE_ID
EagleML/warehouseTransaction/warehouseOpenLot/pendingTradeId
qtyWashSaleEligible
decimal405in_qty_wash_sale_eligibleNHOLDINGDBOLOT_LEVEL_POSITIONQTY_WASH_SALE_ELIGIBLENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/qtyWashSaleEligible
strategy
string2514in_strategy_idSHOLDINGDBOLOT_LEVEL_POSITIONSTRATEGY_IDVARCHAR2(20)EagleML/warehouseTransaction/warehouseOpenLot/strategy
tradeYield
decimal9430in_trade_yieldNHOLDINGDBOLOT_LEVEL_POSITIONTRADE_YIELDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/tradeYield
washSaleEligibleInd
string59in_wash_sale_eligible_indSHOLDINGDBOLOT_LEVEL_POSITIONWASH_SALE_ELIGIBLE_INDICATORCHAR(2)EagleML/warehouseTransaction/warehouseOpenLot/washSaleEligibleInd
aiaNetB
decimal11275in_aia_net_bNHOLDINGDBOPOSITION_COST_LOTAIA_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/aiaNetB
aiaNetL
decimal11149in_aia_net_lNHOLDINGDBOPOSITION_COST_LOTAIA_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/aiaNetL
buySellFlag
normalizedString3702in_buy_sell_flagSHOLDINGDBOPOSITION_COST_LOTBUY_SELL_FLAGVARCHAR2(4)EagleML/warehouseTransaction/warehouseOpenLot/buySellFlag
bookValue
decimal4602in_book_valueNHOLDINGDBOLOT_LEVEL_POSITIONBOOK_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/bookValue
bookValueLocal
decimal4601in_book_value_localNHOLDINGDBOLOT_LEVEL_POSITIONBOOK_VALUE_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/bookValueLocal
cpNetB
decimal11245in_cp_net_bNHOLDINGDBOPOSITION_COST_LOTCP_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/cpNetB
cpNetL
decimal11119in_cp_net_lNHOLDINGDBOPOSITION_COST_LOTCP_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/cpNetL
creditLossB
decimal2784in_credit_loss_bNHOLDINGDBOPOSITION_COST_LOTCREDIT_LOSS_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/creditLossB
creditLossL
decimal2783in_credit_loss_lNHOLDINGDBOPOSITION_COST_LOTCREDIT_LOSS_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/creditLossL
costBasisType
string24in_cost_basis_typeSHOLDINGDBOPOSITION_COST_LOTCOST_BASIS_TYPEVARCHAR2(2)EagleML/warehouseTransaction/warehouseOpenLot/costBasisType
futureFeeNetB
decimal116in_future_fee_net_bNHOLDINGDBOPOSITION_COST_LOTFUTURE_FEE_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/futureFeeNetB
futureFeeNetL
decimal11365in_future_fee_net_lNHOLDINGDBOPOSITION_COST_LOTFUTURE_FEE_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/futureFeeNetL
impairmentLtdBase
decimal2701in_impairment_ltd_baseNHOLDINGDBOPOSITION_COST_LOTIMPAIRMENT_LTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/impairmentLtdBase
impairmentLtdLocal
decimal2700in_impairment_ltd_localNHOLDINGDBOPOSITION_COST_LOTIMPAIRMENT_LTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/impairmentLtdLocal
mbaNetB
decimal11251in_mba_net_bNHOLDINGDBOPOSITION_COST_LOTMBA_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/mbaNetB
mbaNetL
decimal11125in_mba_net_lNHOLDINGDBOPOSITION_COST_LOTMBA_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/mbaNetL
naiaNetB
decimal11343in_naia_net_bNHOLDINGDBOPOSITION_COST_LOTNAIA_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/naiaNetB
naiaNetL
decimal11342in_naia_net_lNHOLDINGDBOPOSITION_COST_LOTNAIA_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/naiaNetL
nonCreditLossB
decimal2705in_non_credit_loss_bNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossB
nonCreditLossL
decimal2704in_non_credit_loss_lNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossL
adjustedShares
decimal4972in_adjusted_sharesNHOLDINGDBOLOT_LEVEL_POSITIONADJUSTED_SHARESNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/adjustedShares
baseGaapMarketValue
decimal9281in_base_gaap_market_valueNHOLDINGDBOPOSITION_COST_LOTBASE_GAAP_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/baseGaapMarketValue
baseStatMarketValue
decimal9290in_base_stat_market_valueNHOLDINGDBOPOSITION_COST_LOTBASE_STAT_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/baseStatMarketValue
cashEquivalents
decimal64in_cash_equivalentsNHOLDINGDBOLOT_LEVEL_POSITIONCASH_EQUIVALENTSNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/cashEquivalents
cirBrkFees
decimal255in_cir_brk_feesNHOLDINGDBOLOT_LEVEL_POSITIONCIR_BRK_FEESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/cirBrkFees
closeOidIncome
decimal5686in_cls_oid_incomeNHOLDINGDBOLOT_LEVEL_POSITIONCLS_OID_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeOidIncome
closeOidIncomeLocal
decimal5685in_cls_oid_income_localNHOLDINGDBOLOT_LEVEL_POSITIONCLS_OID_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeOidIncomeLocal
closeTipsIncomeLocal
decimal4538in_cls_tips_income_localNHOLDINGDBOLOT_LEVEL_POSITIONCLS_TIPS_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLocal
closeTipsIncome
decimal4539in_cls_tips_incomeNHOLDINGDBOLOT_LEVEL_POSITIONCLS_TIPS_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncome
deferredIncomeTotalPtdB
decimal7980in_deferred_income_total_ptd_bNHOLDINGDBOPOSITION_COST_LOTDEFERRED_INCOME_TOTAL_PTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/deferredIncomeTotalPtdB
deferredIncomeTotalPtdL
decimal7979in_deferred_income_total_ptd_lNHOLDINGDBOPOSITION_COST_LOTDEFERRED_INCOME_TOTAL_PTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/deferredIncomeTotalPtdL
deltaAdjQty
decimal4987in_delta_adj_qtyNHOLDINGDBOLOT_LEVEL_POSITIONDELTA_ADJ_QTYNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/deltaAdjQty
dlta
decimal1090in_dltaNHOLDINGDBOLOT_LEVEL_POSITIONDLTANUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/dlta
expoPrice
decimal9164in_expo_priceNHOLDINGDBOLOT_LEVEL_POSITIONEXPO_PRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/expoPrice
earnThruDate
date4763in_earn_thru_dateNHOLDINGDBOLOT_LEVEL_POSITIONEARN_THRU_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/earnThruDate
execBrkFees
decimal266in_exec_brk_feesNHOLDINGDBOLOT_LEVEL_POSITIONEXEC_BRK_FEESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/execBrkFees
fedTaxCostValue
decimal3878in_fed_tax_cost_valueNHOLDINGDBOLOT_LEVEL_POSITIONFED_TAX_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/fedTaxCostValue
gaapUnitBookValue
decimal3130in_gaap_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTGAAP_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapUnitBookValue
gaapUnitCost
decimal125in_gaap_unit_costNHOLDINGDBOPOSITION_COST_LOTGAAP_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapUnitCost
gaapBookValue
decimal9279in_gaap_book_valueNHOLDINGDBOPOSITION_COST_LOTGAAP_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapBookValue
gaapCostValue
decimal129in_gaap_cost_valueNHOLDINGDBOPOSITION_COST_LOTGAAP_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapCostValue
hedgedCusip
string606in_hedged_cusipSHOLDINGDBOLOT_LEVEL_POSITIONHEDGED_CUSIPVARCHAR2(12)EagleML/warehouseTransaction/warehouseOpenLot/hedgedCusip
hedgeTrading
string656in_hedge_tradingSHOLDINGDBOLOT_LEVEL_POSITIONHEDGE_TRADINGVARCHAR2(10)EagleML/warehouseTransaction/warehouseOpenLot/hedgeTrading
interestEarned
decimal465in_interest_earnedNHOLDINGDBOLOT_LEVEL_POSITIONINTEREST_EARNEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/interestEarned
lastSettlementDate
date1223in_last_settlement_dateSHOLDINGDBOLOT_LEVEL_POSITIONLAST_SETTLEMENT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastSettlementDate
localGaapCostValue
decimal128in_local_gaap_cost_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapCostValue
localGaapUnitCost
decimal124in_local_gaap_unit_costNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapUnitCost
localGaapBookValue
decimal9280in_local_gaap_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapBookValue
localGaapUnitBookValue
decimal9309in_local_gaap_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapUnitBookValue
localGaapMarketValue
decimal9314in_local_gaap_market_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapMarketValue
localTaxUnitBookValue
decimal46in_local_tax_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxUnitBookValue
localStatUnitCost
decimal161in_local_stat_unit_costNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatUnitCost
localStatBookValue
decimal9292in_local_stat_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatBookValue
localStatCostValue
decimal9641in_local_stat_cost_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatCostValue
localStatMarketValue
decimal9318in_local_stat_market_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatMarketValue
localStatUnitBookValue
decimal9293in_local_stat_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatUnitBookValue
localTaxBookValue
decimal2744in_local_tax_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxBookValue
localTaxCostValue
decimal3879in_local_tax_cost_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxCostValue
localTaxUnitCost
decimal3874in_local_tax_unit_costNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxUnitCost
nonCreditLossAmortLtdB
decimal2835in_non_credit_loss_amort_ltd_bNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_AMORT_LTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossAmortLtdB
nonCreditLossAmortLtdL
decimal2834in_non_credit_loss_amort_ltd_lNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_AMORT_LTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossAmortLtdL
oidPtdBase
decimal593in_oid_ptd_baseNHOLDINGDBOPOSITION_COST_LOTOID_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidPtdBase
oidPtdLocal
decimal578in_oid_ptd_localNHOLDINGDBOPOSITION_COST_LOTOID_PTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidPtdLocal
oidLtdIncomeLocal
decimal575in_oid_ltd_income_localNHOLDINGDBOLOT_LEVEL_POSITIONOID_LTD_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidLtdIncomeLocal
oidLtdIncomeBase
decimal590in_oid_ltd_incomeNHOLDINGDBOLOT_LEVEL_POSITIONOID_LTD_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidLtdIncomeBase
openMktPrice
decimal160in_open_mkt_priceNHOLDINGDBOLOT_LEVEL_POSITIONOPEN_MKT_PRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/openMktPrice
origAccrPtdBase
decimal9630in_orig_accr_ptd_baseNHOLDINGDBOPOSITION_COST_LOTORIG_ACCR_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/origAccrPtdBase
origSoldInterestBase
decimal9631in_orig_sold_interest_baseNHOLDINGDBOPOSITION_COST_LOTORIG_SOLD_INTEREST_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/origSoldInterestBase
origTradedInterestBase
decimal9632in_orig_traded_interest_baseNHOLDINGDBOPOSITION_COST_LOTORIG_TRADED_INTEREST_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/origTradedInterestBase
originalCostAmount
decimal162in_original_cost_amountNHOLDINGDBOLOT_LEVEL_POSITIONORIGINAL_COST_AMOUNTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalCostAmount
payEpAccrued
decimal2881in_pay_ep_accruedNHOLDINGDBOLOT_LEVEL_POSITIONPAY_EP_ACCRUEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/payEpAccrued
payRecInd
string4590in_pay_rec_indSHOLDINGDBOPOSITION_COST_LOTPAY_REC_INDVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/payRecInd
posnFullyEarned
string8383in_posn_fully_earnedSHOLDINGDBOPOSITION_COST_LOTPOSN_FULLY_EARNEDVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/posnFullyEarned
purchasePrincipalBase
decimal256in_purchase_principal_baseNHOLDINGDBOLOT_LEVEL_POSITIONPURCHASE_PRINCIPAL_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchasePrincipalBase
purchasePrincipalLocal
decimal254in_purchase_principal_localNHOLDINGDBOLOT_LEVEL_POSITIONPURCHASE_PRINCIPAL_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchasePrincipalLocal
pv01total
decimal5839in_pv01totalNHOLDINGDBOLOT_LEVEL_POSITIONPV01TOTALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/pv01total
preTaxAdjYld
decimal5767in_pre_tax_adj_yldNHOLDINGDBOLOT_LEVEL_POSITIONPRE_TAX_ADJ_YLDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/preTaxAdjYld
recEpAccrued
decimal2880in_rec_ep_accruedNHOLDINGDBOLOT_LEVEL_POSITIONREC_EP_ACCRUEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/recEpAccrued
statCostValue
decimal166in_stat_cost_valueNHOLDINGDBOPOSITION_COST_LOTSTAT_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statCostValue
soldInterestBase
decimal8953in_interest_sold_baseNHOLDINGDBOLOT_LEVEL_POSITIONINTEREST_SOLD_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/soldInterestBase
scrubFlag
YesNoOptionEnum4569in_scrub_flagSHOLDINGDBOLOT_LEVEL_POSITIONSCRUB_FLAGCHAR(2)EagleML/warehouseTransaction/warehouseOpenLot/scrubFlag
sourceInternalAssetId
string13047in_source_internal_asset_idSHOLDINGDBOLOT_LEVEL_POSITIONSOURCE_INTERNAL_ASSET_IDVARCHAR2(30)EagleML/warehouseTransaction/warehouseOpenLot/sourceInternalAssetId
statBookValue
decimal9289in_stat_book_valueNHOLDINGDBOPOSITION_COST_LOTSTAT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statBookValue
statUnitBookValue
decimal9308in_stat_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTSTAT_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statUnitBookValue
soldInterestLocal
decimal8952in_interest_soldNHOLDINGDBOLOT_LEVEL_POSITIONINTEREST_SOLDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/soldInterestLocal
statUnitCost
decimal9291in_stat_unit_costNHOLDINGDBOPOSITION_COST_LOTSTAT_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statUnitCost
stateCostValue
decimal11985in_state_cost_valueNHOLDINGDBOLOT_LEVEL_POSITIONSTATE_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/stateCostValue
swapAccrMethod
string1184in_swap_accr_methodSHOLDINGDBOPOSITION_COST_LOTSWAP_ACCR_METHODVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/swapAccrMethod
totalUnrealizedGainLossLocal
decimal489in_local_unrealized_glNHOLDINGDBOLOT_LEVEL_POSITIONLOCAL_UNREALIZED_GLNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/totalUnrealizedGainLossLocal
totalUnrealizedGainLossBase
decimal492in_base_unrealized_glNHOLDINGDBOLOT_LEVEL_POSITIONBASE_UNREALIZED_GLNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/totalUnrealizedGainLossBase
tipsPtdBase
decimal4447in_tips_ptd_baseNHOLDINGDBOPOSITION_COST_LOTTIPS_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/tipsPtdBase
tipsPtdLocal
decimal4442in_tips_ptd_localNHOLDINGDBOPOSITION_COST_LOTTIPS_PTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/tipsPtdLocal
taxBookValue
decimal3881in_tax_book_valueNHOLDINGDBOPOSITION_COST_LOTTAX_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxBookValue
taxCostValue
decimal2726in_tax_cost_valueNHOLDINGDBOPOSITION_COST_LOTTAX_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxCostValue
taxUnitBookValue
decimal2727in_tax_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTTAX_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxUnitBookValue
taxUnitCost
decimal9311in_tax_unit_costNHOLDINGDBOPOSITION_COST_LOTTAX_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxUnitCost
tradeFxRate
decimal79,751in_trade_fx_rateNHOLDINGDBOLOT_LEVEL_POSITIONTRADE_FX_RATENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/tradeFxRate
undPrice
decimal9163in_und_priceNHOLDINGDBOLOT_LEVEL_POSITIONUND_PRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/undPrice
uniqueAssetFlag
YesNoOptionEnum13042in_unique_asset_flagSHOLDINGDBOLOT_LEVEL_POSITIONUNIQUE_ASSET_FLAGCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/uniqueAssetFlag
bankAlias
integer1864,16in_bank_aliasNHOLDINGDBOPOSITION_COST_LOTBANK_ALIASNUMBEREagleML/warehouseTransaction/warehouseOpenLot/bankAlias
batchEventId
string701in_batch_event_idSHOLDINGDBOLOT_LEVEL_POSITIONBATCH_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/batchEventId
brokerCode
string88in_broker_codeSHOLDINGDBOLOT_LEVEL_POSITIONBROKER_CODEVARCHAR2(12)EagleML/warehouseTransaction/warehouseOpenLot/brokerCode
clearingBrokerCode
string1237in_clearing_broker_codeSHOLDINGDBOLOT_LEVEL_POSITIONCLEARING_BROKER_CODECHAR(12)EagleML/warehouseTransaction/warehouseOpenLot/clearingBrokerCode
commissionAmount
decimal47in_commissionNHOLDINGDBOLOT_LEVEL_POSITIONCOMMISSIONNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/commissionAmount
lotNumber
string1790in_lot_numberSHOLDINGDBOLOT_LEVEL_POSITIONLOT_NUMBERCHAR(10)EagleML/warehouseTransaction/warehouseOpenLot/lotNumber
masterTicketNumber
string761in_master_ticket_numberSHOLDINGDBOLOT_LEVEL_POSITIONMASTER_TICKET_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/masterTicketNumber
monthEndAccountingDate
date4733in_monthly_accounting_dateSHOLDINGDBOLOT_LEVEL_POSITIONMONTHLY_ACCOUNTING_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/monthEndAccountingDate
secFee
decimal3752in_sec_feesNHOLDINGDBOPOSITION_COST_LOTSEC_FEESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/secFee
settlementDate
date37in_settlement_dateSHOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/settlementDate
tradeDate
date35in_trade_dateSHOLDINGDBOLOT_LEVEL_POSITIONTRADE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/tradeDate
transactionCode
string3821in_trans_codeSHOLDINGDBOPOSITION_COST_LOTTRANS_CODEVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/transactionCode
userChar1
string1887in_user_char1SHOLDINGDBOLOT_LEVEL_POSITIONUSER_CHAR1VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userChar1
userChar2
string1888in_user_char2SHOLDINGDBOLOT_LEVEL_POSITIONUSER_CHAR2VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userChar2
userChar3
string1889in_user_char3SHOLDINGDBOLOT_LEVEL_POSITIONUSER_CHAR3VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userChar3
userDefinedFloat1
decimal1890in_user_float1NHOLDINGDBOLOT_LEVEL_POSITIONUSER_FLOAT1NUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat1
userDefinedFloat2
decimal1891in_user_float2NHOLDINGDBOLOT_LEVEL_POSITIONUSER_FLOAT2NUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat2
userDefinedFloat3
decimal1892in_user_float3NHOLDINGDBOLOT_LEVEL_POSITIONUSER_FLOAT3NUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat3
pclUserDate1
date32in_pcl_user_date1SHOLDINGDBOPOSITION_COST_LOTPCL_USER_DATE1DATEEagleML/warehouseTransaction/warehouseOpenLot/pclUserDate1
pclUserDate2
date30in_pcl_user_date2SHOLDINGDBOPOSITION_COST_LOTPCL_USER_DATE2DATEEagleML/warehouseTransaction/warehouseOpenLot/pclUserDate2
pclUserDate3
date164in_pcl_user_date3SHOLDINGDBOPOSITION_COST_LOTPCL_USER_DATE3DATEEagleML/warehouseTransaction/warehouseOpenLot/pclUserDate3
userGroup1
string63in_user_group1SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP1CHAR(10)EagleML/warehouseTransaction/warehouseOpenLot/userGroup1
userGroup2
string17,1891in_user_group2SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP2CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup2
userGroup3
string1461in_user_group3SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP3CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup3
userGroup4
string1472in_user_group4SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP4CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup4
userGroup5
string1473in_user_group5SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP5CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup5
userGroup6
string768in_user_group6SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP6CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup6
userGroup7
string1462in_user_group7SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP7CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup7
userGroup8
string9989in_user_group8SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP8VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup8
userGroup9
string9990in_user_group9SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP9VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup9
userGroup10
string9991in_user_group10SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP10VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup10
userGroup11
string9992in_user_group11SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP11VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup11
userGroup12
string9993in_user_group12SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP12VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup12
userGroup13
string9994in_user_group13SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP13VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup13
userGroup14
string9995in_user_group14SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP14VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup14
userGroup15
string9996in_user_group15SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP15VARCHAR2(35)EagleML/warehouseTransaction/warehouseOpenLot/userGroup15
userGroup16
string9997in_user_group16SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP16VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userGroup16
userGroup17
string9998in_user_group17SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP17VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup17
userGroup18
string9999in_user_group18SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP18VARCHAR2(35)EagleML/warehouseTransaction/warehouseOpenLot/userGroup18
settledGaapCostValue
(supported in v17)
decimal5589

HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_GAAP_COST_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledGaapCostValue
settledLocalGaapCostValue
(supported in v17)
decimal5590

HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_LOCAL_GAAP_COST_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledLocalGaapCostValue
settledLocalMarketValue
(supported in v17)
decimal5591

HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_LOCAL_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledLocalMarketValue
settledMarketValue
(supported in v17)
decimal5592

HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledMarketValue
settlementDatePosition
(supported in v17)
decimal5593

HOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATE_POSITIONNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePosition
settlementDatePositionLocal
(supported in v17)
decimal5594

HOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATE_POSITION_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionLocal
settlementDatePositionCost
(supported in v17)
decimal5595

HOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATE_POSITION_COSTNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionCost
lotLevelPositionId
integer


HOLDINGDBOLOT_LEVEL_POSITIONLOT_LEVEL_POSITIONNUMBEREagleML/warehouseTransaction/warehouseOpenLot/lotLevelPositionId
lotLevelCostPositionId
integer


HOLDINGDBOPOSITION_COST_LOTPOSITION_LOT_IDNUMBEREagleML/warehouseTransaction/warehouseOpenLot/lotLevelCostPositionId
starQuantity
(supported in v17)
decimal5596

HOLDINGDBOLOT_LEVEL_POSITIONSTAR_QUANTITYNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/starQuantity
starMarketValueLocal
(supported in v17)
decimal5597

HOLDINGDBOLOT_LEVEL_POSITIONSTAR_MARKET_VALUE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/starMarketValueLocal
starMarketValue
(supported in v17)
decimal5598

HOLDINGDBOLOT_LEVEL_POSITIONSTAR_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/starMarketValue
processingIlbLtdLocal
decimal5599

HOLDINGDBOLOT_LEVEL_POSITIONPROCESSING_ILB_LTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdLocal
processingIlbLtdBase
decimal5600

HOLDINGDBOLOT_LEVEL_POSITIONPROCESSING_ILB_LTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdBase
incomeBalanceLocal
decimal5601

HOLDINGDBOPOSITION_COST_LOTINCOME_BALANCE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/incomeBalanceLocal
incomeBalance
decimal5602

HOLDINGDBOPOSITION_COST_LOTINCOME_BALANCENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/incomeBalance
principalBalanceLocal
decimal5603

HOLDINGDBOPOSITION_COST_LOTPRINCIPAL_BALANCE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/principalBalanceLocal
principalBalance
decimal5604

HOLDINGDBOPOSITION_COST_LOTPRINCIPAL_BALANCENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/principalBalance
orderNumber
string5611

HOLDINGDBOLOT_LEVEL_POSITIONORDER_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/orderNumber
priceMethod
normalizedString5613

HOLDINGDBOLOT_LEVEL_POSITIONPRICE_METHODVARCHAR2(4)EagleML/warehouseTransaction/warehouseOpenLot/priceMethod
regulatoryIntent
normalizedString5614

HOLDINGDBOLOT_LEVEL_POSITIONREGULATORY_INTENTVARCHAR2(3)EagleML/warehouseTransaction/warehouseOpenLot/regulatoryIntent
holdingTerm
normalizedString5629

HOLDINGDBOLOT_LEVEL_POSITIONHOLDING_TERMVARCHAR2(2)EagleML/warehouseTransaction/warehouseOpenLot/holdingTerm
positionId
integer


HOLDINGDBOLOT_LEVEL_POSITIONPOSITION_IDNUMBEREagleML/warehouseTransaction/warehouseOpenLot/positionId
positionDetailIdExtract onlyinteger


HOLDINGDBOPOSITION_DETAILPOSITION_DETAIL_IDNUMBEREagleML/warehouseTransaction/warehouseOpenLot/positionDetailId
shareParValueExtract onlydecimal


HOLDINGDBOPOSITION_DETAILSHARE_PAR_VALUE
EagleML/warehouseTransaction/warehouseOpenLot/shareParValue
accrualRateExtract onlydecimal


ESTARESTAR_INCOME_ACTIVITYCOUPON
EagleML/warehouseTransaction/warehouseOpenLot/accrualRate
calcMasterTransactionId

Extract only
(see more details)

string


CALC_MASTER_TRANSACTION_ID - concatenated value
ACCT_BASIS#ENTITY_ID#SECURITY_ALIAS#LONG_SHORT_IND#ORIG_LOT_NUMBER		EagleML/warehouseTransaction/warehouseOpenLot/calcMasterTransactionId
bookCostLocal
decimal17039in_book_cost_l
HOLDINGDBOPOSITION_COST_LOTBOOK_COST_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/bookCostLocal
bookCostBase
decimal17038in_book_cost_b
HOLDINGDBOPOSITION_COST_LOTBOOK_COST_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/bookCostBase
bookPriceLocalExtract onlydecimal17478

HOLDINGDBOLOT_LEVEL_POSITIONBOOK_PRICE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/bookPriceLocal
bookPriceBaseExtract onlydecimal17477

HOLDINGDBOLOT_LEVEL_POSITIONBOOK_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/bookPriceBase
sleeveId
(supported in ORA, EagleML v17 or higher)

decimal1606in_sleeve_id
HOLDINGDBOLOT_LEVEL_POSITIONSLEEVE_IDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/sleeveId
originalAcquisitionNotionalCostBaseExtract onlydecimal
in_orig_acq_cost_notional_base
HOLDINGDBOPOSITION_COST_LOTORIG_ACQ_NOTIONAL_COST_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionNotionalCostBase
originalAcquisitionNotionalCostLocalExtract onlydecimal
in_orig_acq_cost_notional_local
HOLDINGDBOPOSITION_COST_LOTORIG_ACQ_NOTIONAL_COST_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionNotionalCostLocal
settledOriginalFaceExtract onlydecimal11310

HOLDINGDBOLOT_LEVEL_POSITIONSETTLE_ORIG_FACE
EagleML/warehouseTransaction/warehouseOpenLot/settledOriginalFace
priceDate
date482

HOLDINGDBOPOSITION_DETAILPRICE_DATE
EagleML/warehouseTransaction/warehouseOpenLot/priceDate
custodianPrincipalBalanceBaseExtract onlydecimal18578

HOLDINGDBOLOT_LEVEL_POSITIONCUST_PRINCIPAL_BALANCENUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/custodianPrincipalBalanceBase

custodianPrincipalBalanceLocalExtract onlydecimal18579

HOLDINGDBOLOT_LEVEL_POSITIONCUST_PRINCIPAL_BALANCE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/custodianPrincipalBalanceLocal
custodianPrincipalBalanceLocalExtract onlydecimal18580

HOLDINGDBOLOT_LEVEL_POSITIONCUST_INCOME_BALANCENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/custodianIncomeBalanceBase

custodianIncomeBalanceLocal

Extract onlydecimal18581

HOLDINGDBOLOT_LEVEL_POSITIONCUST_INCOME_BALANCE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/custodianIncomeBalanceLocal
srcSysC Extract onlystring98

HOLDINGDBOLOT_LEVEL_POSITIONSRC_SYS_CVARCHAR2(25)EagleML/warehouseTransaction/warehouseOpenLot/srcSysC
custodianBankCode

Extract only

string1240

RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_CODECHAR(20)EagleML/warehouseTransaction/warehouseOpenLot/custodianBankCode
custodyBankAccountExtract onlystring1660

RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_ACCT_NUMVARCHAR2(30)EagleML/warehouseTransaction/warehouseOpenLot/custodyBankAccount
custodyBankSubaccountExtract onlystring1661

RULESDBOENTITY_CUSTODY_RELATIONSHIPCUSTODY_BANK_SUB_ACCTVARCHAR2(30)EagleML/warehouseTransaction/warehouseOpenLot/custodyBankSubaccount
realEstateUDFReal Estate UDF Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/realEstateUDF/
extendedRatingsModelExtended Ratings Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/extendedRatingsModel/
extendedPortValuationModelExtended Port Valuation Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/extendedPortValuationModel/
washSaleOpenLotWash Sale Open Lot Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/
lotIncomeLot Income Model (see extra data map table) - please note that this table is available only if you use EDS interface/OntologyEagleML/warehouseTransaction/warehouseOpenLot/lotIncome/
costUDFCost UDF Model (see extra data map table) - please note that this table is available only if you use EDS interface/OntologyEagleML/warehouseTransaction/warehouseOpenLot/costUDF/

...