Versions Compared

Key

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

...

     singleRowCommitFlag
ElementOptional/RequiredValue TypeStar TagSP ParameterSP TypeEagle DatabaseDatabase TableDatabase FieldDB TypeXpath
objectTypeOptionalobjectType   


not stored in DB 
EagleML/warehouseTransaction/warehousePendingTrade/objectType
objectIdOptionalobjectId   


not stored in DB
EagleML/warehouseTransaction/warehousePendingTrade/objectId
objectDescriptionOptionalobjectDescription   


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


TRADESDBOPENDING_TRADESUPDATE_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/updateTimestamp
customElementsNot recommendedCustomElements   


reserved for customizations
EagleML/warehouseTransaction/warehousePendingTrade/customElements
sourceNameOptionalstring1102IN_SRC_INTFC_INSTSPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/warehouseTransaction/warehousePendingTrade/sourceName
updateSourceOptionalstring944in_update_sourceSTRADESDBOPENDING_TRADESUPDATE_SOURCEVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/updateSource
batchCollectErrorsFlagOptionalYesNoOptionEnum   


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


not stored in DB
EagleML/warehouseTransaction/warehousePendingTrade/singleRowCommitFlag
reportTypeOptionalnormalizedString


not stored in DB
EagleML/warehouseTransaction/warehousePendingTrade/reportType
effectiveDateOptionaldate1109in_effective_dateSTRADESDBOPENDING_TRADESEFFECTIVE_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/effectiveDate
Entity Common Id ModelEagleML/warehouseTransaction/warehousePendingTrade/
Entity Properties Model (extract only)EagleML/warehouseTransaction/warehousePendingTrade/
Asset Identifiers ModelEagleML/warehouseTransaction/warehousePendingTrade/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/warehousePendingTrade/
maturityDateOptionaldate   


not stored in DB 
EagleML/warehouseTransaction/warehousePendingTrade/maturityDate
accountBasisOptionalnormalizedString21in_acct_basisSTRADESDBOPENDING_TRADESACCT_BASISVARCHAR2(5)EagleML/warehouseTransaction/warehousePendingTrade/accountBasis
accruedInterestTypeOptionalnormalizedString3715in_accrued_interest_typeSTRADESDBOPENDING_TRADESACCRUED_INTEREST_TYPEVARCHAR2(3)EagleML/warehouseTransaction/warehousePendingTrade/accruedInterestType
acquisitionTypeOptionalnormalizedString2425in_acquisition_typeSTRADESDBOPENDING_TRADESACQUISITION_TYPEVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/acquisitionType
amortAtDispLtdBOptionaldecimal5549in_amort_at_disp_ltd_bFTRADESDBOPENDING_TRADESAMORT_AT_DISP_LTD_BNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/amortAtDispLtdB
amortAtDispLtdLOptionaldecimal5548in_amort_at_disp_ltd_lFTRADESDBOPENDING_TRADESAMORT_AT_DISP_LTD_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/amortAtDispLtdL
amortYieldOptionaldecimal75in_amort_yieldFTRADESDBOPENDING_TRADESAMORT_YIELDNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/amortYield
autoSettleIndicatorOptionalnormalizedString58in_auto_settle_indSTRADESDBOPENDING_TRADESAUTO_SETTLE_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/autoSettleIndicator
backupWithholdingLOptionaldecimal2712in_backup_withholding_lFTRADESDBOPENDING_TRADESBACKUP_WITHHOLDING_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/backupWithholdingL
bankAliasOptionalinteger16in_bank_aliasFTRADESDBOPENDING_TRADESBANK_ALIASNUMBER(38,0)EagleML/warehouseTransaction/warehousePendingTrade/bankAlias
batchEventIdOptionalstring 
in_batch_event_idSTRADESDBOPENDING_TRADESBATCH_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/batchEventId
brokerCodeOptionalstring88in_broker_codeSTRADESDBOPENDING_TRADESBROKER_CODEVARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/brokerCode
brokerNameOptionalstring 
in_broker_nameSTRADESDBOPENDING_TRADESBROKER_NAMEVARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/brokerName
buyToBaseFxRateOptionaldecimal 
in_buy_to_base_fx_rateFTRADESDBOPENDING_TRADESBUY_TO_BASE_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/buyToBaseFxRate
cancelEventIdOptionalstring 
in_cancel_event_idSTRADESDBOPENDING_TRADESCANCEL_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/cancelEventId
capExpFeesFlagOptionalnormalizedString 
in_cap_exp_fees_flagSTRADESDBOPENDING_TRADESCAP_EXP_FEES_FLAGVARCHAR2(2)EagleML/warehouseTransaction/warehousePendingTrade/capExpFeesFlag
cashCategoryOptionalstring62in_cash_categorySTRADESDBOPENDING_TRADESCASH_CATEGORYVARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/cashCategory
cashEventTypeOptionalstring53in_cash_event_typeSTRADESDBOPENDING_TRADESCASH_EVENT_TYPEVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/cashEventType
clearingBrokerCodeOptionalstring1237in_clearing_broker_codeSTRADESDBOPENDING_TRADESCLEARING_BROKER_CODEVARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/clearingBrokerCode
clearingBrokerNameOptionalstring 
in_clearing_broker_nameSTRADESDBOPENDING_TRADESCLEARING_BROKER_NAMEVARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/clearingBrokerName
commentsOptionalstring12075in_commentsSTRADESDBOPENDING_TRADESCOMMENTSVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/comments
commissionAmountLocalOptionaldecimal 
in_commission_amount_localFTRADESDBOPENDING_TRADESCOMMISSION_AMOUNT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/commissionAmountLocal
conversionPremiumOptionaldecimal5727in_conversion_premiumFTRADESDBOPENDING_TRADESCONVERSION_PREMIUMNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/conversionPremium
costBasisCoverLotFlagOptionalnormalizedString2819in_cost_basis_cover_lot_flagSTRADESDBOPENDING_TRADESCOST_BASIS_COVER_LOT_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/costBasisCoverLotFlag
costBasisTypeOptionalnormalizedString24in_cost_basis_typeSTRADESDBOPENDING_TRADESCOST_BASIS_TYPEVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/costBasisType
coveredLotOverrideFlagOptionalnormalizedString2820in_covered_lot_override_flagSTRADESDBOPENDING_TRADESCOVERED_LOT_OVERRIDE_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/coveredLotOverrideFlag
custodyBankAccountNumberOptionalstring1660in_custody_bank_acct_numSTRADESDBOPENDING_TRADESCUSTODY_BANK_ACCT_NUMVARCHAR2(30)EagleML/warehouseTransaction/warehousePendingTrade/custodyBankAccountNumber
custodyBankCodeOptionalstring 
in_custody_bank_codeSTRADESDBOPENDING_TRADESCUSTODY_BANK_CODECHAR(20)EagleML/warehouseTransaction/warehousePendingTrade/custodyBankCode
custodyBankDescOptionalstring 
in_custody_bank_descSTRADESDBOPENDING_TRADESCUSTODY_BANK_DESCVARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/custodyBankDesc
custodyBankSubAccountOptionalstring1661in_custody_bank_sub_acctSTRADESDBOPENDING_TRADESCUSTODY_BANK_SUB_ACCTVARCHAR2(10)EagleML/warehouseTransaction/warehousePendingTrade/custodyBankSubAccount
deferredIncReceivBOptionaldecimal11572in_deferred_inc_receiv_bFTRADESDBOPENDING_TRADESDEFERRED_INC_RECEIV_BNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/deferredIncReceivB
deferredIncReceivLOptionaldecimal11571in_deferred_inc_receiv_lFTRADESDBOPENDING_TRADESDEFERRED_INC_RECEIV_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/deferredIncReceivL
eventIdOptionalstring25in_event_idSTRADESDBOPENDING_TRADESEVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/eventId
eventIdSwitchOptionalnormalizedString8087in_event_id_switchSTRADESDBOPENDING_TRADESEVENT_ID_SWITCHVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/eventIdSwitch
eventSubPriorityOptionalinteger2862in_event_sub_priorityFTRADESDBOPENDING_TRADESEVENT_SUB_PRIORITYNUMBER(38,0)EagleML/warehouseTransaction/warehousePendingTrade/eventSubPriority
eventTypeOptionalstring55in_event_typeSTRADESDBOPENDING_TRADESEVENT_TYPEVARCHAR2(55)EagleML/warehouseTransaction/warehousePendingTrade/eventType
exchangeCodeOptionalstring9036in_exchange_codeSTRADESDBOPENDING_TRADESEXCHANGE_CODEVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/exchangeCode
exchangeFeeLocalOptionaldecimal 
in_exchange_fee_localFTRADESDBOPENDING_TRADESEXCHANGE_FEE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/exchangeFeeLocal
exportBatchIdOptionalstring 
in_export_batch_idSTRADESDBOPENDING_TRADESEXPORT_BATCH_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/exportBatchId
factorOptionaldecimal91in_factorFTRADESDBOPENDING_TRADESFACTORNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/factor
factorDateOptionaldate105in_factor_dateSTRADESDBOPENDING_TRADESFACTOR_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/factorDate
fairMarketValueBaseOptionaldecimal2429in_fair_market_value_baseFTRADESDBOPENDING_TRADESFAIR_MARKET_VALUE_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValueBase
fairMarketValueFlagOptionalnormalizedString2427in_fair_market_value_flagSTRADESDBOPENDING_TRADESFAIR_MARKET_VALUE_FLAGVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValueFlag
fairMarketValueLocalOptionaldecimal2428in_fair_market_value_localFTRADESDBOPENDING_TRADESFAIR_MARKET_VALUE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValueLocal
fairMarketValuePriceOptionaldecimal2452in_fair_market_value_priceFTRADESDBOPENDING_TRADESFAIR_MARKET_VALUE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValuePrice
fromAutoSettleIndOptionalnormalizedString383in_from_auto_settle_indSTRADESDBOPENDING_TRADESFROM_AUTO_SETTLE_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/fromAutoSettleInd
fromCashEventTypeOptionalstring378in_from_cash_event_typeSTRADESDBOPENDING_TRADESFROM_CASH_EVENT_TYPEVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/fromCashEventType
fromEntityIdOptionalstring 
in_from_entity_idSTRADESDBOPENDING_TRADESFROM_ENTITY_IDCHAR(8)EagleML/warehouseTransaction/warehousePendingTrade/fromEntityId
fromLongShortIndicatorOptionalnormalizedString355in_from_long_short_indicatorSTRADESDBOPENDING_TRADESFROM_LONG_SHORT_INDICATORVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/fromLongShortIndicator
fromNetAmountLocalOptionaldecimal 
in_from_net_amount_localFTRADESDBOPENDING_TRADESFROM_NET_AMOUNT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/fromNetAmountLocal
fromQuantityOptionaldecimal 
in_from_quantityFTRADESDBOPENDING_TRADESFROM_QUANTITYNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/fromQuantity
fromSecurityAliasOptionalinteger 
in_from_security_aliasFTRADESDBOPENDING_TRADESFROM_SECURITY_ALIASNUMBER(38,0)EagleML/warehouseTransaction/warehousePendingTrade/fromSecurityAlias
fromWashSaleEligibleIndicatorOptionalnormalizedString384in_from_wash_sale_elgbl_indSTRADESDBOPENDING_TRADESFROM_WASH_SALE_ELGBL_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/fromWashSaleEligibleIndicator
holdingPeriodDateOptionaldate3899in_holding_period_dateSTRADESDBOPENDING_TRADESHOLDING_PERIOD_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/holdingPeriodDate
ilbCloseIndexRatioOptionaldecimal4540in_ilb_close_index_ratioFTRADESDBOPENDING_TRADESILB_CLOSE_INDEX_RATIONUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/ilbCloseIndexRatio
ilbConvertedIncBOptionaldecimal11516in_ilb_converted_inc_bFTRADESDBOPENDING_TRADESILB_CONVERTED_INC_BNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/ilbConvertedIncB
ilbConvertedIncLOptionaldecimal11508in_ilb_converted_inc_lFTRADESDBOPENDING_TRADESILB_CONVERTED_INC_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/ilbConvertedIncL
ilbIndexRatioOptionaldecimal4483in_ilb_index_ratioFTRADESDBOPENDING_TRADESILB_INDEX_RATIONUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/ilbIndexRatio
ilbOrigAcquireIndexOptionaldecimal11509in_ilb_orig_acq_indexFTRADESDBOPENDING_TRADESILB_ORIG_ACQ_INDEXNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/ilbOrigAcquireIndex
impliedCommissionOptionalnormalizedString78in_implied_commissionSTRADESDBOPENDING_TRADESIMPLIED_COMMISSIONVARCHAR2(3)EagleML/warehouseTransaction/warehousePendingTrade/impliedCommission
ledgerEffectiveDateOptionaldate3739in_ledger_effective_dateSTRADESDBOPENDING_TRADESLEDGER_EFFECTIVE_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/ledgerEffectiveDate
letterOfAutorizationOptionalnormalizedString 
in_letter_of_autorizationSTRADESDBOPENDING_TRADESLETTER_OF_AUTORIZATIONVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/letterOfAutorization
linkEventIdOptionalstring28in_link_event_idSTRADESDBOPENDING_TRADESLINK_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/linkEventId
localToBaseFxRateOptionaldecimal 
in_local_to_base_fx_rateFTRADESDBOPENDING_TRADESLOCAL_TO_BASE_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/localToBaseFxRate
longShortIndicatorOptionalnormalizedString15in_long_short_indicatorSTRADESDBOPENDING_TRADESLONG_SHORT_INDICATORVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/longShortIndicator
lotSelectionMethodOptionalstring27in_lot_selection_methodSTRADESDBOPENDING_TRADESLOT_SELECTION_METHODVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/lotSelectionMethod
monthlyAccountDateOptionaldate5022in_monthly_acct_dateSTRADESDBOPENDING_TRADESMONTHLY_ACCT_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/monthlyAccountDate
mttypeOptionalstring3822in_mttypeSTRADESDBOPENDING_TRADESMTTYPEVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/mttype
navIdOptionalinteger3196in_nav_idFTRADESDBOPENDING_TRADESNAV_IDNUMBER(38,0)EagleML/warehouseTransaction/warehousePendingTrade/navId
netAmountBaseOptionaldecimal478in_net_amount_baseFTRADESDBOPENDING_TRADESNET_AMOUNT_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/netAmountBase
netAmountLocalOptionaldecimal50in_net_amount_localFTRADESDBOPENDING_TRADESNET_AMOUNT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/netAmountLocal
oidYieldOptionaldecimal39in_oid_yieldFTRADESDBOPENDING_TRADESOID_YIELDNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/oidYield
optionSettlementMethodOptionalstring 
in_option_settlement_methodSTRADESDBOPENDING_TRADESOPTION_SETTLEMENT_METHODVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/optionSettlementMethod
orderNumberOptionalstring1092in_order_numberSTRADESDBOPENDING_TRADESORDER_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/orderNumber
origAcquireCostBaseOptionaldecimal5872in_orig_acq_cost_baseFTRADESDBOPENDING_TRADESORIG_ACQ_COST_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/origAcquireCostBase
origAcquireCostLocalOptionaldecimal 
in_orig_acq_cost_localFTRADESDBOPENDING_TRADESORIG_ACQ_COST_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/origAcquireCostLocal
origAcquireDateOptionaldate 
in_orig_acq_dateSTRADESDBOPENDING_TRADESORIG_ACQ_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/origAcquireDate
originalEventIdOptionalstring457in_original_event_idSTRADESDBOPENDING_TRADESORIGINAL_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/originalEventId
originalFaceValueOptionaldecimal 
in_original_face_valueFTRADESDBOPENDING_TRADESORIGINAL_FACE_VALUENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/originalFaceValue
originalUpdateSourceOptionalstring4488in_original_update_sourceSTRADESDBOPENDING_TRADESORIGINAL_UPDATE_SOURCEVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/originalUpdateSource
origSettlementDateOptionaldate9264in_orig_settlement_dateSTRADESDBOPENDING_TRADESORIG_SETTLEMENT_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/origSettlementDate
origWashsaleDisallowanceBOptionaldecimal3848in_orig_ws_disallowance_bFTRADESDBOPENDING_TRADESORIG_WS_DISALLOWANCE_BNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/origWashsaleDisallowanceB
origWashsaleDisallowanceLOptionaldecimal3847in_orig_ws_disallowance_lFTRADESDBOPENDING_TRADESORIG_WS_DISALLOWANCE_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/origWashsaleDisallowanceL
otherFeeLocalOptionaldecimal3752in_other_fee_localFTRADESDBOPENDING_TRADESOTHER_FEE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/otherFeeLocal
ownershipTransferDateOptionaldate2426in_ownership_transfer_dateSTRADESDBOPENDING_TRADESOWNERSHIP_TRANSFER_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/ownershipTransferDate
performancePriceOptionaldecimal4598in_performance_priceFTRADESDBOPENDING_TRADESPERFORMANCE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/performancePrice
postDateOptionaldate118in_post_dateSTRADESDBOPENDING_TRADESPOST_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/postDate
priceOptionaldecimal10452in_priceFTRADESDBOPENDING_TRADESPRICENUMBER(28,12)EagleML/warehouseTransaction/warehousePendingTrade/price
quantityOptionaldecimal 
in_quantityFTRADESDBOPENDING_TRADESQUANTITYNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/quantity
quantityWashSaleEligibleOptionaldecimal 
in_qty_wash_sale_eligibleFTRADESDBOPENDING_TRADESQTY_WASH_SALE_ELIGIBLENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/quantityWashSaleEligible
reasonCode1Optionalstring3884in_reason_code1STRADESDBOPENDING_TRADESREASON_CODE1VARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/reasonCode1
reasonCode2Optionalstring3885in_reason_code2STRADESDBOPENDING_TRADESREASON_CODE2VARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/reasonCode2
reasonCode3Optionalstring3886in_reason_code3STRADESDBOPENDING_TRADESREASON_CODE3VARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/reasonCode3
reasonCode4Optionalstring3887in_reason_code4STRADESDBOPENDING_TRADESREASON_CODE4VARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/reasonCode4
reasonCode5Optionalstring3888in_reason_code5STRADESDBOPENDING_TRADESREASON_CODE5VARCHAR2(20)EagleML/warehouseTransaction/warehousePendingTrade/reasonCode5
reclaimAmountBaseOptionaldecimal851in_reclaim_amount_baseFTRADESDBOPENDING_TRADESRECLAIM_AMOUNT_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/reclaimAmountBase
reclaimAmountLocalOptionaldecimal852in_reclaim_amount_localFTRADESDBOPENDING_TRADESRECLAIM_AMOUNT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/reclaimAmountLocal
recordPayAccount1Optionalstring2276in_recd_pay_acct1STRADESDBOPENDING_TRADESRECD_PAY_ACCT1VARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/recordPayAccount1
recordPayAccount2Optionalstring2277in_recd_pay_acct2STRADESDBOPENDING_TRADESRECD_PAY_ACCT2VARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/recordPayAccount2
recordPayEventTypeOptionalstring1826in_recd_pay_event_typeSTRADESDBOPENDING_TRADESRECD_PAY_EVENT_TYPEVARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/recordPayEventType
recordPayPostingPlanTypeOptionalstring1831in_recd_pay_posting_plan_typSTRADESDBOPENDING_TRADESRECD_PAY_POSTING_PLAN_TYPVARCHAR2(50)EagleML/warehouseTransaction/warehousePendingTrade/recordPayPostingPlanType
retroIndicatorOptionalnormalizedString11018in_retro_indSTRADESDBOPENDING_TRADESRETRO_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/retroIndicator
sellToBaseFxRateOptionaldecimal 
in_sell_to_base_fx_rateFTRADESDBOPENDING_TRADESSELL_TO_BASE_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/sellToBaseFxRate
sellToBuyFxRateOptionaldecimal 
in_sell_to_buy_fx_rateFTRADESDBOPENDING_TRADESSELL_TO_BUY_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/sellToBuyFxRate
settlementAmountSettleOptionaldecimal 
in_settlement_amount_settleFTRADESDBOPENDING_TRADESSETTLEMENT_AMOUNT_SETTLENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/settlementAmountSettle
settlementCurrencyOptionalnormalizedString63in_settlement_currencySTRADESDBOPENDING_TRADESSETTLEMENT_CURRENCYVARCHAR2(3)EagleML/warehouseTransaction/warehousePendingTrade/settlementCurrency
settlementDateOptionaldate 
in_settlement_dateSTRADESDBOPENDING_TRADESSETTLEMENT_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/settlementDate
settlementInstructions1Optionalstring1897in_settlement_instructions1STRADESDBOPENDING_TRADESSETTLEMENT_INSTRUCTIONS1VARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions1
settlementInstructions2Optionalstring1898in_settlement_instructions2STRADESDBOPENDING_TRADESSETTLEMENT_INSTRUCTIONS2VARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions2
settlementInstructions3Optionalstring1899in_settlement_instructions3STRADESDBOPENDING_TRADESSETTLEMENT_INSTRUCTIONS3VARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions3
settlementInstructions4Optionalstring1900in_settlement_instructions4STRADESDBOPENDING_TRADESSETTLEMENT_INSTRUCTIONS4VARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions4
settlementLocationOptionalstring43in_settlement_locationSTRADESDBOPENDING_TRADESSETTLEMENT_LOCATIONVARCHAR2(12)EagleML/warehouseTransaction/warehousePendingTrade/settlementLocation
settleToBaseFxRateOptionaldecimal 
in_settle_to_base_fx_rateFTRADESDBOPENDING_TRADESSETTLE_TO_BASE_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/settleToBaseFxRate
stampDutyTaxLocalOptionaldecimal51in_stamp_duty_tax_localFTRADESDBOPENDING_TRADESSTAMP_DUTY_TAX_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/stampDutyTaxLocal
targetEventIdOptionalstring26in_target_event_idSTRADESDBOPENDING_TRADESTARGET_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/targetEventId
targetOrigEventIdOptionalstring5032in_target_orig_event_idSTRADESDBOPENDING_TRADESTARGET_ORIG_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/targetOrigEventId
targetPurchaseDateOptionaldate914in_target_purchase_dateSTRADESDBOPENDING_TRADESTARGET_PURCHASE_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/targetPurchaseDate
targetPurchasePriceOptionaldecimal915in_target_purchase_priceFTRADESDBOPENDING_TRADESTARGET_PURCHASE_PRICENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/targetPurchasePrice
targetTradeTicketNumberOptionalstring762in_target_trd_ticket_numberSTRADESDBOPENDING_TRADESTARGET_TRD_TICKET_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/targetTradeTicketNumber
taxAmountLocalOptionaldecimal1733in_tax_amount_localFTRADESDBOPENDING_TRADESTAX_AMOUNT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/taxAmountLocal
taxExpenseBaseOptionaldecimal854in_tax_expense_baseFTRADESDBOPENDING_TRADESTAX_EXPENSE_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/taxExpenseBase
taxExpenseLocalOptionaldecimal853in_tax_expense_localFTRADESDBOPENDING_TRADESTAX_EXPENSE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/taxExpenseLocal
taxReclaimBaseOptionaldecimal 
in_tax_reclaim_baseFTRADESDBOPENDING_TRADESTAX_RECLAIM_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/taxReclaimBase
taxReclaimLocalOptionaldecimal 
in_tax_reclaim_localFTRADESDBOPENDING_TRADESTAX_RECLAIM_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/taxReclaimLocal
tbaCashflowOptionalnormalizedString9406in_tba_cashflowSTRADESDBOPENDING_TRADESTBA_CASHFLOWVARCHAR2(3)EagleML/warehouseTransaction/warehousePendingTrade/tbaCashflow
tbaIndicatorOptionalnormalizedString 
in_tba_indicatorSTRADESDBOPENDING_TRADESTBA_INDICATORVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/tbaIndicator
tbaTradeIdOptionalstring 
in_tba_trade_idSTRADESDBOPENDING_TRADESTBA_TRADE_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/tbaTradeId
termLoanExpenseLOptionaldecimal846in_term_loan_expense_lFTRADESDBOPENDING_TRADESTERM_LOAN_EXPENSE_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/termLoanExpenseL
termLoanFeeIncomeLOptionaldecimal844in_term_loan_fee_income_lFTRADESDBOPENDING_TRADESTERM_LOAN_FEE_INCOME_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/termLoanFeeIncomeL
toAccountBasisOptionalstring 
in_to_acct_basisSTRADESDBOPENDING_TRADESTO_ACCT_BASISVARCHAR2(5)EagleML/warehouseTransaction/warehousePendingTrade/toAccountBasis
toAutoSettleIndOptionalnormalizedString333in_to_auto_settle_indSTRADESDBOPENDING_TRADESTO_AUTO_SETTLE_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/toAutoSettleInd
toBaseCurrencyOptionalnormalizedString 
in_to_base_currencySTRADESDBOPENDING_TRADESTO_BASE_CURRENCYVARCHAR2(3)EagleML/warehouseTransaction/warehousePendingTrade/toBaseCurrency
toCashEventTypeOptionalstring328in_to_cash_event_typeSTRADESDBOPENDING_TRADESTO_CASH_EVENT_TYPEVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/toCashEventType
toCommissionAmountLocalOptionaldecimal 
in_to_commission_amt_localFTRADESDBOPENDING_TRADESTO_COMMISSION_AMT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/toCommissionAmountLocal
toCostMethodOptionalnormalizedString315in_to_cost_methodSTRADESDBOPENDING_TRADESTO_COST_METHODVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/toCostMethod
toEntityIdOptionalstring11814in_to_entity_idSTRADESDBOPENDING_TRADESTO_ENTITY_IDCHAR(8)EagleML/warehouseTransaction/warehousePendingTrade/toEntityId
toExchangeFeeLocalOptionaldecimal 
in_to_exchange_fee_localFTRADESDBOPENDING_TRADESTO_EXCHANGE_FEE_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/toExchangeFeeLocal
toLocalToBaseFxRateOptionaldecimal 
in_to_local_to_base_fx_rateFTRADESDBOPENDING_TRADESTO_LOCAL_TO_BASE_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/toLocalToBaseFxRate
toLongShortIndicatorOptionalnormalizedString305in_to_long_short_indicatorSTRADESDBOPENDING_TRADESTO_LONG_SHORT_INDICATORVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/toLongShortIndicator
toLotSelectionMethodOptionalnormalizedString3277in_to_lot_selection_methodSTRADESDBOPENDING_TRADESTO_LOT_SELECTION_METHODVARCHAR2(8)EagleML/warehouseTransaction/warehousePendingTrade/toLotSelectionMethod
toNetAmountLocalOptionaldecimal 
in_to_net_amount_localFTRADESDBOPENDING_TRADESTO_NET_AMOUNT_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/toNetAmountLocal
toQuantityOptionaldecimal 
in_to_quantityFTRADESDBOPENDING_TRADESTO_QUANTITYNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/toQuantity
toSecurityAliasOptionalinteger 
in_to_security_aliasFTRADESDBOPENDING_TRADESTO_SECURITY_ALIASNUMBER(38,0)EagleML/warehouseTransaction/warehousePendingTrade/toSecurityAlias
toSettlementCurrencyOptionalnormalizedString8375in_to_settlement_currencySTRADESDBOPENDING_TRADESTO_SETTLEMENT_CURRENCYVARCHAR2(3)EagleML/warehouseTransaction/warehousePendingTrade/toSettlementCurrency
toSettleToBaseFxRateOptionaldecimal 
in_to_settle_to_base_fx_rateFTRADESDBOPENDING_TRADESTO_SETTLE_TO_BASE_FX_RATENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/toSettleToBaseFxRate
toTargetEventIdOptionalstring345in_to_target_event_idSTRADESDBOPENDING_TRADESTO_TARGET_EVENT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/toTargetEventId
toWashSaleEligibleIndicatorOptionalnormalizedString334in_to_wash_sale_elgbl_indSTRADESDBOPENDING_TRADESTO_WASH_SALE_ELGBL_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/toWashSaleEligibleIndicator
tradedInterestBaseOptionaldecimal475in_traded_interest_baseFTRADESDBOPENDING_TRADESTRADED_INTEREST_BASENUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/tradedInterestBase
tradedInterestLocalOptionaldecimal49in_traded_interest_localFTRADESDBOPENDING_TRADESTRADED_INTEREST_LOCALNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/tradedInterestLocal
tradeStatusOptionalstring3720in_trade_statusSTRADESDBOPENDING_TRADESTRADE_STATUSVARCHAR2(15)EagleML/warehouseTransaction/warehousePendingTrade/tradeStatus
tradeTicketNumberOptionalstring761in_trade_ticket_numberSTRADESDBOPENDING_TRADESTRADE_TICKET_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/tradeTicketNumber
tradeYieldOptionaldecimal9430in_trade_yieldFTRADESDBOPENDING_TRADESTRADE_YIELDNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/tradeYield
transactionNotesOptionalstring 
in_transaction_notesSTRADESDBOPENDING_TRADESTRANSACTION_NOTESVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/transactionNotes
washsaleCloseQuantityOptionaldecimal3865in_ws_close_quantityFTRADESDBOPENDING_TRADESWASHSALE_CLOSE_QUANTITYNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/washsaleCloseQuantity
washsaleClsTradeDateOptionaldate3863in_ws_cls_trade_dateSTRADESDBOPENDING_TRADESWASHSALE_CLS_TRADE_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/washsaleClsTradeDate
washsaleClsTradeTicketNumberOptionalstring3861in_ws_cls_trd_tckt_numberSTRADESDBOPENDING_TRADESWS_CLS_TRD_TCKT_NUMBERVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/washsaleClsTradeTicketNumber
washsaleDisallowanceCurrentBOptionaldecimal3850in_ws_disallowance_current_bFTRADESDBOPENDING_TRADESWS_DISALLOWANCE_CURRENT_BNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceCurrentB
washsaleDisallowanceCurrentLOptionaldecimal3849in_ws_disallowance_current_lFTRADESDBOPENDING_TRADESWS_DISALLOWANCE_CURRENT_LNUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceCurrentL
washsaleDisallowanceTermOptionalnormalizedString3851in_ws_disallowance_termSTRADESDBOPENDING_TRADESWS_DISALLOWANCE_TERMVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceTerm
washsaleDisallowanceTypeOptionalstring3866in_ws_disallowance_typeSTRADESDBOPENDING_TRADESWS_DISALLOWANCE_TYPEVARCHAR2(10)EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceType
washSaleEligibleIndicatorOptionalnormalizedString59in_wash_sale_elgb_indiSTRADESDBOPENDING_TRADESWASH_SALE_ELGBL_INDVARCHAR2(1)EagleML/warehouseTransaction/warehousePendingTrade/washSaleEligibleIndicator
washsaleOpenHoldingDateOptionaldate3988in_ws_open_holding_dateSTRADESDBOPENDING_TRADESWS_OPEN_HOLDING_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/washsaleOpenHoldingDate
washsaleOrigAcquireDateOptionaldate3864in_ws_orig_acq_dateSTRADESDBOPENDING_TRADESWASHSALE_ORIG_ACQ_DATEDATE(7)EagleML/warehouseTransaction/warehousePendingTrade/washsaleOrigAcquireDate
washsaleOrigOpenEventIdOptionalstring3862in_ws_orig_open_evt_idSTRADESDBOPENDING_TRADESWASHSALE_ORIG_OPEN_EVT_IDVARCHAR2(255)EagleML/warehouseTransaction/warehousePendingTrade/washsaleOrigOpenEventId
userChar1Optionalstring1887in_user_char1STRADESDBOPENDING_TRADESUSER_CHAR1VARCHAR2(30)EagleML/warehouseTransaction/warehousePendingTrade/userChar1
userChar2Optionalstring1888in_user_char2STRADESDBOPENDING_TRADESUSER_CHAR2VARCHAR2(30)EagleML/warehouseTransaction/warehousePendingTrade/userChar2
userChar3Optionalstring1889in_user_char3STRADESDBOPENDING_TRADESUSER_CHAR3VARCHAR2(30)EagleML/warehouseTransaction/warehousePendingTrade/userChar3
userFloat1Optionaldecimal 
in_user_float1FTRADESDBOPENDING_TRADESUSER_FLOAT1NUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/userFloat1
userFloat2Optionaldecimal 
in_user_float2FTRADESDBOPENDING_TRADESUSER_FLOAT2NUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/userFloat2
userFloat3Optionaldecimal1326in_user_float3FTRADESDBOPENDING_TRADESUSER_FLOAT3NUMBER(38,12)EagleML/warehouseTransaction/warehousePendingTrade/userFloat3
pendingTradeIdRequiredinteger3696in_pending_trade_idFTRADESDBOPENDING_TRADESPENDING_TRADE_IDNUMBER(38,0)EagleML/warehouseTransaction/warehousePendingTrade/pendingTradeId

...