Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »


Note

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

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

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


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/objectType
objectIdOptionalObjectId


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/objectId
objectDescriptionOptionalFeedTypeEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/objectDescription
updateTimestampOptionaldateTime


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


reserved for customizations
EagleML/warehouseTransaction/warehouseOpenLot/customElements
sourceNameOptionalstring1102in_short_descSPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/warehouseTransaction/warehouseOpenLot/sourceName
updateSourceOptionalstring944in_update_sourceSHOLDINGDBOLOT_LEVEL_POSITIONUPDATE_SOURCECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/updateSource
batchCollectErrorsFlagOptionalYesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/batchCollectErrorsFlag
singleRowCommitFlagOptionalYesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/singleRowCommitFlag
linkEventIdOptionalTransactionId28in_link_event_idSHOLDINGDBOLOT_LEVEL_POSITIONLINK_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/linkEventId
localCurrencyOptionalCurrencyCode85in_local_currencySHOLDINGDBOLOT_LEVEL_POSITIONLOCAL_CURRENCYCHAR(3)EagleML/warehouseTransaction/warehouseOpenLot/localCurrency
effectiveDateOptionaldate221in_effective_dateSHOLDINGDBOPOSITION_COST_LOTEFFECTIVE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/effectiveDate
maturityDateOptionaldate


not stored in DB - needed for resolution logics
EagleML/warehouseTransaction/warehouseOpenLot/maturityDate
longShortIndicatorOptional
(see more details)		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/
accountingBasisOptionalstring21IN_ACCOUNTSHOLDINGDBOPOSITIONACCT_BASISVARCHAR2(5)EagleML/warehouseTransaction/warehouseOpenLot/accountingBasis
entityIDLookupSwitchOptionalLookupSwitchEnum989

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/entityIDLookupSwitch
entityNameLookupSwitchOptionalLookupSwitchEnum990

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/entityNameLookupSwitch
securityQueryFlagOptionalYesNoOptionEnum1256

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/securityQueryFlag
sourceLookupSwitchOptionalLookupSwitchEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/sourceLookupSwitch
procedureModeOptional
(see more details)		ProcedureFlagTypeEnum1078in_procedure_modeSnot stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/procedureMode
procedureFlagOptional
(see more details)		ProcedureFlagTypeEnum1076in_mode_flagSnot stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/procedureFlag
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseOpenLot/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/warehouseOpenLot/
baseCurrencyOptionalCurrencyCode86in_base_currencySHOLDINGDBOLOT_LEVEL_POSITIONCURRENCYCHAR(3)EagleML/warehouseTransaction/warehouseOpenLot/baseCurrency
srcIntfcInstOptionaldecimal1168

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/srcIntfcInst
transactionTypeOptionalstring2283in_trans_typeSHOLDINGDBOLOT_LEVEL_POSITIONTRANS_TYPEVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/transactionType
rollupFlagOptionalYesNoOptionEnum


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/rollupFlag
urglSecurityBaseOptionaldecimal491in_unrealized_sec_glNHOLDINGDBOLOT_LEVEL_POSITIONUNREALIZED_SEC_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/urglSecurityBase
urglCurrencyBaseOptionaldecimal493in_unrealized_curr_glNHOLDINGDBOLOT_LEVEL_POSITIONUNREALIZED_CURR_GLNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/urglCurrencyBase
updateDateOptionaldate1106in_update_dateSHOLDINGDBOLOT_LEVEL_POSITIONUPDATE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/updateDate
closeOpenEventIdOptionalTransactionId181

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/closeOpenEventId
closeEventIdOptionalTransactionId182

not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/closeEventId
closeIndexWeightOptionaldecimal4483in_indx_weightNHOLDINGDBOLOT_LEVEL_POSITIONINDX_WEIGHTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/closeIndexWeight
closeTipsIncomeLtdLocalOptionaldecimal4440in_tip_ltd_income_localNHOLDINGDBOLOT_LEVEL_POSITIONTIP_LTD_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdLocal
closeTipsIncomeLtdBaseOptionaldecimal4445in_tip_ltd_incomeNHOLDINGDBOLOT_LEVEL_POSITIONTIP_LTD_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdBase
marketValueLocalOptionaldecimal487in_local_market_valueNHOLDINGDBOLOT_LEVEL_POSITIONLOCAL_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueLocal
marketValueBaseOptionaldecimal488in_market_valueNHOLDINGDBOLOT_LEVEL_POSITIONMARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueBase
marketValueIncomeLocalOptionaldecimal9424in_market_value_income_localNHOLDINGDBOLOT_LEVEL_POSITIONMARKET_VALUE_INCOME_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncomeLocal
notionalMarketValueBaseOptionaldecimal10794in_notional_market_valueNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueBase
notionalUnrealizedGlBaseOptionaldecimal10796in_notional_unrealized_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_UNREALIZED_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlBase
notionalCostLocalOptionaldecimal10791in_notional_cost_localNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_COST_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalCostLocal
notionalCostBaseOptionaldecimal10792in_notional_costNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_COSTNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalCostBase
notionalMarketValueLocalOptionaldecimal10793in_notional_market_value_localNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_MARKET_VALUE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueLocal
notionalUnrealizedGlLocalOptionaldecimal10795in_notional_local_unrealiz_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_LOCAL_UNREALIZED_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlLocal
notionalUnrealizedCurrGlOptionaldecimal10797in_notional_unrealized_curr_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_UNREALIZED_CURR_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedCurrGl
notionalUnrealizedSecGlOptionaldecimal10798in_notional_unrealized_sec_glNHOLDINGDBOLOT_LEVEL_POSITIONNOTIONAL_UNREALIZED_SEC_GLNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedSecGl
sourceLongShortIndOptional
(see more details)		string15in_long_short_indSHOLDINGDBOLOT_LEVEL_POSITIONLONG_SHORT_INDCHAR(4)EagleML/warehouseTransaction/warehouseOpenLot/sourceLongShortInd
settledQuantityOptionaldecimal274in_settle_quantityNHOLDINGDBOLOT_LEVEL_POSITIONSETTLE_QUANTITYNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/settledQuantity
settleLocationOptionalstring43in_settlement_locationSHOLDINGDBOPOSITION_COST_LOTSETTLEMENT_LOCATIONCHAR(12)EagleML/warehouseTransaction/warehouseOpenLot/settleLocation
accountingDateOptionaldate36in_accounting_dateSHOLDINGDBOLOT_LEVEL_POSITIONACCOUNTING_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/accountingDate
amortizedLtdBaseOptionaldecimal595in_amortization_ltd_baseNHOLDINGDBOLOT_LEVEL_POSITIONAMORTIZATION_LTD_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedLtdBase
amortizedLtdLocalOptionaldecimal580in_amortization_ltd_localNHOLDINGDBOLOT_LEVEL_POSITIONAMORTIZATION_LTD_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedLtdLocal
amortizedPtdBaseOptionaldecimal598in_amort_ptd_baseNHOLDINGDBOPOSITION_COST_LOTAMORT_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedPtdBase
amortizedPtdLocalOptionaldecimal583in_amort_ptd_localNHOLDINGDBOPOSITION_COST_LOTAMORT_PTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedPtdLocal
closeAmortizedLocalOptionaldecimal521in_cls_amort_localNHOLDINGDBOLOT_LEVEL_POSITIONCLS_AMORT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeAmortizedLocal
closeAmortizedBaseOptionaldecimal522in_cls_amort_baseNHOLDINGDBOLOT_LEVEL_POSITIONCLS_AMORT_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeAmortizedBase
amortizedCostBaseOptionaldecimal2694in_amortized_costNHOLDINGDBOLOT_LEVEL_POSITIONAMORTIZED_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/amortizedCostBase
accruedInterestTypeOptionalstring3715in_accrued_interest_typeSHOLDINGDBOLOT_LEVEL_POSITIONACCRUED_INTEREST_TYPEVARCHAR2(3)EagleML/warehouseTransaction/warehouseOpenLot/accruedInterestType
accruedLtdBaseOptionaldecimal585in_accr_ltd_baseNHOLDINGDBOPOSITION_COST_LOTACCR_LTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedLtdBase
accruedLtdLocalOptionaldecimal462in_accr_ltd_localNHOLDINGDBOPOSITION_COST_LOTACCR_LTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedLtdLocal
accruedIncomeLocalOptionaldecimal718in_accrued_income_localNHOLDINGDBOLOT_LEVEL_POSITIONACCRUED_INCOME_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedIncomeLocal
accruedIncomeOptionaldecimal726in_accrued_incomeNHOLDINGDBOLOT_LEVEL_POSITIONACCRUED_INCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/accruedIncome
acquisitionCodeOptionalstring13044in_acquisition_codeSHOLDINGDBOLOT_LEVEL_POSITIONACQUISITION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/acquisitionCode
currBuiltInGlSecurityOptionaldecimal9761in_curr_builtin_gl_secNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_SECNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlSecurity
currBuiltInGlCurrencyOptionaldecimal10917in_curr_builtin_gl_currencyNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_CURRENCYNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlCurrency
currBuiltInGlDeferredOptionaldecimal10918in_curr_builtin_gl_deferredNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_DEFERREDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlDeferred
currBuiltInGlOidOptionaldecimal10919in_curr_builtin_gl_oidNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_OIDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlOid
currBuiltInGlMktDiscOptionaldecimal10920in_curr_builtin_gl_mkt_discNHOLDINGDBOLOT_LEVEL_POSITIONCURR_BUILTIN_GL_MKT_DISCNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlMktDisc
currFxRateOptionaldecimal484in_curr_fx_rateNHOLDINGDBOLOT_LEVEL_POSITIONCURR_FX_RATENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/currFxRate
departmentAcquisitionDateOptionaldate7560in_department_acquisition_dateSHOLDINGDBOLOT_LEVEL_POSITIONDEPARTMENT_ACQUISITION_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/departmentAcquisitionDate
expensesOptionaldecimal48in_expensesNHOLDINGDBOLOT_LEVEL_POSITIONEXPENSESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/expenses
exchangeRateOptionaldecimal87in_exchange_rateNHOLDINGDBOLOT_LEVEL_POSITIONEXCHANGE_RATENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/exchangeRate
executionBrokerOptionalstring10987in_execution_brokerSHOLDINGDBOLOT_LEVEL_POSITIONEXECUTION_BROKERVARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/executionBroker
federalTaxCostUnknownOptionalstring1545in_federal_tax_cost_unknownSHOLDINGDBOLOT_LEVEL_POSITIONFEDERAL_TAX_COST_UNKNOWNCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/federalTaxCostUnknown
gaapPremDisIndOptionalstring13048in_gaap_prem_disc_indSHOLDINGDBOPOSITION_COST_LOTGAAP_PREM_DISC_INDCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/gaapPremDisInd
gaapSettleOptionaldate13992in_gaap_settleSHOLDINGDBOPOSITION_COST_LOTGAAP_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/gaapSettle
gaapTradeOptionaldate13991in_gaap_tradeSHOLDINGDBOPOSITION_COST_LOTGAAP_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/gaapTrade
gaapTradeDateOptionaldate9669in_gaap_trade_dateSHOLDINGDBOLOT_LEVEL_POSITIONGAAP_TRADE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/gaapTradeDate
idCostOptionaldecimal247in_id_costNHOLDINGDBOLOT_LEVEL_POSITIONID_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/idCost
incomeDueOptionaldecimal114in_income_dueNHOLDINGDBOLOT_LEVEL_POSITIONINCOME_DUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/incomeDue
intPurchasedOptionaldecimal49in_int_purchasedNHOLDINGDBOLOT_LEVEL_POSITIONINT_PURCHASEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/intPurchased
lastUpdateSrcDateOptionaldate1775in_last_update_src_dateSHOLDINGDBOLOT_LEVEL_POSITIONLAST_UPDATE_SRC_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastUpdateSrcDate
leg1NxtPmtAmtOptionaldecimal1398in_leg1_nxt_pmt_amtNHOLDINGDBOLOT_LEVEL_POSITIONLEG1_NXT_PMT_AMTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/leg1NxtPmtAmt
leg1NxtPmtDateOptionaldate1397in_leg1_nxt_pmt_dateSHOLDINGDBOLOT_LEVEL_POSITIONLEG1_NXT_PMT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/leg1NxtPmtDate
leg2NxtPmtAmtOptionaldecimal1400in_leg2_nxt_pmt_amtNHOLDINGDBOLOT_LEVEL_POSITIONLEG2_NXT_PMT_AMTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/leg2NxtPmtAmt
leg2NxtPmtDateOptionaldate1399in_leg2_nxt_pmt_dateSHOLDINGDBOLOT_LEVEL_POSITIONLEG2_NXT_PMT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/leg2NxtPmtDate
lastSaleSettleOptionaldate13998in_last_sale_settleSHOLDINGDBOPOSITION_COST_LOTLAST_SALE_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastSaleSettle
locationCodeOptionalstring13039in_location_codeSHOLDINGDBOLOT_LEVEL_POSITIONLOCATION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/locationCode
lastSaleTradeOptionaldate13997in_last_sale_tradeSHOLDINGDBOPOSITION_COST_LOTLAST_SALE_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastSaleTrade
managedFlOptionalstring13038in_managed_flSHOLDINGDBOLOT_LEVEL_POSITIONMANAGED_FLCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/managedFl
marketValueIncomeOptionaldecimal9426in_market_value_incomeNHOLDINGDBOLOT_LEVEL_POSITIONMARKET_VALUE_INCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncome
netcashflwsNxtPmtOptionaldate1402in_netcashflws_nxt_pmtSHOLDINGDBOLOT_LEVEL_POSITIONNETCASHFLWS_NXT_PMTDATEEagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmt
netcashflwsNxtPmtDateOptionaldate1373in_netcashflws_nxt_pmt_dateSHOLDINGDBOLOT_LEVEL_POSITIONNETCASHFLWS_NXT_PMT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmtDate
otherChargesOptionaldecimal51in_other_chargesNHOLDINGDBOPOSITION_COST_LOTOTHER_CHARGESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/otherCharges
originalAcquisitionCostBaseOptionaldecimal3746in_orig_acq_cost_baseNHOLDINGDBOPOSITION_COST_LOTORIG_ACQ_COST_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionCostBase
originalAcquisitionCostLocalOptionaldecimal3747in_orig_acq_cost_localNHOLDINGDBOPOSITION_COST_LOTORIG_ACQ_COST_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionCostLocal
originalBuiltInGlMktDiscOptionaldecimal10915in_orig_builtin_gl_mkt_discNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_MKT_DISCNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlMktDisc
originalBuiltInGlCurrencyOptionaldecimal10912in_orig_builtin_gl_currencyNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_CURRENCYNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlCurrency
originalBuiltInGlDeferredOptionaldecimal10913in_orig_builtin_gl_deferredNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_DEFERREDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlDeferred
originalBuiltInGlOidOptionaldecimal10914in_orig_builtin_gl_oidNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_OIDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlOid
originalBuiltInGlSecurityOptionaldecimal9762in_orig_builtin_gl_secNHOLDINGDBOLOT_LEVEL_POSITIONORIG_BUILTIN_GL_SECNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlSecurity
originalTradePriceOptionaldecimal10906in_orig_trade_priceNHOLDINGDBOLOT_LEVEL_POSITIONORIG_TRADE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/originalTradePrice
originalSourceCodeOptionalstring9143in_original_source_codeSHOLDINGDBOLOT_LEVEL_POSITIONORIGINAL_SOURCE_CODEVARCHAR2(25)EagleML/warehouseTransaction/warehouseOpenLot/originalSourceCode
originalAcquisitionDateOptionaldate216in_orig_acq_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_ACQ_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionDate
originalFaceOptionaldecimal41in_orig_faceNHOLDINGDBOLOT_LEVEL_POSITIONORIG_FACENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalFace
origLotNumberOptionalstring151in_orig_lot_numberSHOLDINGDBOLOT_LEVEL_POSITIONORIG_LOT_NUMBERVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/origLotNumber
origOpenSettleDateOptionaldate154in_orig_open_settle_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_OPEN_SETTLE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/origOpenSettleDate
origEventIdOptionalstring457in_orig_event_idSHOLDINGDBOLOT_LEVEL_POSITIONORIG_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/origEventId
performanceFlowOptionalstring4597in_performance_valueNHOLDINGDBOLOT_LEVEL_POSITIONPERFORMANCE_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/performanceFlow
performancePriceOptionaldecimal4598in_performance_priceNHOLDINGDBOLOT_LEVEL_POSITIONPERFORMANCE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/performancePrice
performanceFlagOptionalYesNoOptionEnum9985in_perform_flagSHOLDINGDBOPOSITIONPERFORM_FLAGCHAR(2)EagleML/warehouseTransaction/warehouseOpenLot/performanceFlag
priceOptionaldecimal481in_priceNHOLDINGDBOLOT_LEVEL_POSITIONPRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/price
smInactiveFlagOptionalYesNoOptionEnum11043in_sm_inactive_flagSnot stored in DB - needed for resolution logics
EagleML/warehouseTransaction/warehouseOpenLot/smInactiveFlag
purchaseQuantityOptionaldecimal159in_purchase_quantityNHOLDINGDBOLOT_LEVEL_POSITIONPURCHASE_QUANTITYNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchaseQuantity
purYldOptionaldecimal75in_pur_yldNHOLDINGDBOLOT_LEVEL_POSITIONPUR_YLDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purYld
pledgeFlagOptionalYesNoOptionEnum13046in_pledge_flagSHOLDINGDBOLOT_LEVEL_POSITIONPLEDGE_FLAGCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/pledgeFlag
prYrAccrIncomeOptionaldecimal5801in_pr_yr_accr_incomeNHOLDINGDBOLOT_LEVEL_POSITIONPR_YR_ACCR_INCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/prYrAccrIncome
purchAccruedInterestAmtOptionaldecimal10736in_purch_accrued_interest_amtNHOLDINGDBOLOT_LEVEL_POSITIONPURCH_ACCRUED_INTEREST_AMTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchAccruedInterestAmt
reasonOptionalstring56in_reason_codeSHOLDINGDBOLOT_LEVEL_POSITIONREASON_CODEVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/reason
recParOrSharesOptionaldecimal122in_rec_par_or_sharesNHOLDINGDBOLOT_LEVEL_POSITIONREC_PAR_OR_SHARESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/recParOrShares
registrationCodeOptionalstring13040in_registration_codeSHOLDINGDBOLOT_LEVEL_POSITIONREGISTRATION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/registrationCode
reinvestCodeOptionalstring13045in_reinvest_codeSHOLDINGDBOLOT_LEVEL_POSITIONREINVEST_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/reinvestCode
restrictionCodeOptionalstring13041in_restriction_codeSHOLDINGDBOLOT_LEVEL_POSITIONRESTRICTION_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/restrictionCode
statPremDiscIndOptionalstring13049in_stat_prem_disc_indSHOLDINGDBOPOSITION_COST_LOTSTAT_PREM_DISC_INDCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/statPremDiscInd
statSettleOptionaldate13994in_stat_settleSHOLDINGDBOPOSITION_COST_LOTSTAT_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/statSettle
statTradeOptionaldate13993in_stat_tradeSHOLDINGDBOPOSITION_COST_LOTSTAT_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/statTrade
stateAcquisitionDateOptionaldate3863in_state_acquisition_dateSHOLDINGDBOLOT_LEVEL_POSITIONSTATE_ACQUISITION_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/stateAcquisitionDate
taxAcquisitionDateOptionaldate3864in_tax_acquisition_dateSHOLDINGDBOLOT_LEVEL_POSITIONTAX_ACQUISITION_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/taxAcquisitionDate
taxPremDiscIndOptionalstring13050in_tax_prem_disc_indSHOLDINGDBOPOSITION_COST_LOTTAX_PREM_DISC_INDCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/taxPremDiscInd
taxSettleOptionaldate13996in_tax_settleSHOLDINGDBOPOSITION_COST_LOTTAX_SETTLEDATEEagleML/warehouseTransaction/warehouseOpenLot/taxSettle
taxStatusOptionalstring1143in_tax_statusSHOLDINGDBOLOT_LEVEL_POSITIONTAX_STATUSCHAR(10)EagleML/warehouseTransaction/warehouseOpenLot/taxStatus
taxTradeOptionaldate13995in_tax_tradeSHOLDINGDBOPOSITION_COST_LOTTAX_TRADEDATEEagleML/warehouseTransaction/warehouseOpenLot/taxTrade
termIndicatorOptionaldecimal8133in_term_indicatorSHOLDINGDBOLOT_LEVEL_POSITIONTERM_INDICATORNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/termIndicator
intReceivedOptionaldecimal475in_int_receivedNHOLDINGDBOLOT_LEVEL_POSITIONINT_RECEIVEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/intReceived
incomeOptionaldecimal588in_incomeNHOLDINGDBOLOT_LEVEL_POSITIONINCOMENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/income
votingAuthorityCodeOptionalstring13043in_voting_authority_codeSHOLDINGDBOLOT_LEVEL_POSITIONVOTING_AUTHORITY_CODECHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/votingAuthorityCode
clientIdOptionalstring1632in_client_idSHOLDINGDBOLOT_LEVEL_POSITIONCLIENT_IDVARCHAR2(20)EagleML/warehouseTransaction/warehouseOpenLot/clientId
covFlagOptionalYesNoOptionEnum2819in_cov_flagSHOLDINGDBOLOT_LEVEL_POSITIONCOV_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/covFlag
eventSubPriorityOptionalinteger2862in_event_sub_priorityNHOLDINGDBOLOT_LEVEL_POSITIONEVENT_SUB_PRIORITYNUMBER(38)EagleML/warehouseTransaction/warehouseOpenLot/eventSubPriority
factorOptionaldecimal91in_factorNHOLDINGDBOPOSITION_COST_LOTFACTORNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/factor
ioIssuerAliasOptionalstring1147in_io_issuer_aliasSHOLDINGDBOLOT_LEVEL_POSITIONIO_ISSUER_ALIASVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/ioIssuerAlias
ioIssuerIdOptionalstring1144in_io_issuer_idSHOLDINGDBOLOT_LEVEL_POSITIONIO_ISSUER_IDVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/ioIssuerId
origAcctDateOptionaldate31in_orig_acct_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_ACCT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/origAcctDate
origMonthlyAcctDateOptionaldate5022in_orig_monthly_acct_dateSHOLDINGDBOLOT_LEVEL_POSITIONORIG_MONTHLY_ACCT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/origMonthlyAcctDate
parOrSharesOptionaldecimal163in_par_or_sharesNHOLDINGDBOLOT_LEVEL_POSITIONPAR_OR_SHARESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/parOrShares
originalQuantityOptionaldecimal


not stored in DB
EagleML/warehouseTransaction/warehouseOpenLot/originalQuantity
pendingTradeIdOptionalinteger3696in_pending_trade_idNHOLDINGDBOLOT_LEVEL_POSITIONPENDING_TRADE_ID
EagleML/warehouseTransaction/warehouseOpenLot/pendingTradeId
qtyWashSaleEligibleOptionaldecimal405in_qty_wash_sale_eligibleNHOLDINGDBOLOT_LEVEL_POSITIONQTY_WASH_SALE_ELIGIBLENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/qtyWashSaleEligible
strategyOptionalstring2514in_strategy_idSHOLDINGDBOLOT_LEVEL_POSITIONSTRATEGY_IDVARCHAR2(20)EagleML/warehouseTransaction/warehouseOpenLot/strategy
tradeYieldOptionaldecimal9430in_trade_yieldNHOLDINGDBOLOT_LEVEL_POSITIONTRADE_YIELDNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/tradeYield
washSaleEligibleIndOptionalstring59in_wash_sale_eligible_indSHOLDINGDBOLOT_LEVEL_POSITIONWASH_SALE_ELIGIBLE_INDICATORCHAR(2)EagleML/warehouseTransaction/warehouseOpenLot/washSaleEligibleInd
aiaNetBOptionaldecimal11275in_aia_net_bNHOLDINGDBOPOSITION_COST_LOTAIA_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/aiaNetB
aiaNetLOptionaldecimal11149in_aia_net_lNHOLDINGDBOPOSITION_COST_LOTAIA_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/aiaNetL
buySellFlagOptionalnormalizedString3702in_buy_sell_flagSHOLDINGDBOPOSITION_COST_LOTBUY_SELL_FLAGVARCHAR2(4)EagleML/warehouseTransaction/warehouseOpenLot/buySellFlag
bookValueOptionaldecimal4602in_book_valueNHOLDINGDBOLOT_LEVEL_POSITIONBOOK_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/bookValue
bookValueLocalOptionaldecimal4601in_book_value_localNHOLDINGDBOLOT_LEVEL_POSITIONBOOK_VALUE_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/bookValueLocal
cpNetBOptionaldecimal11245in_cp_net_bNHOLDINGDBOPOSITION_COST_LOTCP_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/cpNetB
cpNetLOptionaldecimal11119in_cp_net_lNHOLDINGDBOPOSITION_COST_LOTCP_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/cpNetL
creditLossBOptionaldecimal2784in_credit_loss_bNHOLDINGDBOPOSITION_COST_LOTCREDIT_LOSS_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/creditLossB
creditLossLOptionaldecimal2783in_credit_loss_lNHOLDINGDBOPOSITION_COST_LOTCREDIT_LOSS_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/creditLossL
costBasisTypeOptionalstring24in_cost_basis_typeSHOLDINGDBOPOSITION_COST_LOTCOST_BASIS_TYPEVARCHAR2(2)EagleML/warehouseTransaction/warehouseOpenLot/costBasisType
futureFeeNetBOptionaldecimal116in_future_fee_net_bNHOLDINGDBOPOSITION_COST_LOTFUTURE_FEE_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/futureFeeNetB
futureFeeNetLOptionaldecimal11365in_future_fee_net_lNHOLDINGDBOPOSITION_COST_LOTFUTURE_FEE_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/futureFeeNetL
impairmentLtdBaseOptionaldecimal2701in_impairment_ltd_baseNHOLDINGDBOPOSITION_COST_LOTIMPAIRMENT_LTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/impairmentLtdBase
impairmentLtdLocalOptionaldecimal2700in_impairment_ltd_localNHOLDINGDBOPOSITION_COST_LOTIMPAIRMENT_LTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/impairmentLtdLocal
mbaNetBOptionaldecimal11251in_mba_net_bNHOLDINGDBOPOSITION_COST_LOTMBA_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/mbaNetB
mbaNetLOptionaldecimal11125in_mba_net_lNHOLDINGDBOPOSITION_COST_LOTMBA_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/mbaNetL
naiaNetBOptionaldecimal11343in_naia_net_bNHOLDINGDBOPOSITION_COST_LOTNAIA_NET_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/naiaNetB
naiaNetLOptionaldecimal11342in_naia_net_lNHOLDINGDBOPOSITION_COST_LOTNAIA_NET_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/naiaNetL
nonCreditLossBOptionaldecimal2705in_non_credit_loss_bNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossB
nonCreditLossLOptionaldecimal2704in_non_credit_loss_lNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossL
adjustedSharesOptionaldecimal4972in_adjusted_sharesNHOLDINGDBOLOT_LEVEL_POSITIONADJUSTED_SHARESNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/adjustedShares
baseGaapMarketValueOptionaldecimal9281in_base_gaap_market_valueNHOLDINGDBOPOSITION_COST_LOTBASE_GAAP_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/baseGaapMarketValue
baseStatMarketValueOptionaldecimal9290in_base_stat_market_valueNHOLDINGDBOPOSITION_COST_LOTBASE_STAT_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/baseStatMarketValue
cashEquivalentsOptionaldecimal64in_cash_equivalentsNHOLDINGDBOLOT_LEVEL_POSITIONCASH_EQUIVALENTSNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/cashEquivalents
cirBrkFeesOptionaldecimal255in_cir_brk_feesNHOLDINGDBOLOT_LEVEL_POSITIONCIR_BRK_FEESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/cirBrkFees
closeOidIncomeOptionaldecimal5686in_cls_oid_incomeNHOLDINGDBOLOT_LEVEL_POSITIONCLS_OID_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeOidIncome
closeOidIncomeLocalOptionaldecimal5685in_cls_oid_income_localNHOLDINGDBOLOT_LEVEL_POSITIONCLS_OID_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeOidIncomeLocal
closeTipsIncomeLocalOptionaldecimal4538in_cls_tips_income_localNHOLDINGDBOLOT_LEVEL_POSITIONCLS_TIPS_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLocal
closeTipsIncomeOptionaldecimal4539in_cls_tips_incomeNHOLDINGDBOLOT_LEVEL_POSITIONCLS_TIPS_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncome
deferredIncomeTotalPtdBOptionaldecimal7980in_deferred_income_total_ptd_bNHOLDINGDBOPOSITION_COST_LOTDEFERRED_INCOME_TOTAL_PTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/deferredIncomeTotalPtdB
deferredIncomeTotalPtdLOptionaldecimal7979in_deferred_income_total_ptd_lNHOLDINGDBOPOSITION_COST_LOTDEFERRED_INCOME_TOTAL_PTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/deferredIncomeTotalPtdL
deltaAdjQtyOptionaldecimal4987in_delta_adj_qtyNHOLDINGDBOLOT_LEVEL_POSITIONDELTA_ADJ_QTYNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/deltaAdjQty
dltaOptionaldecimal1090in_dltaNHOLDINGDBOLOT_LEVEL_POSITIONDLTANUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/dlta
expoPriceOptionaldecimal9164in_expo_priceNHOLDINGDBOLOT_LEVEL_POSITIONEXPO_PRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/expoPrice
earnThruDateOptionaldate4763in_earn_thru_dateNHOLDINGDBOLOT_LEVEL_POSITIONEARN_THRU_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/earnThruDate
execBrkFeesOptionaldecimal266in_exec_brk_feesNHOLDINGDBOLOT_LEVEL_POSITIONEXEC_BRK_FEESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/execBrkFees
fedTaxCostValueOptionaldecimal3878in_fed_tax_cost_valueNHOLDINGDBOLOT_LEVEL_POSITIONFED_TAX_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/fedTaxCostValue
gaapUnitBookValueOptionaldecimal3130in_gaap_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTGAAP_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapUnitBookValue
gaapUnitCostOptionaldecimal125in_gaap_unit_costNHOLDINGDBOPOSITION_COST_LOTGAAP_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapUnitCost
gaapBookValueOptionaldecimal9279in_gaap_book_valueNHOLDINGDBOPOSITION_COST_LOTGAAP_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapBookValue
gaapCostValueOptionaldecimal129in_gaap_cost_valueNHOLDINGDBOPOSITION_COST_LOTGAAP_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/gaapCostValue
hedgedCusipOptionalstring606in_hedged_cusipSHOLDINGDBOLOT_LEVEL_POSITIONHEDGED_CUSIPVARCHAR2(12)EagleML/warehouseTransaction/warehouseOpenLot/hedgedCusip
hedgeTradingOptionalstring656in_hedge_tradingSHOLDINGDBOLOT_LEVEL_POSITIONHEDGE_TRADINGVARCHAR2(10)EagleML/warehouseTransaction/warehouseOpenLot/hedgeTrading
interestEarnedOptionaldecimal465in_interest_earnedNHOLDINGDBOLOT_LEVEL_POSITIONINTEREST_EARNEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/interestEarned
lastSettlementDateOptionaldate1223in_last_settlement_dateSHOLDINGDBOLOT_LEVEL_POSITIONLAST_SETTLEMENT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/lastSettlementDate
localGaapCostValueOptionaldecimal128in_local_gaap_cost_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapCostValue
localGaapUnitCostOptionaldecimal124in_local_gaap_unit_costNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapUnitCost
localGaapBookValueOptionaldecimal9280in_local_gaap_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapBookValue
localGaapUnitBookValueOptionaldecimal9309in_local_gaap_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapUnitBookValue
localGaapMarketValueOptionaldecimal9314in_local_gaap_market_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_GAAP_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localGaapMarketValue
localTaxUnitBookValueOptionaldecimal46in_local_tax_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxUnitBookValue
localStatUnitCostOptionaldecimal161in_local_stat_unit_costNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatUnitCost
localStatBookValueOptionaldecimal9292in_local_stat_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatBookValue
localStatCostValueOptionaldecimal9641in_local_stat_cost_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatCostValue
localStatMarketValueOptionaldecimal9318in_local_stat_market_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_MARKET_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatMarketValue
localStatUnitBookValueOptionaldecimal9293in_local_stat_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_STAT_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localStatUnitBookValue
localTaxBookValueOptionaldecimal2744in_local_tax_book_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxBookValue
localTaxCostValueOptionaldecimal3879in_local_tax_cost_valueNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxCostValue
localTaxUnitCostOptionaldecimal3874in_local_tax_unit_costNHOLDINGDBOPOSITION_COST_LOTLOCAL_TAX_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/localTaxUnitCost
nonCreditLossAmortLtdBOptionaldecimal2835in_non_credit_loss_amort_ltd_bNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_AMORT_LTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossAmortLtdB
nonCreditLossAmortLtdLOptionaldecimal2834in_non_credit_loss_amort_ltd_lNHOLDINGDBOPOSITION_COST_LOTNON_CREDIT_LOSS_AMORT_LTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossAmortLtdL
oidPtdBaseOptionaldecimal593in_oid_ptd_baseNHOLDINGDBOPOSITION_COST_LOTOID_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidPtdBase
oidPtdLocalOptionaldecimal578in_oid_ptd_localNHOLDINGDBOPOSITION_COST_LOTOID_PTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidPtdLocal
oidLtdIncomeLocalOptionaldecimal575in_oid_ltd_income_localNHOLDINGDBOLOT_LEVEL_POSITIONOID_LTD_INCOME_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidLtdIncomeLocal
oidLtdIncomeBaseOptionaldecimal590in_oid_ltd_incomeNHOLDINGDBOLOT_LEVEL_POSITIONOID_LTD_INCOMENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/oidLtdIncomeBase
openMktPriceOptionaldecimal160in_open_mkt_priceNHOLDINGDBOLOT_LEVEL_POSITIONOPEN_MKT_PRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/openMktPrice
origAccrPtdBaseOptionaldecimal9630in_orig_accr_ptd_baseNHOLDINGDBOPOSITION_COST_LOTORIG_ACCR_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/origAccrPtdBase
origSoldInterestBaseOptionaldecimal9631in_orig_sold_interest_baseNHOLDINGDBOPOSITION_COST_LOTORIG_SOLD_INTEREST_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/origSoldInterestBase
origTradedInterestBaseOptionaldecimal9632in_orig_traded_interest_baseNHOLDINGDBOPOSITION_COST_LOTORIG_TRADED_INTEREST_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/origTradedInterestBase
originalCostAmountOptionaldecimal162in_original_cost_amountNHOLDINGDBOLOT_LEVEL_POSITIONORIGINAL_COST_AMOUNTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/originalCostAmount
payEpAccruedOptionaldecimal2881in_pay_ep_accruedNHOLDINGDBOLOT_LEVEL_POSITIONPAY_EP_ACCRUEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/payEpAccrued
payRecIndOptionalstring4590in_pay_rec_indSHOLDINGDBOPOSITION_COST_LOTPAY_REC_INDVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/payRecInd
posnFullyEarnedOptionalstring8383in_posn_fully_earnedSHOLDINGDBOPOSITION_COST_LOTPOSN_FULLY_EARNEDVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/posnFullyEarned
purchasePrincipalBaseOptionaldecimal256in_purchase_principal_baseNHOLDINGDBOLOT_LEVEL_POSITIONPURCHASE_PRINCIPAL_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchasePrincipalBase
purchasePrincipalLocalOptionaldecimal254in_purchase_principal_localNHOLDINGDBOLOT_LEVEL_POSITIONPURCHASE_PRINCIPAL_LOCALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/purchasePrincipalLocal
pv01totalOptionaldecimal5839in_pv01totalNHOLDINGDBOLOT_LEVEL_POSITIONPV01TOTALNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/pv01total
preTaxAdjYldOptionaldecimal5767in_pre_tax_adj_yldNHOLDINGDBOLOT_LEVEL_POSITIONPRE_TAX_ADJ_YLDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/preTaxAdjYld
recEpAccruedOptionaldecimal2880in_rec_ep_accruedNHOLDINGDBOLOT_LEVEL_POSITIONREC_EP_ACCRUEDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/recEpAccrued
statCostValueOptionaldecimal166in_stat_cost_valueNHOLDINGDBOPOSITION_COST_LOTSTAT_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statCostValue
soldInterestBaseOptionaldecimal8953in_interest_sold_baseNHOLDINGDBOLOT_LEVEL_POSITIONINTEREST_SOLD_BASENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/soldInterestBase
scrubFlagOptionalYesNoOptionEnum4569in_scrub_flagSHOLDINGDBOLOT_LEVEL_POSITIONSCRUB_FLAGCHAR(2)EagleML/warehouseTransaction/warehouseOpenLot/scrubFlag
sourceInternalAssetIdOptionalstring13047in_source_internal_asset_idSHOLDINGDBOLOT_LEVEL_POSITIONSOURCE_INTERNAL_ASSET_IDVARCHAR2(30)EagleML/warehouseTransaction/warehouseOpenLot/sourceInternalAssetId
statBookValueOptionaldecimal9289in_stat_book_valueNHOLDINGDBOPOSITION_COST_LOTSTAT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statBookValue
statUnitBookValueOptionaldecimal9308in_stat_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTSTAT_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statUnitBookValue
soldInterestLocalOptionaldecimal8952in_interest_soldNHOLDINGDBOLOT_LEVEL_POSITIONINTEREST_SOLDNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/soldInterestLocal
statUnitCostOptionaldecimal9291in_stat_unit_costNHOLDINGDBOPOSITION_COST_LOTSTAT_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/statUnitCost
stateCostValueOptionaldecimal11985in_state_cost_valueNHOLDINGDBOLOT_LEVEL_POSITIONSTATE_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/stateCostValue
swapAccrMethodOptionalstring1184in_swap_accr_methodSHOLDINGDBOPOSITION_COST_LOTSWAP_ACCR_METHODVARCHAR2(1)EagleML/warehouseTransaction/warehouseOpenLot/swapAccrMethod
totalUnrealizedGainLossLocalOptionaldecimal489in_local_unrealized_glNHOLDINGDBOLOT_LEVEL_POSITIONLOCAL_UNREALIZED_GLNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/totalUnrealizedGainLossLocal
totalUnrealizedGainLossBaseOptionaldecimal492in_base_unrealized_glNHOLDINGDBOLOT_LEVEL_POSITIONBASE_UNREALIZED_GLNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/totalUnrealizedGainLossBase
tipsPtdBaseOptionaldecimal4447in_tips_ptd_baseNHOLDINGDBOPOSITION_COST_LOTTIPS_PTD_BASENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/tipsPtdBase
tipsPtdLocalOptionaldecimal4442in_tips_ptd_localNHOLDINGDBOPOSITION_COST_LOTTIPS_PTD_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/tipsPtdLocal
taxBookValueOptionaldecimal3881in_tax_book_valueNHOLDINGDBOPOSITION_COST_LOTTAX_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxBookValue
taxCostValueOptionaldecimal2726in_tax_cost_valueNHOLDINGDBOPOSITION_COST_LOTTAX_COST_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxCostValue
taxUnitBookValueOptionaldecimal2727in_tax_unit_book_valueNHOLDINGDBOPOSITION_COST_LOTTAX_UNIT_BOOK_VALUENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxUnitBookValue
taxUnitCostOptionaldecimal9311in_tax_unit_costNHOLDINGDBOPOSITION_COST_LOTTAX_UNIT_COSTNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/taxUnitCost
tradeFxRateOptionaldecimal79,751in_trade_fx_rateNHOLDINGDBOLOT_LEVEL_POSITIONTRADE_FX_RATENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/tradeFxRate
undPriceOptionaldecimal9163in_und_priceNHOLDINGDBOLOT_LEVEL_POSITIONUND_PRICENUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/undPrice
uniqueAssetFlagOptionalYesNoOptionEnum13042in_unique_asset_flagSHOLDINGDBOLOT_LEVEL_POSITIONUNIQUE_ASSET_FLAGCHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/uniqueAssetFlag
bankAliasOptionalinteger1864,16in_bank_aliasNHOLDINGDBOPOSITION_COST_LOTBANK_ALIASNUMBEREagleML/warehouseTransaction/warehouseOpenLot/bankAlias
batchEventIdOptionalstring701in_batch_event_idSHOLDINGDBOLOT_LEVEL_POSITIONBATCH_EVENT_IDVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/batchEventId
brokerCodeOptionalstring88in_broker_codeSHOLDINGDBOLOT_LEVEL_POSITIONBROKER_CODEVARCHAR2(12)EagleML/warehouseTransaction/warehouseOpenLot/brokerCode
clearingBrokerCodeOptionalstring1237in_clearing_broker_codeSHOLDINGDBOLOT_LEVEL_POSITIONCLEARING_BROKER_CODECHAR(12)EagleML/warehouseTransaction/warehouseOpenLot/clearingBrokerCode
commissionAmountOptionaldecimal47in_commissionNHOLDINGDBOLOT_LEVEL_POSITIONCOMMISSIONNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/commissionAmount
lotNumberOptionalstring1790in_lot_numberSHOLDINGDBOLOT_LEVEL_POSITIONLOT_NUMBERCHAR(10)EagleML/warehouseTransaction/warehouseOpenLot/lotNumber
masterTicketNumberOptionalstring761in_master_ticket_numberSHOLDINGDBOLOT_LEVEL_POSITIONMASTER_TICKET_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/masterTicketNumber
monthEndAccountingDateOptionaldate4733in_monthly_accounting_dateSHOLDINGDBOLOT_LEVEL_POSITIONMONTHLY_ACCOUNTING_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/monthEndAccountingDate
secFeeOptionaldecimal3752in_sec_feesNHOLDINGDBOPOSITION_COST_LOTSEC_FEESNUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/secFee
settlementDateOptionaldate37in_settlement_dateSHOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/settlementDate
tradeDateOptionaldate35in_trade_dateSHOLDINGDBOLOT_LEVEL_POSITIONTRADE_DATEDATEEagleML/warehouseTransaction/warehouseOpenLot/tradeDate
transactionCodeOptionalstring3821in_trans_codeSHOLDINGDBOPOSITION_COST_LOTTRANS_CODEVARCHAR2(55)EagleML/warehouseTransaction/warehouseOpenLot/transactionCode
userChar1Optionalstring1887in_user_char1SHOLDINGDBOLOT_LEVEL_POSITIONUSER_CHAR1VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userChar1
userChar2Optionalstring1888in_user_char2SHOLDINGDBOLOT_LEVEL_POSITIONUSER_CHAR2VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userChar2
userChar3Optionalstring1889in_user_char3SHOLDINGDBOLOT_LEVEL_POSITIONUSER_CHAR3VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userChar3
userDefinedFloat1Optionaldecimal1890in_user_float1NHOLDINGDBOLOT_LEVEL_POSITIONUSER_FLOAT1NUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat1
userDefinedFloat2Optionaldecimal1891in_user_float2NHOLDINGDBOLOT_LEVEL_POSITIONUSER_FLOAT2NUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat2
userDefinedFloat3Optionaldecimal1892in_user_float3NHOLDINGDBOLOT_LEVEL_POSITIONUSER_FLOAT3NUMBER(28,12)EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat3
pclUserDate1Optionaldate32in_pcl_user_date1SHOLDINGDBOPOSITION_COST_LOTPCL_USER_DATE1DATEEagleML/warehouseTransaction/warehouseOpenLot/pclUserDate1
pclUserDate2Optionaldate30in_pcl_user_date2SHOLDINGDBOPOSITION_COST_LOTPCL_USER_DATE2DATEEagleML/warehouseTransaction/warehouseOpenLot/pclUserDate2
pclUserDate3Optionaldate164in_pcl_user_date3SHOLDINGDBOPOSITION_COST_LOTPCL_USER_DATE3DATEEagleML/warehouseTransaction/warehouseOpenLot/pclUserDate3
userGroup1Optionalstring63in_user_group1SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP1CHAR(10)EagleML/warehouseTransaction/warehouseOpenLot/userGroup1
userGroup2Optionalstring17,1891in_user_group2SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP2CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup2
userGroup3Optionalstring1461in_user_group3SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP3CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup3
userGroup4Optionalstring1472in_user_group4SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP4CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup4
userGroup5Optionalstring1473in_user_group5SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP5CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup5
userGroup6Optionalstring768in_user_group6SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP6CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup6
userGroup7Optionalstring1462in_user_group7SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP7CHAR(8)EagleML/warehouseTransaction/warehouseOpenLot/userGroup7
userGroup8Optionalstring9989in_user_group8SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP8VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup8
userGroup9Optionalstring9990in_user_group9SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP9VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup9
userGroup10Optionalstring9991in_user_group10SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP10VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup10
userGroup11Optionalstring9992in_user_group11SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP11VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup11
userGroup12Optionalstring9993in_user_group12SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP12VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup12
userGroup13Optionalstring9994in_user_group13SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP13VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup13
userGroup14Optionalstring9995in_user_group14SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP14VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup14
userGroup15Optionalstring9996in_user_group15SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP15VARCHAR2(35)EagleML/warehouseTransaction/warehouseOpenLot/userGroup15
userGroup16Optionalstring9997in_user_group16SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP16VARCHAR2(50)EagleML/warehouseTransaction/warehouseOpenLot/userGroup16
userGroup17Optionalstring9998in_user_group17SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP17VARCHAR2(15)EagleML/warehouseTransaction/warehouseOpenLot/userGroup17
userGroup18Optionalstring9999in_user_group18SHOLDINGDBOLOT_LEVEL_POSITIONUSER_GROUP18VARCHAR2(35)EagleML/warehouseTransaction/warehouseOpenLot/userGroup18
settledGaapCostValue
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_GAAP_COST_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledGaapCostValue
settledLocalGaapCostValue
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_LOCAL_GAAP_COST_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledLocalGaapCostValue
settledLocalMarketValue
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_LOCAL_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledLocalMarketValue
settledMarketValue
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLED_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settledMarketValue
settlementDatePosition
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATE_POSITIONNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePosition
settlementDatePositionLocal
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATE_POSITION_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionLocal
settlementDatePositionCost
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSETTLEMENT_DATE_POSITION_COSTNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionCost
lotLevelPositionIdOptionalinteger


HOLDINGDBOLOT_LEVEL_POSITIONLOT_LEVEL_POSITIONNUMBEREagleML/warehouseTransaction/warehouseOpenLot/lotLevelPositionId
lotLevelCostPositionIdOptionalinteger


HOLDINGDBOPOSITION_COST_LOTPOSITION_LOT_IDNUMBEREagleML/warehouseTransaction/warehouseOpenLot/lotLevelCostPositionId
starQuantity
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSTAR_QUANTITYNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/starQuantity
starMarketValueLocal
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSTAR_MARKET_VALUE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/starMarketValueLocal
starMarketValue
(supported in 2017R1)		Optionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONSTAR_MARKET_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/starMarketValue
processingIlbLtdLocalOptionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONPROCESSING_ILB_LTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdLocal
processingIlbLtdBaseOptionaldecimal


HOLDINGDBOLOT_LEVEL_POSITIONPROCESSING_ILB_LTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdBase
incomeBalanceLocalOptionaldecimal


HOLDINGDBOPOSITION_COST_LOTINCOME_BALANCE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/incomeBalanceLocal
incomeBalanceOptionaldecimal


HOLDINGDBOPOSITION_COST_LOTINCOME_BALANCENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/incomeBalance
principalBalanceLocalOptionaldecimal


HOLDINGDBOPOSITION_COST_LOTPRINCIPAL_BALANCE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/principalBalanceLocal
principalBalanceOptionaldecimal


HOLDINGDBOPOSITION_COST_LOTPRINCIPAL_BALANCENUMBER(38,12)EagleML/warehouseTransaction/warehouseOpenLot/principalBalance
orderNumberOptionalstring


HOLDINGDBOLOT_LEVEL_POSITIONORDER_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehouseOpenLot/orderNumber
priceMethodOptionalnormalizedString


HOLDINGDBOLOT_LEVEL_POSITIONPRICE_METHODVARCHAR2(4)EagleML/warehouseTransaction/warehouseOpenLot/priceMethod
regulatoryIntentOptionalnormalizedString


HOLDINGDBOLOT_LEVEL_POSITIONREGULATORY_INTENTVARCHAR2(3)EagleML/warehouseTransaction/warehouseOpenLot/regulatoryIntent
holdingTermOptionalnormalizedString


HOLDINGDBOLOT_LEVEL_POSITIONHOLDING_TERMVARCHAR2(2)EagleML/warehouseTransaction/warehouseOpenLot/holdingTerm
positionIdOptionalinteger


HOLDINGDBOLOT_LEVEL_POSITIONPOSITION_IDNUMBEREagleML/warehouseTransaction/warehouseOpenLot/positionId
positionDetailId








EagleML/warehouseTransaction/warehouseOpenLot/positionDetailId
shareParValue








EagleML/warehouseTransaction/warehouseOpenLot/shareParValue
Real Estate UDF Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/realEstateUDF/
Extended Rating Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/extendedRatingModel/
Extended Port Valuation Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/extendedPortValuationModel/
Wash Sale Open Lot Model (see extra data map table)EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/


Note

Warehouse Open Lot Data Map Table#sourceLongShortInd and Warehouse Open Lot Data Map Table#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.
Warehouse Open Lot Data Map Table#procedureMode and Warehouse Open Lot Data Map Table#procedureFlag specify type of action (INSERT, UPDATE, DELETE)
  • No labels