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

Version 3 Next »


Important Note

  • netCash and netAmountLocal are passed into the same DB field TRADESDBO.TRADE.NET_CASH. You should use either of these two nodes in your incoming message, but not both of them at the same time.
  • toCashType and toCashEventType are passed into the same DB field TRADESDBO.TRADE.TO_CASH_TYPE. You should use either of these two nodes in your incoming message, but not both of them at the same time (if you try to load both, only toCashType will be processed).
  • the SP is currently designed to load longShortIndicator and starLsInd via the same SP parameter in_star_ls_ind. Therefore, these nodes are populated with the same value into DB.
  • costLocal and openCostLocal, costBase and openCostBase are mapped via in_cost_local and in_cost_base SP parameters respectively (costLocal and costBase have a higher priority)
  •  Fields denoted by *  (supported in  2017R1)   exist in the XML schema today.  However, these fields are not supported yet by the underlying core stored procedure (TRD_EGL_GEN_INTERFACE) and therefore these fields will not be loaded/exported. The stored procedure will be updated in 2017R1 to include these additional fields.

 

ElementOptional /RequiredValue TypeStar TagSP ParameterSP TypeEagle DBDB TableDB FieldDB Field TypeDB RequiredXpath
objectTypeOptionalObjectTypeEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/objectType
objectIdOptionalobjectId   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/objectId
objectDescriptionOptionalFeedTypeEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/objectDescription
updateTimestampOptionaldateTime   TRADESDBOTRADEUPDATE_DATEDATENEagleML/warehouseTransaction/warehouseTrade/updateTimestamp
customElementsNot recommendedCustomElements   reserved for customizations  EagleML/warehouseTransaction/warehouseTrade/customElements
sourceNameOptionalstring1102in_short_descSPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)YEagleML/warehouseTransaction/warehouseTrade/sourceName
updateSourceOptionalstring944in_update_sourceSTRADESDBOTRADEUPDATE_SOURCECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/updateSource
batchCollectErrorsFlagOptionalYesNoOptionEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/batchCollectErrorsFlag
singleRowCommitFlagOptionalYesNoOptionEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/singleRowCommitFlag
effectiveDateOptionaldate221in_effective_dateSTRADESDBOTRADEEFFECTIVE_DATEDATEYEagleML/warehouseTransaction/warehouseTrade/effectiveDate
Entity Common Id ModelEagleML/warehouseTransaction/warehouseTrade/
Entity Properties Model (extract only)EagleML/warehouseTransaction/warehouseTrade/
accountingBasisOptionalstring21in_acct_basisSTRADESDBOTRADEACCT_BASISVARCHAR2(5)NEagleML/warehouseTransaction/warehouseTrade/accountingBasis
entityIDLookupSwitchOptionalLookupSwitchEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/entityIDLookupSwitch
entityNameLookupSwitchOptionalLookupSwitchEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/entityNameLookupSwitch
securityQueryFlagOptionalYesNoOptionEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/securityQueryFlag
sourceLookupSwitchOptionalLookupSwitchEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/sourceLookupSwitch
procedureModeOptionalProcedureFlagTypeEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/procedureMode
procedureFlagOptionalProcedureFlagTypeEnum   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/procedureFlag
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseTrade/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/warehouseTrade/
maturityDateOptionaldate   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/maturityDate
brokerCodeOptionalstring88in_broker_codeSTRADESDBOTRADEBROKER_CODECHAR(12)NEagleML/warehouseTransaction/warehouseTrade/brokerCode
clearingBrokerCodeOptionalstring1237in_clearing_broker_codeSTRADESDBOTRADE_DETAILCLEARING_BROKER_CODECHAR(20)NEagleML/warehouseTransaction/warehouseTrade/clearingBrokerCode
statusOptionalstring54in_trade_statusSTRADESDBOTRADETRADE_STATUSCHAR(8)NEagleML/warehouseTransaction/warehouseTrade/status
taxAmountLocalOptionaldecimal46in_taxesFTRADESDBOTRADETAXESNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/taxAmountLocal
commissionAmountOptionaldecimal12019in_commission_amountFTRADESDBOTRADECOMMISSION_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/commissionAmount
accruedInterestOptionaldecimal49in_accrued_interestFTRADESDBOTRADEACCRUED_INTERESTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/accruedInterest
baseCurrencyOptionalCurrencyCode86in_base_currencySTRADESDBOTRADEBASE_CURRENCYVARCHAR2(3)NEagleML/warehouseTransaction/warehouseTrade/baseCurrency
monthEndAccountingDateOptionaldate4733in_month_end_dateSTRADESDBOTRADEMONTH_END_DATEDATENEagleML/warehouseTransaction/warehouseTrade/monthEndAccountingDate
tradeIdOptionalinteger   TRADESDBOTRADETRADE_IDNUMBERYEagleML/warehouseTransaction/warehouseTrade/tradeId
accruedInterestTypeOptionalstring3715in_accrued_interest_typeSTRADESDBOTRADEACCRUED_INTEREST_TYPEVARCHAR2(3)NEagleML/warehouseTransaction/warehouseTrade/accruedInterestType
accruedIncomeLocalOptionaldecimal10758in_accrued_income_localFTRADESDBOTRADEACCRUED_INCOME_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/accruedIncomeLocal
cancelAccountingDtOptionaldate12138in_cancel_acctg_dateSTRADESDBOTRADE_DETAILCANCEL_ACCTG_DATEDATENEagleML/warehouseTransaction/warehouseTrade/cancelAccountingDt
cancelMthendAccountingDtOptionaldate12139in_cancel_me_acctg_dateSTRADESDBOTRADE_DETAILCANCEL_ME_ACCTG_DATEDATENEagleML/warehouseTransaction/warehouseTrade/cancelMthendAccountingDt
cancelFlagOptionalstring10045in_cancel_flagSTRADESDBOTRADE_DETAILCANCEL_FLAGCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/cancelFlag
cancelStatusOptionalstring10046in_cancel_statusSTRADESDBOTRADE_DETAILCANCEL_STATUSCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/cancelStatus
cancelEffectiveDtOptionaldate504in_cancel_effective_dateSTRADESDBOTRADE_DETAILCANCEL_EFFECTIVE_DATEDATENEagleML/warehouseTransaction/warehouseTrade/cancelEffectiveDt
cancelEventIdOptionalTransactionId501in_cancel_event_idSTRADESDBOTRADECANCEL_EVENT_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/cancelEventId
cancelLinkEventIdOptionalTransactionId506in_cancel_linked_event_idSTRADESDBOTRADECANCEL_LINKED_EVENT_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/cancelLinkEventId
currBuiltInGlSecurityOptionaldecimal9761in_curr_builtin_gl_secFTRADESDBOTRADECURR_BUILTIN_GL_SECNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/currBuiltInGlSecurity
currBuiltInGlCurrencyOptionaldecimal10917in_curr_builtin_gl_currencyFTRADESDBOTRADECURR_BUILTIN_GL_CURRENCYNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/currBuiltInGlCurrency
currBuiltInGlDeferredOptionaldecimal10918in_curr_builtin_gl_deferredFTRADESDBOTRADECURR_BUILTIN_GL_DEFERREDNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/currBuiltInGlDeferred
currBuiltInGlOidOptionaldecimal10919in_curr_builtin_gl_oidFTRADESDBOTRADECURR_BUILTIN_GL_OIDNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/currBuiltInGlOid
currBuiltInGlMktDiscOptionaldecimal10920in_curr_builtin_gl_mkt_discFTRADESDBOTRADECURR_BUILTIN_GL_MKT_DISCNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/currBuiltInGlMktDisc
gainCurrencyOptionaldecimal10049in_currency_gainFTRADESDBOTRADE_DETAILCURRENCY_GAINNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/gainCurrency
gainSecurityLocalOptionaldecimal10051in_security_gainFTRADESDBOTRADE_DETAILSECURITY_GAINNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/gainSecurityLocal
totalGainOptionaldecimal10057in_total_gainFTRADESDBOTRADE_DETAILTOTAL_GAINNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/totalGain
fromAccountOptionalstring351in_from_accountSTRADESDBOTRADEFROM_ACCOUNTCHAR(8)NEagleML/warehouseTransaction/warehouseTrade/fromAccount
fromAssetidOptionalinteger352in_from_sec_aliasFTRADESDBOTRADEFROM_SECURITY_ALIASNUMBERNEagleML/warehouseTransaction/warehouseTrade/fromAssetid
fromLongShortOptionalstring355in_from_lng_short_indSTRADESDBOTRADEFROM_LONG_SHORT_INDICATORVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/fromLongShort
fromSourceSystemOptionalstring361in_from_source_systemSTRADESDBOTRADEFROM_SOURCE_SYSTEMVARCHAR2(25) [v2015R2.x+]NEagleML/warehouseTransaction/warehouseTrade/fromSourceSystem
VARCHAR2(2) [v12.x or 13.x]
fromCostBasisTypeOptionalBasisType367in_from_cost_basis_typeSTRADESDBOTRADEFROM_COST_BASIS_TYPEVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/fromCostBasisType
fromWashSaleEligIndOptionalstring384in_from_wash_sale_indSTRADESDBOTRADEFROM_WASH_SALE_ELGBL_INDVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/fromWashSaleEligInd
lossCurrencyOptionaldecimal10052in_currency_lossFTRADESDBOTRADE_DETAILCURRENCY_LOSSNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/lossCurrency
lossSecurityLocalOptionaldecimal10054in_security_lossFTRADESDBOTRADE_DETAILSECURITY_LOSSNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/lossSecurityLocal
totalLossOptionaldecimal10058in_total_lossFTRADESDBOTRADE_DETAILTOTAL_LOSSNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/totalLoss
originalAcquisitionCostBaseOptionaldecimal3746in_orig_acq_cost_baseFTRADESDBOTRADEORIG_ACQ_COST_BASENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostBase
originalAcquisitionCostLocalOptionaldecimal3747in_orig_acq_cost_localFTRADESDBOTRADEORIG_ACQ_COST_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostLocal
originalFaceValueOptionaldecimal109in_original_face_valueFTRADESDBOTRADEORIGINAL_FACE_VALUENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/originalFaceValue
originalBuiltInGlMktDiscOptionaldecimal10915in_orig_builtin_gl_mkt_discFTRADESDBOTRADEORIG_BUILTIN_GL_MKT_DISCNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlMktDisc
originalTradePriceOptionaldecimal10906in_orig_trade_priceFTRADESDBOTRADEORIG_TRADE_PRICENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/originalTradePrice
originalBuiltInGlCurrencyOptionaldecimal10912in_orig_builtin_gl_currencyFTRADESDBOTRADEORIG_BUILTIN_GL_CURRENCYNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlCurrency
originalBuiltInGlDeferredOptionaldecimal10913in_orig_builtin_gl_deferredFTRADESDBOTRADEORIG_BUILTIN_GL_DEFERREDNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlDeferred
originalBuiltInGlOidOptionaldecimal10914in_orig_builtin_gl_oidFTRADESDBOTRADEORIG_BUILTIN_GL_OIDNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlOid
originalBuiltInGlSecurityOptionaldecimal9762in_orig_builtin_gl_secFTRADESDBOTRADEORIG_BUILTIN_GL_SECNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlSecurity
originalSettlementDateOptionaldate154in_orig_settlement_dateSTRADESDBOTRADEORIG_SETTLEMENT_DATEDATENEagleML/warehouseTransaction/warehouseTrade/originalSettlementDate
originalQuantityOptionaldecimal159in_par_or_sharesFTRADESDBOTRADEPAR_OR_SHARESNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/originalQuantity
openCostBaseOptionaldecimal166in_cost_baseFTRADESDBOTRADECOST_BASENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/openCostBase
openHldPerDateOptionaldate164in_holding_period_dateSTRADESDBOTRADEHOLDING_PERIOD_DATEDATENEagleML/warehouseTransaction/warehouseTrade/openHldPerDate
performanceFlowOptionaldecimal4597in_performance_valueFTRADESDBOTRADE_DETAILPERFORMANCE_VALUENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/performanceFlow
performancePriceOptionaldecimal4598in_performance_priceFTRADESDBOTRADE_DETAILPERFORMANCE_PRICENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/performancePrice
premiumLAllocatedOptionaldecimal203in_premium_allocated_localFTRADESDBOTRADEPREMIUM_ALLOCATED_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/premiumLAllocated
premiumBAllocatedOptionaldecimal204in_premium_allocatedFTRADESDBOTRADEPREMIUM_ALLOCATEDNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/premiumBAllocated
settlementAmountOptionaldecimal64in_settlement_amountFTRADESDBOTRADESETTLEMENT_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/settlementAmount
toAccountOptionalstring301in_to_accountSTRADESDBOTRADETO_ACCOUNTCHAR(8)NEagleML/warehouseTransaction/warehouseTrade/toAccount
toAssetidOptionalinteger302in_to_sec_aliasFTRADESDBOTRADETO_SECURITY_ALIASNUMBERNEagleML/warehouseTransaction/warehouseTrade/toAssetid
toLongShortOptionalstring305in_to_lng_short_indSTRADESDBOTRADETO_LONG_SHORT_INDICATORVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/toLongShort
toSourceSystemOptionalstring311in_to_source_systemSTRADESDBOTRADETO_SOURCE_SYSTEMVARCHAR2(25) [v2015R2.x+]NEagleML/warehouseTransaction/warehouseTrade/toSourceSystem
VARCHAR2(2) [v12.x or 13.x]
toCostBasisTypeOptionalBasisType317in_to_cost_basis_typeSTRADESDBOTRADETO_COST_BASIS_TYPEVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/toCostBasisType
toCashEventTypeOptionalstring328in_to_cash_typeSTRADESDBOTRADETO_CASH_TYPEVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/toCashEventType
toWashSaleEligIndOptionalstring334in_to_wash_sale_indSTRADESDBOTRADETO_WASH_SALE_ELGBL_INDVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/toWashSaleEligInd
userChar1Optionalstring1887in_user_char1STRADESDBOTRADEUSER_CHAR1VARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/userChar1
userChar2Optionalstring1888in_user_char2STRADESDBOTRADEUSER_CHAR2VARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/userChar2
userChar3Optionalstring1889in_user_char3STRADESDBOTRADEUSER_CHAR3VARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/userChar3
userDefinedFloat1Optionaldecimal1890in_user_float1FTRADESDBOTRADEUSER_FLOAT1NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/userDefinedFloat1
userDefinedFloat2Optionaldecimal1891in_user_float2FTRADESDBOTRADEUSER_FLOAT2NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/userDefinedFloat2
userDefinedFloat3Optionaldecimal1892in_user_float3FTRADESDBOTRADEUSER_FLOAT3NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/userDefinedFloat3
costMethodOptionalstring22in_cost_methodSTRADESDBOTRADECOST_METHODVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/costMethod
lotSelectionMethodOptionalstring27in_lot_selection_methodSTRADESDBOTRADELOT_SELECTION_METHODVARCHAR2(8)NEagleML/warehouseTransaction/warehouseTrade/lotSelectionMethod
transactionCodeOptionalstring2283in_trans_codeSTRADESDBOTRADETRANS_CODECHAR(55)NEagleML/warehouseTransaction/warehouseTrade/transactionCode
factorOptionaldecimal91in_factorFTRADESDBOTRADEFACTORNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/factor
netAmountLocal Optionaldecimal50in_net_cashFTRADESDBOTRADENET_CASHNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/netAmountLocal
netAmountBaseOptionaldecimal478in_trade_base_amountFTRADESDBOTRADETRADE_BASE_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/netAmountBase
principalBOptionaldecimal169in_principal_baseFTRADESDBOTRADEPRINCIPAL_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/principalB
quantityPreOptionaldecimal410in_target_quantityFTRADESDBOTRADETARGET_QUANTITYNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/quantityPre
tradeYieldOptionaldecimal9430in_trade_yieldFTRADESDBOTRADETRADE_YIELDNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/tradeYield
dirtyPrincipalLocalOptionaldecimal10781in_dirty_principalFTRADESDBOTRADEDIRTY_PRINCIPALNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalLocal
dirtyPrincipalBaseOptionaldecimal10782in_dirty_principal_baseFTRADESDBOTRADEDIRTY_PRINCIPAL_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalBase
estimateVsFinalOptionalstring768in_est_vs_actSTRADESDBOTRADEEST_VS_ACTVARCHAR2(3)NEagleML/warehouseTransaction/warehouseTrade/estimateVsFinal
reportingReplayIndOptionalstring10674in_replay_indSTRADESDBOTRADEREPLAY_INDVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/reportingReplayInd
cashEventTypeOptionalstring53in_cash_typeSTRADESDBOTRADE_DETAILCASH_TYPECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/cashEventType
transactionNotesOptionalstring56in_transaction_notesSTRADESDBOTRADE_DETAILTRANSACTION_NOTESVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/transactionNotes
partflagOptionalstring3924in_partflagSTRADESDBOTRADE_DETAILPARTFLAGCHAR(1)NEagleML/warehouseTransaction/warehouseTrade/partflag
scrubTypeOptionalstring3717in_scrub_typeSTRADESDBOTRADESCRUB_TYPECHAR(2)NEagleML/warehouseTransaction/warehouseTrade/scrubType
glAccountOptionalstring4519in_general_ledger_acctSTRADESDBOTRADE_DETAILGENERAL_LEDGER_ACCTVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/glAccount
custodianBankOptionalstring   not stored in DB NEagleML/warehouseTransaction/warehouseTrade/custodianBank
custodianBankCodeOptionalstring1240in_custody_bank_codeSTRADESDBOTRADECUSTODY_BANK_CODECHAR(20)NEagleML/warehouseTransaction/warehouseTrade/custodianBankCode
custodyBankAccountNumOptionalstring1660in_custody_bank_acct_numSTRADESDBOTRADECUSTODY_BANK_ACCT_NUMVARCHAR2(15)NEagleML/warehouseTransaction/warehouseTrade/custodyBankAccountNum
custodyBankSubAccountOptionalstring1661in_custody_bank_sub_acctSTRADESDBOTRADECUSTODY_BANK_SUB_ACCTVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/custodyBankSubAccount
corporateActionTypeOptionalstring1728in_corp_action_typeSTRADESDBOTRADECORP_ACTION_TYPEVARCHAR2(55)NEagleML/warehouseTransaction/warehouseTrade/corporateActionType
cashEventSpawnedOptionalstring751in_cash_event_spawnedSTRADESDBOTRADECASH_EVENT_SPAWNEDVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/cashEventSpawned
bankAliasOptionalinteger1864in_bank_aliasSTRADESDBOTRADEBANK_ALIASNUMBERNEagleML/warehouseTransaction/warehouseTrade/bankAlias
changedflagOptionalstring10705in_changedflagSTRADESDBOTRADE_DETAILCHANGEDFLAGCHAR(1)NEagleML/warehouseTransaction/warehouseTrade/changedflag
eventIdOptionalTransactionId25in_star_tag25STRADESDBOTRADESTAR_TAG25VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/eventId
corporateActionInstanceOptionalinteger4268in_corporate_action_instSTRADESDBOTRADE_DETAILCORPORATE_ACTION_INSTNUMBERNEagleML/warehouseTransaction/warehouseTrade/corporateActionInstance
eventIdSwitchOptionalTransactionId   TRADESDBOTRADETRANSACTION_ID NEagleML/warehouseTransaction/warehouseTrade/eventIdSwitch
sellToBuyFXRateOptionaldecimal7in_sell_to_buy_fx_rateFTRADESDBOTRADESELL_TO_BUY_FX_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/sellToBuyFXRate
lotNumberOptionalstring3710in_lot_numberSTRADESDBOTRADELOT_NUMBERCHAR(8)YEagleML/warehouseTransaction/warehouseTrade/lotNumber
masterTicketNumberRequiredstring761in_master_ticket_numberSTRADESDBOTRADEMASTER_TICKET_NUMBERVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/masterTicketNumber
tradeXrefIdentifierOptionalTradeXrefIdentifier   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/
acqTransNumberOptionalinteger12251in_acq_tnumFTRADESDBOTRADE_DETAILACQ_TNUMNUMBERNEagleML/warehouseTransaction/warehouseTrade/acqTransNumber
postTypeOptionalstring12197in_post_typeSTRADESDBOTRADE_DETAILPOST_TYPECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/postType
tradeMemo1Optionalstring12236in_trade_memo1STRADESDBOTRADE_DETAILTRADE_MEMO1VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/tradeMemo1
tradeMemo2Optionalstring12237in_trade_memo2STRADESDBOTRADE_DETAILTRADE_MEMO2VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/tradeMemo2
fxRateOptionaldecimal87in_fx_rateFTRADESDBOTRADEFX_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/fxRate
checkedDateOptionaldateTime12141in_checkeddateSTRADESDBOTRADE_DETAILCHECKEDDATEDATENEagleML/warehouseTransaction/warehouseTrade/checkedDate
accountingDesignationOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/accountingDesignation
brokerReasonOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/brokerReason
instructedDateOptionaldateTime12143in_instructeddateSTRADESDBOTRADE_DETAILINSTRUCTEDDATEDATENEagleML/warehouseTransaction/warehouseTrade/instructedDate
dispInterestReceivedOptionaldecimal12318in_disp_interest_receivedFTRADESDBOTRADE_DETAILDISP_INTEREST_RECEIVEDNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/dispInterestReceived
userWhoApprovedTradeOptionalstring12262in_user_who_approved_tradeSTRADESDBOTRADE_DETAILUSER_WHO_APPROVED_TRADEVARCHAR2(20)NEagleML/warehouseTransaction/warehouseTrade/userWhoApprovedTrade
otherFundNumberOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/otherFundNumber
prepaySpeedOptionaldecimal7315in_prepay_speed_contract_sizeFTRADESDBOTRADE_DETAILPREPAY_SPEED_CONTRACT_SIZEVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/prepaySpeed
prepayTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/prepayType
settlementExchangeRateOptionaldecimal79in_settlement_exchange_rateFTRADESDBOTRADESETTLEMENT_EXCHANGE_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/settlementExchangeRate
touchCountOptionalinteger13688in_transeqFTRADESDBOTRADE_DETAILTRANSEQNUMBERNEagleML/warehouseTransaction/warehouseTrade/touchCount
secTranTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/secTranType
authorizedDateOptionaldateTime12137in_authorizeddateSTRADESDBOTRADE_DETAILAUTHORIZEDDATEDATENEagleML/warehouseTransaction/warehouseTrade/authorizedDate
localCommissionAmountOptionaldecimal47in_local_commission_amountFTRADESDBOTRADELOCAL_COMMISSION_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/localCommissionAmount
salesPersonOptionalstring12098in_sales_personSTRADESDBOTRADESALES_PERSONCHAR(18)NEagleML/warehouseTransaction/warehouseTrade/salesPerson
convexityOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/convexity
brokerOptionalstring12126in_brokerSTRADESDBOTRADE_DETAILBROKERCHAR(50)NEagleML/warehouseTransaction/warehouseTrade/broker
settlementCurrencyOptionalstring63in_settlement_currencySTRADESDBOTRADESETTLEMENT_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/settlementCurrency
discountRateOptionaldecimal12039in_discount_rateFTRADESDBOTRADEDISCOUNT_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/discountRate
durationOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/duration
comments1Optionalstring12133in_comments1STRADESDBOTRADE_DETAILCOMMENTS1CHAR(30)NEagleML/warehouseTransaction/warehouseTrade/comments1
modifiedByOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/modifiedBy
priceOptionaldecimal160in_priceFTRADESDBOTRADEPRICENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/price
pricingIndexOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/pricingIndex
pricingSpreadOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/pricingSpread
principalOptionaldecimal165in_tdprincipalFTRADESDBOTRADEPRINCIPALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/principal
commentsOptionalstring12132in_commentsSTRADESDBOTRADE_DETAILCOMMENTSCHAR(30)NEagleML/warehouseTransaction/warehouseTrade/comments
preparedOptionalstring12199in_preparedSTRADESDBOTRADE_DETAILPREPAREDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/prepared
preparedDateOptionaldateTime12194in_prepareddateSTRADESDBOTRADE_DETAILPREPAREDDATEDATENEagleML/warehouseTransaction/warehouseTrade/preparedDate
settlementLocationOptionalstring43in_settlement_locationSTRADESDBOTRADESETTLEMENT_LOCATIONCHAR(12)NEagleML/warehouseTransaction/warehouseTrade/settlementLocation
traderOptionalstring12115in_traderSTRADESDBOTRADETRADERCHAR(30)NEagleML/warehouseTransaction/warehouseTrade/trader
yieldOptionaldecimal75in_yieldFTRADESDBOTRADEYIELDNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/yield
blockTradeIdOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/blockTradeId
fromQuantityOptionaldecimal366in_from_quantityFTRADESDBOTRADEFROM_QUANTITYNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/fromQuantity
sellToBaseFxRateOptionaldecimal12149in_sell_to_base_fx_rateFTRADESDBOTRADESELL_TO_BASE_FX_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/sellToBaseFxRate
toQuantityOptionaldecimal316in_to_quantityFTRADESDBOTRADETO_QUANTITYNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/toQuantity
toAmountLocalOptionaldecimal327in_to_amount_localFTRADESDBOTRADETO_AMOUNT_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/toAmountLocal
toCashTypeOptionalstring328in_to_cash_typeSTRADESDBOTRADETO_CASH_TYPEVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/toCashType
fromAmountLocalOptionaldecimal377in_from_amount_localFTRADESDBOTRADEFROM_AMOUNT_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/fromAmountLocal
fromCashTypeOptionalstring378in_from_cash_typeSTRADESDBOTRADEFROM_CASH_TYPEVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/fromCashType
novationTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/novationType
derivTranTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/derivTranType
currentWALOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/currentWAL
purchaseTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/purchaseType
embeddedDerivPriceOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/embeddedDerivPrice
assetLiabilityHedgeFlagOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/assetLiabilityHedgeFlag
currentWACOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/currentWAC
currentWAMOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/currentWAM
hedgeTaxStatusOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/hedgeTaxStatus
hedgeDesigCdsOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/hedgeDesigCds
settlementInstructions1Optionalstring1897in_settlement_instructions1STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS1VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settlementInstructions1
settlementInstructions2Optionalstring12224in_settlement_instructions2STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS2VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settlementInstructions2
settlementInstructions3Optionalstring12225in_settlement_instructions3STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS3VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settlementInstructions3
settlementInstructions4Optionalstring12227in_settlement_instructions4STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS4VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settlementInstructions4
strategyOptionalstring12105in_strategy_idSTRADESDBOTRADESTRATEGY_IDVARCHAR2(20)NEagleML/warehouseTransaction/warehouseTrade/strategy
executionTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/executionType
origEntryDateOptionaldate   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/origEntryDate
settlementDateOptionaldate37in_settlement_dateSTRADESDBOTRADESETTLEMENT_DATEDATENEagleML/warehouseTransaction/warehouseTrade/settlementDate
fxPayCurrencyOptionalCurrencyCode   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/fxPayCurrency
tradeExchangeRateOptionaldecimal12163in_trade_exchange_rateFTRADESDBOTRADETRADE_EXCHANGE_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/tradeExchangeRate
fxRcvCurrencyOptionalCurrencyCode   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/fxRcvCurrency
postDateOptionaldate30in_post_dateSTRADESDBOTRADEPOST_DATEDATENEagleML/warehouseTransaction/warehouseTrade/postDate
conterpartyCodeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/conterpartyCode
tradeCouponOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/tradeCoupon
factorDateOptionaldate   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/factorDate
longShortIndicatorOptionalLongShortIndicatorEnum in_star_ls_ind TRADESDBOTRADE_DETAILLONG_SHORT_INDICATORCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/longShortIndicator
custodianBankDescOptionalstring1146in_custody_bank_descSTRADESDBOTRADECUSTODY_BANK_DESCCHAR(50)NEagleML/warehouseTransaction/warehouseTrade/custodianBankDesc
openCostLocalOptionaldecimal162in_cost_localFTRADESDBOTRADECOST_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/openCostLocal
tradeAmountOptionaldecimal190in_trade_amountFTRADESDBOTRADETRADE_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/tradeAmount
smInactiveFlagOptionalYesNoOptionEnum11043in_sm_inactive_flagSnot stored in DB, used for resolution logic  EagleML/warehouseTransaction/warehouseTrade/smInactiveFlag
clientIdOptionalstring1632in_client_idSTRADESDBOTRADECLIENT_IDVARCHAR2(20)NEagleML/warehouseTransaction/warehouseTrade/clientId
covFlagOptionalYesNoOptionEnum12135in_cov_flagSTRADESDBOTRADE_DETAILCOV_FLAGVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/covFlag
eventSubPriorityOptionalinteger12042in_event_sub_priorityFTRADESDBOTRADEEVENT_SUB_PRIORITYNUMBER(38)NEagleML/warehouseTransaction/warehouseTrade/eventSubPriority
ioIssuerAliasOptionalstring12183in_io_issuer_aliasSTRADESDBOTRADE_DETAILIO_ISSUER_ALIASVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/ioIssuerAlias
ioIssuerIdOptionalstring12184in_io_issuer_idSTRADESDBOTRADE_DETAILIO_ISSUER_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/ioIssuerId
origAcctDateOptionaldate12036in_orig_acct_dateSTRADESDBOTRADEORIG_ACCT_DATEDATENEagleML/warehouseTransaction/warehouseTrade/origAcctDate
origMonthlyAcctDateOptionaldate12102in_orig_monthly_acct_dateSTRADESDBOTRADEORIG_MONTHLY_ACCT_DATEDATENEagleML/warehouseTransaction/warehouseTrade/origMonthlyAcctDate
pendingTradeIdOptionalinteger12088in_pending_trade_idFTRADESDBOTRADEPENDING_TRADE_IDNUMBER(38)NEagleML/warehouseTransaction/warehouseTrade/pendingTradeId
qtyWashSaleEligibleOptionaldecimal12111in_qty_wash_sale_eligibleFTRADESDBOTRADEQTY_WASH_SALE_ELIGIBLENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/qtyWashSaleEligible
washSaleEligibleIndOptionalstring12120in_wash_sale_eligible_indicatorSTRADESDBOTRADEWASH_SALE_ELIGIBLE_INDICATORCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/washSaleEligibleInd
aiaNetBOptionaldecimal12252in_aia_net_bFTRADESDBOTRADE_DETAILAIA_NET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/aiaNetB
aiaNetLOptionaldecimal12253in_aia_net_lFTRADESDBOTRADE_DETAILAIA_NET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/aiaNetL
buySellFlagOptionalnormalizedString12006in_buy_sell_flagSTRADESDBOTRADEBUY_SELL_FLAGCHAR(4)NEagleML/warehouseTransaction/warehouseTrade/buySellFlag
bookValueOptionaldecimal4602in_book_valueFTRADESDBOTRADE_DETAILBOOK_VALUENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/bookValue
bookValueLocalOptionaldecimal4601in_book_value_localFTRADESDBOTRADE_DETAILBOOK_VALUE_LOCALNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/bookValueLocal
cpNetBOptionaldecimal12306in_cp_net_bFTRADESDBOTRADE_DETAILCP_NET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/cpNetB
cpNetLOptionaldecimal12307in_cp_net_lFTRADESDBOTRADE_DETAILCP_NET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/cpNetL
creditLossBOptionaldecimal12308in_credit_loss_bFTRADESDBOTRADE_DETAILCREDIT_LOSS_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/creditLossB
creditLossLOptionaldecimal12310in_credit_loss_lFTRADESDBOTRADE_DETAILCREDIT_LOSS_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/creditLossL
costBasisTypeOptionalstring24in_cost_basis_typeSTRADESDBOTRADECOST_BASIS_TYPECHAR(2)NEagleML/warehouseTransaction/warehouseTrade/costBasisType
futureFeeNetBOptionaldecimal12352in_future_fee_net_bFTRADESDBOTRADE_DETAILFUTURE_FEE_NET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/futureFeeNetB
futureFeeNetLOptionaldecimal12356in_future_fee_net_lFTRADESDBOTRADE_DETAILFUTURE_FEE_NET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/futureFeeNetL
impairmentLtdBaseOptionaldecimal13035in_impairment_ltd_baseFTRADESDBOTRADE_DETAILIMPAIRMENT_LTD_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentLtdBase
impairmentLtdLocalOptionaldecimal13036in_impairment_ltd_localFTRADESDBOTRADE_DETAILIMPAIRMENT_LTD_LOCALNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocal
mbaNetBOptionaldecimal13656in_mba_net_bFTRADESDBOTRADE_DETAILMBA_NET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/mbaNetB
mbaNetLOptionaldecimal13657in_mba_net_lFTRADESDBOTRADE_DETAILMBA_NET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/mbaNetL
naiaNetBOptionaldecimal13658in_naia_net_bFTRADESDBOTRADE_DETAILNAIA_NET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/naiaNetB
naiaNetLOptionaldecimal13659in_naia_net_lFTRADESDBOTRADE_DETAILNAIA_NET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/naiaNetL
nonCreditLossBOptionaldecimal13661in_non_credit_loss_bFTRADESDBOTRADE_DETAILNON_CREDIT_LOSS_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/nonCreditLossB
nonCreditLossLOptionaldecimal13662in_non_credit_loss_lFTRADESDBOTRADE_DETAILNON_CREDIT_LOSS_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/nonCreditLossL
bookCostOptionaldecimal12285in_book_costFTRADESDBOTRADE_DETAILBOOK_COSTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/bookCost
cashCategoryOptionalstring12128in_cash_categorySTRADESDBOTRADE_DETAILCASH_CATEGORYVARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/cashCategory
cancelTypeOptionalstring12127in_cancel_typeSTRADESDBOTRADE_DETAILCANCEL_TYPEVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/cancelType
exchangeFeeBaseOptionaldecimal13970in_exchange_fee_baseFTRADESDBOTRADEEXCHANGE_FEE_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/exchangeFeeBase
federalTaxWithholdBaseOptionaldecimal13969in_federal_tax_withhold_baseFTRADESDBOTRADEFEDERAL_TAX_WITHHOLD_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/federalTaxWithholdBase
mttypeOptionalstring13280in_mttypeSTRADESDBOTRADEMTTYPECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/mttype
netCashOptionaldecimal50in_net_cashFTRADESDBOTRADENET_CASHNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/netCash
origAcqDateOptionaldate216in_orig_acq_dateSTRADESDBOTRADEORIG_ACQ_DATEDATENEagleML/warehouseTransaction/warehouseTrade/origAcqDate
positionIdOptionalinteger12092in_position_idFTRADESDBOTRADEPOSITION_IDNUMBER(38)NEagleML/warehouseTransaction/warehouseTrade/positionId
scrubIdOptionalinteger12147in_scrub_idFTRADESDBOTRADESCRUB_IDNUMBERNEagleML/warehouseTransaction/warehouseTrade/scrubId
secFeesBaseOptionaldecimal12148in_sec_fees_baseFTRADESDBOTRADESEC_FEES_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/secFeesBase
termLoanFeeExpBOptionaldecimal12155in_term_loan_fee_exp_bFTRADESDBOTRADETERM_LOAN_FEE_EXP_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpB
termLoanFeeExpLOptionaldecimal12156in_term_loan_fee_exp_lFTRADESDBOTRADETERM_LOAN_FEE_EXP_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpL
termLoanFeeIncBOptionaldecimal12157in_term_loan_fee_inc_bFTRADESDBOTRADETERM_LOAN_FEE_INC_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncB
termLoanFeeIncLOptionaldecimal12158in_term_loan_fee_inc_lFTRADESDBOTRADETERM_LOAN_FEE_INC_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncL
targetEventIdOptionalTransactionId26in_target_event_idSTRADESDBOTRADETARGET_EVENT_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/targetEventId
updateUserIdOptionalstring12119in_update_user_idSTRADESDBOTRADEUPDATE_USER_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/updateUserId
updateSwitchOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/updateSwitch
accruedInterestOverrideOptionalstring12121in_accrued_interest_overrideSTRADESDBOTRADE_DETAILACCRUED_INTEREST_OVERRIDEVARCHAR2(20)NEagleML/warehouseTransaction/warehouseTrade/accruedInterestOverride
acquisitionTypeOptionalstring12122in_acquisition_typeSTRADESDBOTRADE_DETAILACQUISITION_TYPEVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/acquisitionType
amortizedCostPrevBaseOptionaldecimal12255in_amortized_cost_prev_bFTRADESDBOTRADE_DETAILAMORTIZED_COST_PREV_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevBase
amortizedCostPrevLocalOptionaldecimal12278in_amortized_cost_prev_lFTRADESDBOTRADE_DETAILAMORTIZED_COST_PREV_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevLocal
alluprateOptionaldecimal12254in_alluprateFTRADESDBOTRADE_DETAILALLUPRATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/alluprate
asOfTradeTimeOptionalstring12123in_as_of_trade_timeSTRADESDBOTRADE_DETAILAS_OF_TRADE_TIMEVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/asOfTradeTime
authorizedOptionalstring12124in_authorizedSTRADESDBOTRADE_DETAILAUTHORIZEDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/authorized
autoexTradeFlagOptionalYesNoOptionEnum12125in_autoex_trade_flagSTRADESDBOTRADE_DETAILAUTOEX_TRADE_FLAGVARCHAR2(20)NEagleML/warehouseTransaction/warehouseTrade/autoexTradeFlag
baseCommissionAmountOptionaldecimal12009in_base_commission_amountFTRADESDBOTRADEBASE_COMMISSION_AMOUNTNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/baseCommissionAmount
batchInstanceOptionalinteger126in_batch_instanceSTRADESDBOTRADEBATCH_INSTANCENUMBERNEagleML/warehouseTransaction/warehouseTrade/batchInstance
balanceOptionaldecimal12279in_balanceFTRADESDBOTRADE_DETAILBALANCENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/balance
bnchYld1Optionaldecimal12280in_bnch_yld1FTRADESDBOTRADE_DETAILBNCH_YLD1NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/bnchYld1
bnchYld2Optionaldecimal12281in_bnch_yld2FTRADESDBOTRADE_DETAILBNCH_YLD2NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/bnchYld2
bloombergProductOptionalstring12008in_bloomberg_productSTRADESDBOTRADEBLOOMBERG_PRODUCTCHAR(8)NEagleML/warehouseTransaction/warehouseTrade/bloombergProduct
buyToBaseFxRateOptionaldecimal12014in_buy_to_base_fx_rateFTRADESDBOTRADEBUY_TO_BASE_FX_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/buyToBaseFxRate
calcYieldIntIndicatorOptionalinteger12015in_calc_yield_int_indicatorFTRADESDBOTRADECALC_YIELD_INT_INDICATORNUMBERNEagleML/warehouseTransaction/warehouseTrade/calcYieldIntIndicator
cancelDueToCorrectionOptionalstring12021in_cancel_due_to_correctionSTRADESDBOTRADECANCEL_DUE_TO_CORRECTIONCHAR(4)NEagleML/warehouseTransaction/warehouseTrade/cancelDueToCorrection
cashflowdateOptionaldate12140in_cashflowdateSTRADESDBOTRADE_DETAILCASHFLOWDATEDATENEagleML/warehouseTransaction/warehouseTrade/cashflowdate
checkedOptionalstring12129in_checkedSTRADESDBOTRADE_DETAILCHECKEDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/checked
clearingBrokerOptionalstring1230in_clearing_brokerSTRADESDBOTRADE_DETAILCLEARING_BROKERCHAR(50)NEagleML/warehouseTransaction/warehouseTrade/clearingBroker
closeoutpl0Optionaldecimal12288in_closeoutpl0FTRADESDBOTRADE_DETAILCLOSEOUTPL0NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/closeoutpl0
closeoutpl1Optionaldecimal12292in_closeoutpl1FTRADESDBOTRADE_DETAILCLOSEOUTPL1NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/closeoutpl1
commentTypeOptionalstring12131in_comment_typeSTRADESDBOTRADE_DETAILCOMMENT_TYPECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/commentType
comparedOptionalstring12134in_comparedSTRADESDBOTRADE_DETAILCOMPAREDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/compared
compareddateOptionaldate12142in_compareddateSTRADESDBOTRADE_DETAILCOMPAREDDATEDATENEagleML/warehouseTransaction/warehouseTrade/compareddate
costPrevBaseOptionaldecimal12295in_cost_prev_baseFTRADESDBOTRADE_DETAILCOST_PREV_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/costPrevBase
costPrevLocalOptionaldecimal12296in_cost_prev_localFTRADESDBOTRADE_DETAILCOST_PREV_LOCALNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/costPrevLocal
cleanPriceOptionaldecimal12018in_clean_priceFTRADESDBOTRADECLEAN_PRICENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/cleanPrice
commissionCodeOptionalstring12023in_commission_codeSTRADESDBOTRADECOMMISSION_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/commissionCode
commissionReasonCodeOptionalstring12024in_commission_reason_codeSTRADESDBOTRADECOMMISSION_REASON_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/commissionReasonCode
commissionTypeCodeOptionalstring78in_commission_type_codeSTRADESDBOTRADECOMMISSION_TYPE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/commissionTypeCode
customerAcctNumbOptionalstring12025in_customer_acct_numbSTRADESDBOTRADECUSTOMER_ACCT_NUMBCHAR(30)NEagleML/warehouseTransaction/warehouseTrade/customerAcctNumb
dispBookValueGaapOptionaldecimal3766in_disp_book_value_gaapFTRADESDBOTRADE_DETAILDISP_BOOK_VALUE_GAAPNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/dispBookValueGaap
dispBookValueStatOptionaldecimal3767in_disp_book_value_statFTRADESDBOTRADE_DETAILDISP_BOOK_VALUE_STATNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/dispBookValueStat
disallowGainBOptionaldecimal12311in_disallow_gain_bFTRADESDBOTRADE_DETAILDISALLOW_GAIN_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/disallowGainB
disallowGainLOptionaldecimal12312in_disallow_gain_lFTRADESDBOTRADE_DETAILDISALLOW_GAIN_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/disallowGainL
disallowLossBOptionaldecimal12314in_disallow_loss_bFTRADESDBOTRADE_DETAILDISALLOW_LOSS_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/disallowLossB
disallowLossLOptionaldecimal12315in_disallow_loss_lFTRADESDBOTRADE_DETAILDISALLOW_LOSS_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/disallowLossL
dispAccruedIncomeOptionaldecimal12316in_disp_accrued_incomeFTRADESDBOTRADE_DETAILDISP_ACCRUED_INCOMENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/dispAccruedIncome
electedShareAmtOptionaldecimal12326in_elected_share_amtFTRADESDBOTRADE_DETAILELECTED_SHARE_AMTNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/electedShareAmt
electedSharePercOptionaldecimal12328in_elected_share_percFTRADESDBOTRADE_DETAILELECTED_SHARE_PERCNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/electedSharePerc
exchangeCodeTrdOptionalstring12176in_exchange_code_trdSTRADESDBOTRADE_DETAILEXCHANGE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/exchangeCodeTrd
exchangeCurrencyOptionalstring12177in_exchange_currencySTRADESDBOTRADE_DETAILEXCHANGE_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/exchangeCurrency
exchangeTypeCodeOptionalstring12178in_exchange_type_codeSTRADESDBOTRADE_DETAILEXCHANGE_TYPE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/exchangeTypeCode
exchangeCodeOptionalstring17in_exchange_codeSTRADESDBOTRADEEXCHANGE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/exchangeCode
exchangeFeeOptionaldecimal48in_exchange_feeFTRADESDBOTRADEEXCHANGE_FEENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/exchangeFee
fairMarketValueBaseOptionaldecimal12337in_fair_market_value_baseFTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/fairMarketValueBase
fairMarketValueFlagOptionalstring12179in_fair_market_value_flagSTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_FLAGVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/fairMarketValueFlag
fairMarketValueLocalOptionaldecimal12342in_fair_market_value_localFTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_LOCALNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/fairMarketValueLocal
fairMarketValuePriceOptionaldecimal12343in_fair_market_value_priceFTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_PRICENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/fairMarketValuePrice
feeamtOptionaldecimal12344in_feeamtFTRADESDBOTRADE_DETAILFEEAMTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/feeamt
feerateOptionaldecimal12351in_feerateFTRADESDBOTRADE_DETAILFEERATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/feerate
fromEffectiveDateOptionaldate12005in_from_effective_dateSTRADESDBOTRADEFROM_EFFECTIVE_DATEDATENEagleML/warehouseTransaction/warehouseTrade/fromEffectiveDate
fwdCleanPriceOptionaldecimal13968in_fwd_clean_priceFTRADESDBOTRADEFWD_CLEAN_PRICENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/fwdCleanPrice
gaapRealizedGlOptionaldecimal12358in_gaap_realized_glFTRADESDBOTRADE_DETAILGAAP_REALIZED_GLNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/gaapRealizedGl
gaapSecTypeOptionalstring12180in_gaap_sec_typeSTRADESDBOTRADE_DETAILGAAP_SEC_TYPECHAR(4)NEagleML/warehouseTransaction/warehouseTrade/gaapSecType
goodMillionNumOptionalinteger12361in_good_million_numFTRADESDBOTRADE_DETAILGOOD_MILLION_NUMNUMBERNEagleML/warehouseTransaction/warehouseTrade/goodMillionNum
haircutFlagOptionalYesNoOptionEnum12071in_haircut_flagSTRADESDBOTRADEHAIRCUT_FLAGVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/haircutFlag
haircutPctOptionaldecimal13967in_haircut_pctFTRADESDBOTRADEHAIRCUT_PCTNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/haircutPct
holdTradeStatusOptionalstring12072in_hold_trade_statusSTRADESDBOTRADEHOLD_TRADE_STATUSVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/holdTradeStatus
identifier2Optionalstring12181in_identifier2STRADESDBOTRADE_DETAILIDENTIFIER2VARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/identifier2
impairmentAmortOffsetBOptionaldecimal12362in_impairment_amort_offset_bFTRADESDBOTRADE_DETAILIMPAIRMENT_AMORT_OFFSET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetB
impairmentAmortOffsetLOptionaldecimal12363in_impairment_amort_offset_lFTRADESDBOTRADE_DETAILIMPAIRMENT_AMORT_OFFSET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetL
impairmentCostOffsetBOptionaldecimal12368in_impairment_cost_offset_bFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_OFFSET_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetB
impairmentCostOffsetLOptionaldecimal12370in_impairment_cost_offset_lFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_OFFSET_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetL
impairmentCostPrevBOptionaldecimal12383in_impairment_cost_prev_bFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_PREV_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevB
impairmentCostPrevLOptionaldecimal12384in_impairment_cost_prev_lFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_PREV_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevL
inceptionamtOptionaldecimal13651in_inceptionamtFTRADESDBOTRADE_DETAILINCEPTIONAMTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/inceptionamt
instructedOptionalstring12182in_instructedSTRADESDBOTRADE_DETAILINSTRUCTEDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/instructed
interestOptionaldecimal13652in_interestFTRADESDBOTRADE_DETAILINTERESTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/interest
invertFlagOptionalYesNoOptionEnum12073in_invert_flagSTRADESDBOTRADEINVERT_FLAGCHAR(4)NEagleML/warehouseTransaction/warehouseTrade/invertFlag
interestadjOptionaldecimal13653in_interestadjFTRADESDBOTRADE_DETAILINTERESTADJNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/interestadj
interestAdjBaseOptionaldecimal475in_baseinterestadjFTRADESDBOTRADE_DETAILBASEINTERESTADJNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/interestAdjBase
ledgerEffectiveDateOptionaldate36in_ledger_effective_dateSTRADESDBOTRADELEDGER_EFFECTIVE_DATEDATENEagleML/warehouseTransaction/warehouseTrade/ledgerEffectiveDate
ledgerDateOptionaldate12144in_ledger_dateSTRADESDBOTRADE_DETAILLEDGER_DATEDATENEagleML/warehouseTransaction/warehouseTrade/ledgerDate
letterconfirmOptionalstring12185in_letterconfirmSTRADESDBOTRADE_DETAILLETTERCONFIRMVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/letterconfirm
letteredOptionalstring12186in_letteredSTRADESDBOTRADE_DETAILLETTEREDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/lettered
lettereddateOptionaldate12145in_lettereddateSTRADESDBOTRADE_DETAILLETTEREDDATEDATENEagleML/warehouseTransaction/warehouseTrade/lettereddate
lmtGlElgOptionalstring12187in_lmt_gl_elgSTRADESDBOTRADE_DETAILLMT_GL_ELGVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/lmtGlElg
lmtGlIndOptionalstring12188in_lmt_gl_indSTRADESDBOTRADE_DETAILLMT_GL_INDVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/lmtGlInd
marginOptionaldecimal13654in_marginFTRADESDBOTRADE_DETAILMARGINNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/margin
marginpointsOptionaldecimal13655in_marginpointsFTRADESDBOTRADE_DETAILMARGINPOINTSNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/marginpoints
mortgageFlagOptionalYesNoOptionEnum12074in_mortgage_flagSTRADESDBOTRADEMORTGAGE_FLAGCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/mortgageFlag
muniFlagOptionalstring13281in_muni_flagSTRADESDBOTRADEMUNI_FLAGCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/muniFlag
netsettleamtOptionaldecimal191in_netsettleamtFTRADESDBOTRADE_DETAILNETSETTLEAMTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/netsettleamt
navIdOptionalinteger12080in_nav_idFTRADESDBOTRADENAV_IDNUMBER(28)NEagleML/warehouseTransaction/warehouseTrade/navId
numberOfAccuredDaysOptionaldecimal12081in_number_of_accured_daysFTRADESDBOTRADENUMBER_OF_ACCURED_DAYSNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/numberOfAccuredDays
netCashLocalOptionaldecimal13660in_net_cash_localFTRADESDBOTRADE_DETAILNET_CASH_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/netCashLocal
notionalamtOptionaldecimal13663in_notionalamtFTRADESDBOTRADE_DETAILNOTIONALAMTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/notionalamt
notionalflagOptionalstring12189in_notionalflagSTRADESDBOTRADE_DETAILNOTIONALFLAGCHAR(1)NEagleML/warehouseTransaction/warehouseTrade/notionalflag
otherFeeOptionaldecimal51in_other_feeFTRADESDBOTRADEOTHER_FEENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/otherFee
origTranNumOptionalstring12190in_orig_tran_numSTRADESDBOTRADE_DETAILORIG_TRAN_NUMVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/origTranNum
ownershipTransferDateOptionaldate12193in_ownership_transfer_dateSTRADESDBOTRADE_DETAILOWNERSHIP_TRANSFER_DATEDATENEagleML/warehouseTransaction/warehouseTrade/ownershipTransferDate
oidYieldOptionaldecimal12084in_oid_yieldFTRADESDBOTRADEOID_YIELDNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/oidYield
otherFeeBaseOptionaldecimal12085in_other_fee_baseFTRADESDBOTRADEOTHER_FEE_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/otherFeeBase
paceTradeEventIdOptionalstring13664in_pace_trade_event_idSTRADESDBOTRADE_DETAILPACE_TRADE_EVENT_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/paceTradeEventId
positionIdTrdOptionalinteger13665in_position_id_trdFTRADESDBOTRADE_DETAILPOSITION_IDNUMBER(38)NEagleML/warehouseTransaction/warehouseTrade/positionIdTrd
productSubTypeOptionalstring13667in_product_sub_typeSTRADESDBOTRADE_DETAILPRODUCT_SUB_TYPECHAR(12)NEagleML/warehouseTransaction/warehouseTrade/productSubType
poolNumberOptionalstring12095in_pool_numberSTRADESDBOTRADEPOOL_NUMBERCHAR(12)NEagleML/warehouseTransaction/warehouseTrade/poolNumber
priceCurrencyOptionalstring12096in_price_currencySTRADESDBOTRADEPRICE_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/priceCurrency
principalFactorOptionaldecimal4483in_principal_factorFTRADESDBOTRADEPRINCIPAL_FACTORNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/principalFactor
realizedGlBaseOptionaldecimal13668in_realized_gl_baseFTRADESDBOTRADE_DETAILREALIZED_GL_BASENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/realizedGlBase
realizedGlCrBOptionaldecimal13669in_realized_gl_cr_bFTRADESDBOTRADE_DETAILREALIZED_GL_CR_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/realizedGlCrB
realizedGlCrLOptionaldecimal13670in_realized_gl_cr_lFTRADESDBOTRADE_DETAILREALIZED_GL_CR_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/realizedGlCrL
realizedGlLocalOptionaldecimal13671in_realized_gl_localFTRADESDBOTRADE_DETAILREALIZED_GL_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/realizedGlLocal
realizedGlNcrBOptionaldecimal13672in_realized_gl_ncr_bFTRADESDBOTRADE_DETAILREALIZED_GL_NCR_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/realizedGlNcrB
realizedGlNcrLOptionaldecimal13673in_realized_gl_ncr_lFTRADESDBOTRADE_DETAILREALIZED_GL_NCR_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/realizedGlNcrL
recdPayAcct1Optionalstring12208in_recd_pay_acct1STRADESDBOTRADE_DETAILRECD_PAY_ACCT1VARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/recdPayAcct1
recdPayAcct2Optionalstring12209in_recd_pay_acct2STRADESDBOTRADE_DETAILRECD_PAY_ACCT2VARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/recdPayAcct2
recdPayEventTypeOptionalstring12210in_recd_pay_event_typeSTRADESDBOTRADE_DETAILRECD_PAY_EVENT_TYPEVARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/recdPayEventType
recdPayPostingPlanTypeOptionalstring12211in_recd_pay_posting_plan_typeSTRADESDBOTRADE_DETAILRECD_PAY_POSTING_PLAN_TYPEVARCHAR2(50)NEagleML/warehouseTransaction/warehouseTrade/recdPayPostingPlanType
refrateOptionaldecimal13674in_refrateFTRADESDBOTRADE_DETAILREFRATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/refrate
repoRateOptionaldecimal12146in_repo_rateFTRADESDBOTRADEREPO_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/repoRate
retailFeedOptionalstring12212in_retail_feedSTRADESDBOTRADE_DETAILRETAIL_FEEDVARCHAR2(20)NEagleML/warehouseTransaction/warehouseTrade/retailFeed
salesPersonLoginOptionalstring12213in_sales_person_loginSTRADESDBOTRADE_DETAILSALES_PERSON_LOGINVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/salesPersonLogin
secidTypeOptionalstring12222in_secid_typeSTRADESDBOTRADE_DETAILSECID_TYPEVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/secidType
sequencedateOptionaldate12195in_sequencedateSTRADESDBOTRADE_DETAILSEQUENCEDATEDATENEagleML/warehouseTransaction/warehouseTrade/sequencedate
settleamt0Optionaldecimal13675in_settleamt0FTRADESDBOTRADE_DETAILSETTLEAMT0NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/settleamt0
settleamt1Optionaldecimal13676in_settleamt1FTRADESDBOTRADE_DETAILSETTLEAMT1NUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/settleamt1
settledOptionalstring12223in_settledSTRADESDBOTRADE_DETAILSETTLEDVARCHAR2(10)NEagleML/warehouseTransaction/warehouseTrade/settled
settleAmtAtMaturityOptionaldecimal12150in_settle_amt_at_maturityFTRADESDBOTRADESETTLE_AMT_AT_MATURITYNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/settleAmtAtMaturity
settlementMethodOptionalstring12103in_settlement_methodSTRADESDBOTRADESETTLEMENT_METHODCHAR(8)NEagleML/warehouseTransaction/warehouseTrade/settlementMethod
shortTermIdOptionalinteger12151in_short_term_idFTRADESDBOTRADESHORT_TERM_IDNUMBERNEagleML/warehouseTransaction/warehouseTrade/shortTermId
sourceSystemOptionalstring12104in_source_systemSTRADESDBOTRADESOURCE_SYSTEMVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/sourceSystem
systemTradeTimeOptionalstring12228in_system_trade_timeSTRADESDBOTRADE_DETAILSYSTEM_TRADE_TIMEVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/systemTradeTime
sentTradeStatusOptionalstring12099in_sent_trade_statusSTRADESDBOTRADESENT_TRADE_STATUSVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/sentTradeStatus
starTag151Optionalstring151in_star_tag151STRADESDBOTRADESTAR_TAG151VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/starTag151
starTag182Optionalstring182in_star_tag182STRADESDBOTRADESTAR_TAG182VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/starTag182
stateTaxWithholdBaseOptionaldecimal12152in_state_tax_withhold_baseFTRADESDBOTRADESTATE_TAX_WITHHOLD_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/stateTaxWithholdBase
starLsIndOptionalstring15in_star_ls_indSTRADESDBOTRADESTAR_LS_INDVARCHAR2(1)NEagleML/warehouseTransaction/warehouseTrade/starLsInd
targetPurchaseDateOptionaldate12136in_target_purchase_dateSTRADESDBOTRADETARGET_PURCHASE_DATEDATENEagleML/warehouseTransaction/warehouseTrade/targetPurchaseDate
targetPurchasePriceOptionaldecimal12153in_target_purchase_priceFTRADESDBOTRADETARGET_PURCHASE_PRICENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/targetPurchasePrice
targetTradeTicketNumberOptionalstring12110in_target_trade_ticket_numberSTRADESDBOTRADETARGET_TRADE_TICKET_NUMBERVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/targetTradeTicketNumber
taxesBaseOptionaldecimal12154in_taxes_baseFTRADESDBOTRADETAXES_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/taxesBase
timeOfTradeOptionaldecimal12159in_time_of_tradeFTRADESDBOTRADETIME_OF_TRADENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/timeOfTrade
toFxRateOptionaldecimal12160in_to_fx_rateFTRADESDBOTRADETO_FX_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/toFxRate
toLocalCommissionAmtOptionaldecimal12161in_to_local_commission_amtFTRADESDBOTRADETO_LOCAL_COMMISSION_AMTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/toLocalCommissionAmt
toSettleToBaseFxRateOptionaldecimal12162in_to_settle_to_base_fx_rateFTRADESDBOTRADETO_SETTLE_TO_BASE_FX_RATENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/toSettleToBaseFxRate
toSettlementCurrencyOptionalstring12112in_to_settlement_currencySTRADESDBOTRADETO_SETTLEMENT_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/toSettlementCurrency
transactionIdOptionalstring12117in_transaction_idSTRADESDBOTRADETRANSACTION_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/transactionId
turnaroundIndicatorOptionalstring12118in_turnaround_indicatorSTRADESDBOTRADETURNAROUND_INDICATORVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/turnaroundIndicator
totalGainLocalOptionaldecimal10050in_total_gain_localFTRADESDBOTRADE_DETAILTOTAL_GAIN_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/totalGainLocal
totalAmortLocalOptionaldecimal5685in_total_amort_localFTRADESDBOTRADE_DETAILTOTAL_AMORT_LOCALNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/totalAmortLocal
totalAmortBaseOptionaldecimal5686in_total_amort_baseFTRADESDBOTRADE_DETAILTOTAL_AMORT_BASENUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/totalAmortBase
totalLossLocalOptionaldecimal10053in_total_loss_localFTRADESDBOTRADE_DETAILTOTAL_LOSS_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/totalLossLocal
tdUserChar1Optionalstring12229in_td_user_char1STRADESDBOTRADE_DETAILTD_USER_CHAR1VARCHAR2(8)NEagleML/warehouseTransaction/warehouseTrade/tdUserChar1
tdUserChar2Optionalstring12230in_td_user_char2STRADESDBOTRADE_DETAILTD_USER_CHAR2VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/tdUserChar2
tdUserDate1Optionaldate12196in_td_user_date1STRADESDBOTRADE_DETAILTD_USER_DATE1DATENEagleML/warehouseTransaction/warehouseTrade/tdUserDate1
tdUserDate2Optionaldate12202in_td_user_date2STRADESDBOTRADE_DETAILTD_USER_DATE2DATENEagleML/warehouseTransaction/warehouseTrade/tdUserDate2
tdUserInt1Optionalinteger13677in_td_user_int1FTRADESDBOTRADE_DETAILTD_USER_INT1NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt1
tdUserInt2Optionalinteger13678in_td_user_int2FTRADESDBOTRADE_DETAILTD_USER_INT2NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt2
tdUserInt3Optionalinteger13679in_td_user_int3FTRADESDBOTRADE_DETAILTD_USER_INT3NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt3
tdUserInt4Optionalinteger13680in_td_user_int4FTRADESDBOTRADE_DETAILTD_USER_INT4NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt4
tdUserInt5Optionalinteger13681in_td_user_int5FTRADESDBOTRADE_DETAILTD_USER_INT5NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt5
tdUserInt6Optionalinteger13682in_td_user_int6FTRADESDBOTRADE_DETAILTD_USER_INT6NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt6
tdUserInt7Optionalinteger13683in_td_user_int7FTRADESDBOTRADE_DETAILTD_USER_INT7NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt7
tdUserInt8Optionalinteger13684in_td_user_int8FTRADESDBOTRADE_DETAILTD_USER_INT8NUMBERNEagleML/warehouseTransaction/warehouseTrade/tdUserInt8
tradeMemo3Optionalstring12238in_trade_memo3STRADESDBOTRADE_DETAILTRADE_MEMO3VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/tradeMemo3
tradeMemo4Optionalstring12239in_trade_memo4STRADESDBOTRADE_DETAILTRADE_MEMO4VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/tradeMemo4
tradeMemo5Optionalstring502in_trade_memo5STRADESDBOTRADE_DETAILTRADE_MEMO5VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/tradeMemo5
thirdCurrencyFxOptionaldecimal13685in_third_currency_fxFTRADESDBOTRADE_DETAILTHIRD_CURRENCY_FXNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/thirdCurrencyFx
timeOfSalesTicketOptionalstring12232in_time_of_sales_ticketSTRADESDBOTRADE_DETAILTIME_OF_SALES_TICKETVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/timeOfSalesTicket
timeOfSlateOptionalstring12233in_time_of_slateSTRADESDBOTRADE_DETAILTIME_OF_SLATEVARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/timeOfSlate
tradeChar1Optionalstring12113in_trade_char1STRADESDBOTRADETRADE_CHAR1VARCHAR2(30)NEagleML/warehouseTransaction/warehouseTrade/tradeChar1
tradeFlatOptionalstring12114in_trade_flatSTRADESDBOTRADETRADE_FLATCHAR(2)NEagleML/warehouseTransaction/warehouseTrade/tradeFlat
tradersLoginOptionalstring12116in_traders_loginSTRADESDBOTRADETRADERS_LOGINCHAR(12)NEagleML/warehouseTransaction/warehouseTrade/tradersLogin
transcost4AmountOptionaldecimal13686in_transcost4_amountFTRADESDBOTRADE_DETAILTRANSCOST4_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/transcost4Amount
transcost4CodeOptionalstring12240in_transcost4_codeSTRADESDBOTRADE_DETAILTRANSCOST4_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/transcost4Code
transcost4CurrencyOptionalstring12241in_transcost4_currencySTRADESDBOTRADE_DETAILTRANSCOST4_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/transcost4Currency
transcost4TypeCodeOptionalstring12242in_transcost4_type_codeSTRADESDBOTRADE_DETAILTRANSCOST4_TYPE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/transcost4TypeCode
transcost5AmountOptionaldecimal13687in_transcost5_amountFTRADESDBOTRADE_DETAILTRANSCOST5_AMOUNTNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/transcost5Amount
transcost5CodeOptionalstring12243in_transcost5_codeSTRADESDBOTRADE_DETAILTRANSCOST5_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/transcost5Code
transcost5CurrencyOptionalstring12244in_transcost5_currencySTRADESDBOTRADE_DETAILTRANSCOST5_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/transcost5Currency
transcost5TypeCodeOptionalstring12245in_transcost5_type_codeSTRADESDBOTRADE_DETAILTRANSCOST5_TYPE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/transcost5TypeCode
updateSourceTrdOptionalstring12261in_update_source_trdSTRADESDBOTRADE_DETAILUPDATE_SOURCECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/updateSourceTrd
underlyingAccrIntBOptionaldecimal12164in_underlying_accr_int_bFTRADESDBOTRADEUNDERLYING_ACCR_INT_BNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntB
underlyingAccrIntLOptionaldecimal12165in_underlying_accr_int_lFTRADESDBOTRADEUNDERLYING_ACCR_INT_LNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntL
underlyingAccrIntLMatOptionaldecimal12201in_underlying_accr_int_l_matFTRADESDBOTRADEUNDERLYING_ACCR_INT_L_MATNUMBER(38,12)NEagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntLMat
withholdCodeOptionalstring12263in_withhold_codeSTRADESDBOTRADE_DETAILWITHHOLD_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/withholdCode
withholdCurrencyOptionalstring12264in_withhold_currencySTRADESDBOTRADE_DETAILWITHHOLD_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/withholdCurrency
withholdTypeCodeOptionalstring12265in_withhold_type_codeSTRADESDBOTRADE_DETAILWITHHOLD_TYPE_CODECHAR(8)NEagleML/warehouseTransaction/warehouseTrade/withholdTypeCode
workoutDateOptionaldate12214in_workout_dateSTRADESDBOTRADE_DETAILWORKOUT_DATEDATENEagleML/warehouseTransaction/warehouseTrade/workoutDate
workoutPriceOptionaldecimal13689in_workout_priceFTRADESDBOTRADE_DETAILWORKOUT_PRICENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/workoutPrice
withholdingTaxOptionaldecimal12216in_withholding_taxFTRADESDBOTRADEWITHHOLDING_TAXNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/withholdingTax
batchEventIdOptionalstring701in_batch_event_idSTRADESDBOTRADE_DETAILBATCH_EVENT_IDVARCHAR2(55)NEagleML/warehouseTransaction/warehouseTrade/batchEventId
secFeeOptionaldecimal3752in_sec_feesFTRADESDBOTRADESEC_FEESNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/secFee
tradeDateOptionaldate35in_trade_dateSTRADESDBOTRADETRADE_DATEDATENEagleML/warehouseTransaction/warehouseTrade/tradeDate
recordTypeOptionalstring12097in_record_typeSTRADESDBOTRADERECORD_TYPECHAR(4)NEagleML/warehouseTransaction/warehouseTrade/recordType
costLocal*
(supported in  2017R1)		Optionaldecimal162in_cost_localFTRADESDBOTRADECOST_LOCALNUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/costLocal
costBase*  
(supported in  2017R1)		Optionaldecimal166in_cost_baseFTRADESDBOTRADECOST_BASENUMBER(28,12)NEagleML/warehouseTransaction/warehouseTrade/costBase
linkEventIdOptionalTransactionId28in_link_event_idSTRADESDBOTRADELINK_EVENT_IDVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/linkEventId
localCurrencyOptionalCurrencyCode   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/localCurrency
commissionCurrencyOptionalCurrencyCode85  TRADESDBOTRADECOMMISSION_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/commissionCurrency
eventSequenceOptionalinteger126  TRADESDBOTRADEEVENT_SEQUENCEINTEGERNEagleML/warehouseTransaction/warehouseTrade/eventSequence
starTag26Optionalstring26  TRADESDBOTRADESTAR_TAG26VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/starTag26
tradeCurrencyOptionalCurrencyCode85  TRADESDBOTRADETRADE_CURRENCYCHAR(3)NEagleML/warehouseTransaction/warehouseTrade/tradeCurrency
settleInstructions1* 
(supported in  2017R1)		Optionalstring8074in_settle_instructions1STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS1VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settleInstructions1
settleInstructions2*  
(supported in  2017R1)		Optionalstring8075in_settle_instructions2STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS2VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settleInstructions2
settleInstructions3* 
(supported in  2017R1)		Optionalstring8076in_settle_instructions3STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS3VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settleInstructions3
settleInstructions4*
(supported in  2017R1)		Optionalstring8077in_settle_instructions4STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS4VARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/settleInstructions4
orderNumber*
(supported in  2017R1)		Optionalstring1092in_order_number TRADESDBOTRADEORDER_NUMBERVARCHAR2(255)NEagleML/warehouseTransaction/warehouseTrade/orderNumber
priceMethod*
(supported in  2017R1)		OptionalnormalizedString1872in_price_methodSTRADESDBOTRADEPRICE_METHODVARCHAR2(4)NEagleML/warehouseTransaction/warehouseTrade/priceMethod
regulatoryIntent*
(supported in  2017R1)		OptionalnormalizedString8915in_regulatory_intentSTRADESDBOTRADEREGULATORY_INTENTVARCHAR2(3)NEagleML/warehouseTransaction/warehouseTrade/regulatoryIntent
holdingTerm*
(supported in  2017R1)		OptionalnormalizedString9091in_holding_termSTRADESDBOTRADEHOLDING_TERMVARCHAR2(2)NEagleML/warehouseTransaction/warehouseTrade/holdingTerm
deskAkaOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/deskAka
deskTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/deskType
deskOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/desk
exSubBrokerIdOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/exSubBrokerId
placementNumOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/placementNum
subBrokerCodeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/subBrokerCode
tradeInterfaceInfoOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/tradeInterfaceInfo
trdBrokerAkaOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdBrokerAka
trdDirtyPriceOptionaldecimal   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdDirtyPrice
trdExBrokerDeskOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExBrokerDesk
trdExDeskTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExDeskType
trdExternalAccountLocOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExternalAccountLoc
trdLocationOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdLocation
trdSeriesNumOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdSeriesNum
trdVersionOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdVersion
trdExtidId1Optionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExtidId1
trdExtidId2Optionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExtidId2
tbaInvnumOptionalinteger   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/tbaInvnum
tbaTrdDateOptionaldate   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/tbaTrdDate
collatExposureTypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/collatExposureType
effTermDateOptionaldate   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/effTermDate
contractRefOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/contractRef
trdExternalId1TypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExternalId1Type
trdExternalId2TypeOptionalstring   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/trdExternalId2Type
TradeChargesModelOptionalTradeChargesModel   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/TradeChargesModel
TradeQuotesModelOptionalTradeQuotesModel   not stored in DB  EagleML/warehouseTransaction/warehouseTrade/TradeQuotesModel
To add the elements below, please set IncludeExtendedDetails=ALL or IncludeExtendedDetails=Y in the RTR
calcTransactionIdOptionalstring2983       EagleML/warehouseTransaction/warehouseTrade/calcTransactionId
calcMasterTransactionIdOptionalstring2984MASTER_TXN_ID      EagleML/warehouseTransaction/warehouseTrade/calcMasterTransactionId
calcCancelTransactionIdOptionalstring2985CXL_TARGET_ID      EagleML/warehouseTransaction/warehouseTrade/calcCancelTransactionId
  • No labels