Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 39 Next »


Important Note

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


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/objectType
objectId
objectId


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/objectId
objectDescription
FeedTypeEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/objectDescription
updateTimestamp
dateTime


TRADESDBOTRADEUPDATE_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/updateTimestamp
customElementsNot recommendedCustomElements


reserved for customizations

EagleML/warehouseTransaction/warehouseTrade/customElements
sourceName
string1102in_short_descSPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)YEagleML/warehouseTransaction/warehouseTrade/sourceName
updateSourceRequiredstring944in_update_sourceSTRADESDBOTRADEUPDATE_SOURCECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/updateSource
batchCollectErrorsFlag
YesNoOptionEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/batchCollectErrorsFlag
singleRowCommitFlag
YesNoOptionEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/singleRowCommitFlag
effectiveDate
date221in_effective_dateSTRADESDBOTRADEEFFECTIVE_DATEDATEYEagleML/warehouseTransaction/warehouseTrade/effectiveDate
Entity Common Id ModelEagleML/warehouseTransaction/warehouseTrade/
Extended Entity Properties Model (extract only)EagleML/warehouseTransaction/warehouseTrade/
accountingBasis
string21in_acct_basisSTRADESDBOTRADEACCT_BASISVARCHAR2(5)
EagleML/warehouseTransaction/warehouseTrade/accountingBasis
entityIDLookupSwitch
LookupSwitchEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/entityIDLookupSwitch
entityNameLookupSwitch
LookupSwitchEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/entityNameLookupSwitch
securityQueryFlag
YesNoOptionEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/securityQueryFlag
sourceLookupSwitch
LookupSwitchEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/sourceLookupSwitch
procedureMode
ProcedureFlagTypeEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/procedureMode
procedureFlag
ProcedureFlagTypeEnum


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/procedureFlag
Asset Identifiers ModelEagleML/warehouseTransaction/warehouseTrade/
Extended Asset Properties Model (extract only)EagleML/warehouseTransaction/warehouseTrade/
Extended CA Properties Model (extract only)EagleML/warehouseTransaction/warehouseTrade/
maturityDate
date


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/maturityDate
brokerCode
string88in_broker_codeSTRADESDBOTRADEBROKER_CODECHAR(12)
EagleML/warehouseTransaction/warehouseTrade/brokerCode
clearingBrokerCode
string1237in_clearing_broker_codeSTRADESDBOTRADE_DETAILCLEARING_BROKER_CODECHAR(20)
EagleML/warehouseTransaction/warehouseTrade/clearingBrokerCode
status
string54in_trade_statusSTRADESDBOTRADETRADE_STATUSCHAR(8)
EagleML/warehouseTransaction/warehouseTrade/status
taxAmountLocal
decimal46in_taxesFTRADESDBOTRADETAXESNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/taxAmountLocal
commissionAmount
decimal12019in_commission_amountFTRADESDBOTRADECOMMISSION_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/commissionAmount
accruedInterest
decimal49in_accrued_interestFTRADESDBOTRADEACCRUED_INTERESTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/accruedInterest
baseCurrency
CurrencyCode86in_base_currencySTRADESDBOTRADEBASE_CURRENCYVARCHAR2(3)
EagleML/warehouseTransaction/warehouseTrade/baseCurrency
monthEndAccountingDate
date4733in_month_end_dateSTRADESDBOTRADEMONTH_END_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/monthEndAccountingDate
tradeId
integer


TRADESDBOTRADETRADE_IDNUMBERYEagleML/warehouseTransaction/warehouseTrade/tradeId
accruedInterestType
string3715in_accrued_interest_typeSTRADESDBOTRADEACCRUED_INTEREST_TYPEVARCHAR2(3)
EagleML/warehouseTransaction/warehouseTrade/accruedInterestType
accruedIncomeLocal
decimal10758in_accrued_income_localFTRADESDBOTRADEACCRUED_INCOME_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/accruedIncomeLocal
cancelAccountingDt
date12138in_cancel_acctg_dateSTRADESDBOTRADE_DETAILCANCEL_ACCTG_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/cancelAccountingDt
cancelMthendAccountingDt
date12139in_cancel_me_acctg_dateSTRADESDBOTRADE_DETAILCANCEL_ME_ACCTG_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/cancelMthendAccountingDt
cancelFlag
string10045in_cancel_flagSTRADESDBOTRADE_DETAILCANCEL_FLAGCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/cancelFlag
cancelStatus
string10046in_cancel_statusSTRADESDBOTRADE_DETAILCANCEL_STATUSCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/cancelStatus
cancelEffectiveDt
date504in_cancel_effective_dateSTRADESDBOTRADE_DETAILCANCEL_EFFECTIVE_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/cancelEffectiveDt
cancelEventId
TransactionId501in_cancel_event_idSTRADESDBOTRADECANCEL_EVENT_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/cancelEventId
cancelLinkEventId
TransactionId506in_cancel_linked_event_idSTRADESDBOTRADECANCEL_LINKED_EVENT_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/cancelLinkEventId
currBuiltInGlSecurity
decimal9761in_curr_builtin_gl_secFTRADESDBOTRADECURR_BUILTIN_GL_SECNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlSecurity
currBuiltInGlCurrency
decimal10917in_curr_builtin_gl_currencyFTRADESDBOTRADECURR_BUILTIN_GL_CURRENCYNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlCurrency
currBuiltInGlDeferred
decimal10918in_curr_builtin_gl_deferredFTRADESDBOTRADECURR_BUILTIN_GL_DEFERREDNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlDeferred
currBuiltInGlOid
decimal10919in_curr_builtin_gl_oidFTRADESDBOTRADECURR_BUILTIN_GL_OIDNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlOid
currBuiltInGlMktDisc
decimal10920in_curr_builtin_gl_mkt_discFTRADESDBOTRADECURR_BUILTIN_GL_MKT_DISCNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlMktDisc
gainCurrency
decimal10049in_currency_gainFTRADESDBOTRADE_DETAILCURRENCY_GAINNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/gainCurrency
gainSecurityBase
decimal10051in_security_gainFTRADESDBOTRADE_DETAILSECURITY_GAINNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/gainSecurityBase
totalGain
decimal10057in_total_gainFTRADESDBOTRADE_DETAILTOTAL_GAINNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/totalGain
fromAccount
string351in_from_accountSTRADESDBOTRADEFROM_ACCOUNTCHAR(8)
EagleML/warehouseTransaction/warehouseTrade/fromAccount
fromAssetid
integer352in_from_sec_aliasFTRADESDBOTRADEFROM_SECURITY_ALIASNUMBER
EagleML/warehouseTransaction/warehouseTrade/fromAssetid
fromLongShort
string355in_from_lng_short_indSTRADESDBOTRADEFROM_LONG_SHORT_INDICATORVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/fromLongShort
fromSourceSystem
string361in_from_source_systemSTRADESDBOTRADEFROM_SOURCE_SYSTEMVARCHAR2(25) [v2015R2.x+]
EagleML/warehouseTransaction/warehouseTrade/fromSourceSystem
VARCHAR2(2) [v12.x or 13.x]
fromCostBasisType
BasisType367in_from_cost_basis_typeSTRADESDBOTRADEFROM_COST_BASIS_TYPEVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/fromCostBasisType
fromWashSaleEligInd
string384in_from_wash_sale_indSTRADESDBOTRADEFROM_WASH_SALE_ELGBL_INDVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/fromWashSaleEligInd
lossCurrency
decimal10052in_currency_lossFTRADESDBOTRADE_DETAILCURRENCY_LOSSNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/lossCurrency
lossSecurityBase
decimal10054in_security_lossFTRADESDBOTRADE_DETAILSECURITY_LOSSNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/lossSecurityBase
totalLoss
decimal10058in_total_lossFTRADESDBOTRADE_DETAILTOTAL_LOSSNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/totalLoss
originalAcquisitionCostBase
decimal3746in_orig_acq_cost_baseFTRADESDBOTRADEORIG_ACQ_COST_BASENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostBase
originalAcquisitionCostLocal
decimal3747in_orig_acq_cost_localFTRADESDBOTRADEORIG_ACQ_COST_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostLocal
originalFaceValue
decimal109in_original_face_valueFTRADESDBOTRADEORIGINAL_FACE_VALUENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/originalFaceValue
originalBuiltInGlMktDisc
decimal10915in_orig_builtin_gl_mkt_discFTRADESDBOTRADEORIG_BUILTIN_GL_MKT_DISCNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlMktDisc
originalTradePrice
decimal10906in_orig_trade_priceFTRADESDBOTRADEORIG_TRADE_PRICENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/originalTradePrice
originalBuiltInGlCurrency
decimal10912in_orig_builtin_gl_currencyFTRADESDBOTRADEORIG_BUILTIN_GL_CURRENCYNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlCurrency
originalBuiltInGlDeferred
decimal10913in_orig_builtin_gl_deferredFTRADESDBOTRADEORIG_BUILTIN_GL_DEFERREDNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlDeferred
originalBuiltInGlOid
decimal10914in_orig_builtin_gl_oidFTRADESDBOTRADEORIG_BUILTIN_GL_OIDNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlOid
originalBuiltInGlSecurity
decimal9762in_orig_builtin_gl_secFTRADESDBOTRADEORIG_BUILTIN_GL_SECNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlSecurity
originalSettlementDate
date154in_orig_settlement_dateSTRADESDBOTRADEORIG_SETTLEMENT_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/originalSettlementDate
originalQuantity
decimal159in_par_or_sharesFTRADESDBOTRADEPAR_OR_SHARESNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/originalQuantity
openCostBase

decimal166in_cost_baseFTRADESDBOTRADECOST_BASENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/openCostBase
openHldPerDate
date164in_holding_period_dateSTRADESDBOTRADEHOLDING_PERIOD_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/openHldPerDate
performanceFlow
decimal4597in_performance_valueFTRADESDBOTRADE_DETAILPERFORMANCE_VALUENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/performanceFlow
performancePrice
decimal4598in_performance_priceFTRADESDBOTRADE_DETAILPERFORMANCE_PRICENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/performancePrice
premiumLAllocated
decimal203in_premium_allocated_localFTRADESDBOTRADEPREMIUM_ALLOCATED_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/premiumLAllocated
premiumBAllocated
decimal204in_premium_allocatedFTRADESDBOTRADEPREMIUM_ALLOCATEDNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/premiumBAllocated
settlementAmount
decimal64in_settlement_amountFTRADESDBOTRADESETTLEMENT_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/settlementAmount
toAccount
string301in_to_accountSTRADESDBOTRADETO_ACCOUNTCHAR(8)
EagleML/warehouseTransaction/warehouseTrade/toAccount
toAssetid
integer302in_to_sec_aliasFTRADESDBOTRADETO_SECURITY_ALIASNUMBER
EagleML/warehouseTransaction/warehouseTrade/toAssetid
toLongShort
string305in_to_lng_short_indSTRADESDBOTRADETO_LONG_SHORT_INDICATORVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/toLongShort
toSourceSystem
string311in_to_source_systemSTRADESDBOTRADETO_SOURCE_SYSTEMVARCHAR2(25) [v2015R2.x+]
EagleML/warehouseTransaction/warehouseTrade/toSourceSystem
VARCHAR2(2) [v12.x or 13.x]
toCostBasisType
BasisType317in_to_cost_basis_typeSTRADESDBOTRADETO_COST_BASIS_TYPEVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/toCostBasisType
toCashEventType

string328in_to_cash_typeSTRADESDBOTRADETO_CASH_TYPEVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/toCashEventType
toWashSaleEligInd
string334in_to_wash_sale_indSTRADESDBOTRADETO_WASH_SALE_ELGBL_INDVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/toWashSaleEligInd
userChar1
string1887in_user_char1STRADESDBOTRADEUSER_CHAR1VARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/userChar1
userChar2
string1888in_user_char2STRADESDBOTRADEUSER_CHAR2VARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/userChar2
userChar3
string1889in_user_char3STRADESDBOTRADEUSER_CHAR3VARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/userChar3
userDefinedFloat1
decimal1890in_user_float1FTRADESDBOTRADEUSER_FLOAT1NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat1
userDefinedFloat2
decimal1891in_user_float2FTRADESDBOTRADEUSER_FLOAT2NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat2
userDefinedFloat3
decimal1892in_user_float3FTRADESDBOTRADEUSER_FLOAT3NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat3
costMethod
string22in_cost_methodSTRADESDBOTRADECOST_METHODVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/costMethod
lotSelectionMethod
string27in_lot_selection_methodSTRADESDBOTRADELOT_SELECTION_METHODVARCHAR2(8)
EagleML/warehouseTransaction/warehouseTrade/lotSelectionMethod
transactionCode
string2283in_trans_codeSTRADESDBOTRADETRANS_CODECHAR(55)
EagleML/warehouseTransaction/warehouseTrade/transactionCode
factor
decimal91in_factorFTRADESDBOTRADEFACTORNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/factor
netAmountLocal

decimal50in_net_cashFTRADESDBOTRADENET_CASHNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/netAmountLocal
netAmountBase

decimal478in_trade_base_amountFTRADESDBOTRADETRADE_BASE_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/netAmountBase
principalB
decimal169in_principal_baseFTRADESDBOTRADEPRINCIPAL_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/principalB
quantityPre
decimal410in_target_quantityFTRADESDBOTRADETARGET_QUANTITYNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/quantityPre
tradeYield
decimal9430in_trade_yieldFTRADESDBOTRADETRADE_YIELDNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/tradeYield
dirtyPrincipalLocal
decimal10781in_dirty_principalFTRADESDBOTRADEDIRTY_PRINCIPALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalLocal
dirtyPrincipalBase
decimal10782in_dirty_principal_baseFTRADESDBOTRADEDIRTY_PRINCIPAL_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalBase
estimateVsFinal
string768in_est_vs_actSTRADESDBOTRADEEST_VS_ACTVARCHAR2(3)
EagleML/warehouseTransaction/warehouseTrade/estimateVsFinal
reportingReplayInd
string10674in_replay_indSTRADESDBOTRADEREPLAY_INDVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/reportingReplayInd
cashEventType
string53in_cash_typeSTRADESDBOTRADE_DETAILCASH_TYPECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/cashEventType
transactionNotes
string56in_transaction_notesSTRADESDBOTRADE_DETAILTRANSACTION_NOTESVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/transactionNotes
partflag
string3924in_partflagSTRADESDBOTRADE_DETAILPARTFLAGCHAR(1)
EagleML/warehouseTransaction/warehouseTrade/partflag
scrubType
string3717in_scrub_typeSTRADESDBOTRADESCRUB_TYPECHAR(2)
EagleML/warehouseTransaction/warehouseTrade/scrubType
glAccount
string4519in_general_ledger_acctSTRADESDBOTRADE_DETAILGENERAL_LEDGER_ACCTVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/glAccount
custodianBank
string1146in_custody_bank_descSTRADESDBOTRADECUSTODY_BANK_DESC

EagleML/warehouseTransaction/warehouseTrade/custodianBank
custodianBankCode
string1240in_custody_bank_codeSTRADESDBOTRADECUSTODY_BANK_CODECHAR(20)
EagleML/warehouseTransaction/warehouseTrade/custodianBankCode
custodyBankAccountNum
string1660in_custody_bank_acct_numSTRADESDBOTRADECUSTODY_BANK_ACCT_NUMVARCHAR2(15)
EagleML/warehouseTransaction/warehouseTrade/custodyBankAccountNum
custodyBankSubAccount
string1661in_custody_bank_sub_acctSTRADESDBOTRADECUSTODY_BANK_SUB_ACCTVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/custodyBankSubAccount
corporateActionType
string1728in_corp_action_typeSTRADESDBOTRADECORP_ACTION_TYPEVARCHAR2(55)
EagleML/warehouseTransaction/warehouseTrade/corporateActionType
cashEventSpawned
string751in_cash_event_spawnedSTRADESDBOTRADECASH_EVENT_SPAWNEDVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/cashEventSpawned
bankAlias
integer1864in_bank_aliasSTRADESDBOTRADEBANK_ALIASNUMBER
EagleML/warehouseTransaction/warehouseTrade/bankAlias
changedflag
string10705in_changedflagSTRADESDBOTRADE_DETAILCHANGEDFLAGCHAR(1)
EagleML/warehouseTransaction/warehouseTrade/changedflag
eventId
TransactionId25in_star_tag25STRADESDBOTRADESTAR_TAG25VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/eventId
corporateActionInstance
integer4268in_corporate_action_instSTRADESDBOTRADE_DETAILCORPORATE_ACTION_INSTNUMBER
EagleML/warehouseTransaction/warehouseTrade/corporateActionInstance
eventIdSwitch
TransactionId


TRADESDBOTRADETRANSACTION_ID

EagleML/warehouseTransaction/warehouseTrade/eventIdSwitch
sellToBuyFXRate
decimal7in_sell_to_buy_fx_rateFTRADESDBOTRADESELL_TO_BUY_FX_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/sellToBuyFXRate
lotNumber
string3710in_lot_numberSTRADESDBOTRADELOT_NUMBERCHAR(8)YEagleML/warehouseTransaction/warehouseTrade/lotNumber
masterTicketNumberRequiredstring761in_master_ticket_numberSTRADESDBOTRADEMASTER_TICKET_NUMBERVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/masterTicketNumber
tradeXrefIdentifier
TradeXrefIdentifier


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/
acqTransNumber
integer12251in_acq_tnumFTRADESDBOTRADE_DETAILACQ_TNUMNUMBER
EagleML/warehouseTransaction/warehouseTrade/acqTransNumber
postType
string12197in_post_typeSTRADESDBOTRADE_DETAILPOST_TYPECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/postType
tradeMemo1

12236in_trade_memo1STRADESDBOTRADE_DETAILTRADE_MEMO1VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tradeMemo1
tradeMemo2
string12237in_trade_memo2STRADESDBOTRADE_DETAILTRADE_MEMO2VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tradeMemo2
fxRate
decimal87in_fx_rateFTRADESDBOTRADEFX_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/fxRate
checkedDate
dateTime12141in_checkeddateSTRADESDBOTRADE_DETAILCHECKEDDATEDATE
EagleML/warehouseTransaction/warehouseTrade/checkedDate
accountingDesignation
string7208in_acct_desigSTRADESDBOTRADE_DETAIL_EXTACCT_DESIGVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/accountingDesignation
brokerReason
string7209in_broker_reasonSTRADESDBOTRADE_DETAIL_EXTBROKER_REASONVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/brokerReason
instructedDate
dateTime12143in_instructeddateSTRADESDBOTRADE_DETAILINSTRUCTEDDATEDATE
EagleML/warehouseTransaction/warehouseTrade/instructedDate
dispInterestReceived
decimal12318in_disp_interest_receivedFTRADESDBOTRADE_DETAILDISP_INTEREST_RECEIVEDNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/dispInterestReceived
userWhoApprovedTrade
string12262in_user_who_approved_tradeSTRADESDBOTRADE_DETAILUSER_WHO_APPROVED_TRADEVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/userWhoApprovedTrade
otherFundNumber
string7211in_oth_fund_invnumSTRADESDBOTRADE_DETAIL_EXTOTH_FUND_INVNUMVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/otherFundNumber
prepaySpeed
decimal12200in_prepay_speedFTRADESDBOTRADE_DETAILPREPAY_SPEED_CONTRACT_SIZENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/prepaySpeed
TRADESDBOTRADE_DETAIL_EXTPREPAY_SPEEDNUMBER(38,12)
prepayType
string7212in_prepay_typeSTRADESDBOTRADE_DETAIL_EXTPREPAY_TYPEVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/prepayType
settlementExchangeRate
decimal79in_settlement_exchange_rateFTRADESDBOTRADESETTLEMENT_EXCHANGE_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/settlementExchangeRate
touchCount
integer13688in_transeqFTRADESDBOTRADE_DETAILTRANSEQNUMBER
EagleML/warehouseTransaction/warehouseTrade/touchCount
secTranType
string7220in_tran_typeSTRADESDBOTRADE_DETAIL_EXTTRAN_TYPEVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/secTranType
authorizedDate
dateTime12137in_authorizeddateSTRADESDBOTRADE_DETAILAUTHORIZEDDATEDATE
EagleML/warehouseTransaction/warehouseTrade/authorizedDate
localCommissionAmount
decimal47in_local_commission_amountFTRADESDBOTRADELOCAL_COMMISSION_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/localCommissionAmount
salesPerson
string12098in_sales_personSTRADESDBOTRADESALES_PERSONCHAR(18)
EagleML/warehouseTransaction/warehouseTrade/salesPerson
convexity
decimal7965in_convexityFTRADESDBOTRADE_DETAIL_EXTCONVEXITYNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/convexity
broker
string12126in_brokerSTRADESDBOTRADE_DETAILBROKERCHAR(50)
EagleML/warehouseTransaction/warehouseTrade/broker
settlementCurrency
string63in_settlement_currencySTRADESDBOTRADESETTLEMENT_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/settlementCurrency
discountRate
decimal12039in_discount_rateFTRADESDBOTRADEDISCOUNT_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/discountRate
duration
decimal7966in_durationFTRADESDBOTRADE_DETAIL_EXTDURATIONNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/duration
comments1
string12133in_comments1STRADESDBOTRADE_DETAILCOMMENTS1CHAR(30)
EagleML/warehouseTransaction/warehouseTrade/comments1
modifiedBy
string7213in_modified_bySTRADESDBOTRADE_DETAIL_EXTMODIFIED_BYVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/modifiedBy
price
decimal160in_priceFTRADESDBOTRADEPRICENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/price
pricingIndex
string7214in_prc_indexSTRADESDBOTRADE_DETAIL_EXTPRC_INDEXVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/pricingIndex
pricingSpread
decimal7967in_prc_spread
TRADESDBOTRADE_DETAIL_EXTPRC_SPREADNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/pricingSpread
principal
decimal165in_tdprincipalFTRADESDBOTRADEPRINCIPALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/principal
comments
string12132in_commentsSTRADESDBOTRADE_DETAILCOMMENTSCHAR(30)
EagleML/warehouseTransaction/warehouseTrade/comments
prepared
string12199in_preparedSTRADESDBOTRADE_DETAILPREPAREDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/prepared
preparedDate
dateTime12194in_prepareddateSTRADESDBOTRADE_DETAILPREPAREDDATEDATE
EagleML/warehouseTransaction/warehouseTrade/preparedDate
settlementLocation
string43in_settlement_locationSTRADESDBOTRADESETTLEMENT_LOCATIONCHAR(12)
EagleML/warehouseTransaction/warehouseTrade/settlementLocation
trader
string12115in_traderSTRADESDBOTRADETRADERCHAR(30)
EagleML/warehouseTransaction/warehouseTrade/trader
yield
decimal75in_yieldFTRADESDBOTRADEYIELDNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/yield
blockTradeId
string7215in_block_trade_idSTRADESDBOTRADE_DETAIL_EXTBLOCK_TRADE_IDVARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/blockTradeId
fromQuantity
decimal366in_from_quantityFTRADESDBOTRADEFROM_QUANTITYNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/fromQuantity
sellToBaseFxRate
decimal12149in_sell_to_base_fx_rateFTRADESDBOTRADESELL_TO_BASE_FX_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/sellToBaseFxRate
toQuantity
decimal316in_to_quantityFTRADESDBOTRADETO_QUANTITYNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/toQuantity
toAmountLocal
decimal327in_to_amount_localFTRADESDBOTRADETO_AMOUNT_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/toAmountLocal
toCashType

string328in_to_cash_typeSTRADESDBOTRADETO_CASH_TYPEVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/toCashType
fromAmountLocal
decimal377in_from_amount_localFTRADESDBOTRADEFROM_AMOUNT_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/fromAmountLocal
fromCashType
string378in_from_cash_typeSTRADESDBOTRADEFROM_CASH_TYPEVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/fromCashType
novationType
string7216in_novation_type
TRADESDBOTRADE_DETAIL_EXTNOVATION_TYPEVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/novationType
derivTranType
string7217in_tran_type_derivSTRADESDBOTRADE_DETAIL_EXTTRAN_TYPE_DERIVVARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/derivTranType
currentWAL
decimal7968in_walFTRADESDBOTRADE_DETAIL_EXTWALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentWAL
purchaseType
string7218in_purchase_typeSTRADESDBOTRADE_DETAIL_EXTPURCHASE_TYPEVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/purchaseType
embeddedDerivPrice
decimal7969in_ed_prcFTRADESDBOTRADE_DETAIL_EXTED_PRCNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/embeddedDerivPrice
assetLiabilityHedgeFlag
string7219in_al_hedge_flagSTRADESDBOTRADE_DETAIL_EXTAL_HEDGE_FlAGVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/assetLiabilityHedgeFlag
currentWAC
decimal7970in_wacFTRADESDBOTRADE_DETAIL_EXTWACNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentWAC
currentWAM
decimal7971in_wamFTRADESDBOTRADE_DETAIL_EXTWAMNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentWAM
hedgeTaxStatus
string7188in_hedge_tax_statusSTRADESDBOTRADE_DETAIL_EXTHEDGE_TAX_STATUSVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/hedgeTaxStatus
hedgeDesigCds
string7189in_hedge_desig_cdsSTRADESDBOTRADE_DETAIL_EXTHEDGE_DESIG_CDSVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/hedgeDesigCds
settlementInstructions1
string1897in_settlement_instructions1STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS1VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settlementInstructions1
settlementInstructions2
string12224in_settlement_instructions2STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS2VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settlementInstructions2
settlementInstructions3
string12225in_settlement_instructions3STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS3VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settlementInstructions3
settlementInstructions4
string12227in_settlement_instructions4STRADESDBOTRADE_DETAILSETTLEMENT_INSTRUCTIONS4VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settlementInstructions4
strategy
string2514in_strategy_idSTRADESDBOTRADESTRATEGY_IDVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/strategy
TRADESDBOTRADE_DETAIL_EXTSTRATEGY

executionType
string7210in_exec_typeSTRADESDBOTRADE_DETAIL_EXTEXEC_TYPEVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/executionType
origEntryDate
date7207in_orig_entry_dateSTRADESDBOTRADE_DETAIL_EXTORIG_ENTRY_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/origEntryDate
settlementDate
date37in_settlement_dateSTRADESDBOTRADESETTLEMENT_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/settlementDate
fxPayCurrency
CurrencyCode


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/fxPayCurrency
tradeExchangeRate
decimal12163in_trade_exchange_rateFTRADESDBOTRADETRADE_EXCHANGE_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/tradeExchangeRate
fxRcvCurrency
CurrencyCode


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/fxRcvCurrency
postDate
date30in_post_dateSTRADESDBOTRADEPOST_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/postDate
conterpartyCode
string


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/conterpartyCode
tradeCoupon
decimal7961in_trd_coupon
TRADESDBOTRADE_DETAIL_EXTTRD_COUPONNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/tradeCoupon
factorDate
date7187in_trade_factor_dateSTRADESDBOTRADE_DETAIL_EXTTRADE_FACTOR_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/factorDate
longShortIndicator

LongShortIndicatorEnum
in_star_ls_ind
TRADESDBOTRADE_DETAILLONG_SHORT_INDICATORCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/longShortIndicator
custodianBankDesc
string1146in_custody_bank_descSTRADESDBOTRADECUSTODY_BANK_DESCCHAR(50)
EagleML/warehouseTransaction/warehouseTrade/custodianBankDesc
openCostLocal

decimal162in_cost_localFTRADESDBOTRADECOST_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/openCostLocal
tradeAmount
decimal190in_trade_amountFTRADESDBOTRADETRADE_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/tradeAmount
smInactiveFlag
YesNoOptionEnum11043in_sm_inactive_flagSnot stored in DB, used for resolution logic

EagleML/warehouseTransaction/warehouseTrade/smInactiveFlag
clientId
string1632in_client_idSTRADESDBOTRADECLIENT_IDVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/clientId
covFlag
YesNoOptionEnum12135in_cov_flagSTRADESDBOTRADE_DETAILCOV_FLAGVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/covFlag
eventSubPriority
integer12042in_event_sub_priorityFTRADESDBOTRADEEVENT_SUB_PRIORITYNUMBER(38)
EagleML/warehouseTransaction/warehouseTrade/eventSubPriority
ioIssuerAlias
string12183in_io_issuer_aliasSTRADESDBOTRADE_DETAILIO_ISSUER_ALIASVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/ioIssuerAlias
ioIssuerId
string12184in_io_issuer_idSTRADESDBOTRADE_DETAILIO_ISSUER_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/ioIssuerId
origAcctDate
date12036in_orig_acct_dateSTRADESDBOTRADEORIG_ACCT_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/origAcctDate
origMonthlyAcctDate
date12102in_orig_monthly_acct_dateSTRADESDBOTRADEORIG_MONTHLY_ACCT_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/origMonthlyAcctDate
pendingTradeId
integer12088in_pending_trade_idFTRADESDBOTRADEPENDING_TRADE_IDNUMBER(38)
EagleML/warehouseTransaction/warehouseTrade/pendingTradeId
qtyWashSaleEligible
decimal12111in_qty_wash_sale_eligibleFTRADESDBOTRADEQTY_WASH_SALE_ELIGIBLENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/qtyWashSaleEligible
washSaleEligibleInd
string12120in_wash_sale_eligible_indicatorSTRADESDBOTRADEWASH_SALE_ELIGIBLE_INDICATORCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/washSaleEligibleInd
aiaNetB
decimal12252in_aia_net_bFTRADESDBOTRADE_DETAILAIA_NET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/aiaNetB
aiaNetL
decimal12253in_aia_net_lFTRADESDBOTRADE_DETAILAIA_NET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/aiaNetL
buySellFlag
normalizedString12006in_buy_sell_flagSTRADESDBOTRADEBUY_SELL_FLAGCHAR(4)
EagleML/warehouseTransaction/warehouseTrade/buySellFlag
bookValue
decimal4602in_book_valueFTRADESDBOTRADE_DETAILBOOK_VALUENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/bookValue
bookValueLocal
decimal4601in_book_value_localFTRADESDBOTRADE_DETAILBOOK_VALUE_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/bookValueLocal
cpNetB
decimal12306in_cp_net_bFTRADESDBOTRADE_DETAILCP_NET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/cpNetB
cpNetL
decimal12307in_cp_net_lFTRADESDBOTRADE_DETAILCP_NET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/cpNetL
creditLossB
decimal12308in_credit_loss_bFTRADESDBOTRADE_DETAILCREDIT_LOSS_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/creditLossB
creditLossL
decimal12310in_credit_loss_lFTRADESDBOTRADE_DETAILCREDIT_LOSS_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/creditLossL
costBasisType
string24in_cost_basis_typeSTRADESDBOTRADECOST_BASIS_TYPECHAR(2)
EagleML/warehouseTransaction/warehouseTrade/costBasisType
futureFeeNetB
decimal12352in_future_fee_net_bFTRADESDBOTRADE_DETAILFUTURE_FEE_NET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/futureFeeNetB
futureFeeNetL
decimal12356in_future_fee_net_lFTRADESDBOTRADE_DETAILFUTURE_FEE_NET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/futureFeeNetL
impairmentLtdBase
decimal13035in_impairment_ltd_baseFTRADESDBOTRADE_DETAILIMPAIRMENT_LTD_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentLtdBase
impairmentLtdLocal
decimal13036in_impairment_ltd_localFTRADESDBOTRADE_DETAILIMPAIRMENT_LTD_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocal
mbaNetB
decimal13656in_mba_net_bFTRADESDBOTRADE_DETAILMBA_NET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/mbaNetB
mbaNetL
decimal13657in_mba_net_lFTRADESDBOTRADE_DETAILMBA_NET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/mbaNetL
naiaNetB
decimal13658in_naia_net_bFTRADESDBOTRADE_DETAILNAIA_NET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/naiaNetB
naiaNetL
decimal13659in_naia_net_lFTRADESDBOTRADE_DETAILNAIA_NET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/naiaNetL
nonCreditLossB
decimal13661in_non_credit_loss_bFTRADESDBOTRADE_DETAILNON_CREDIT_LOSS_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/nonCreditLossB
nonCreditLossL
decimal13662in_non_credit_loss_lFTRADESDBOTRADE_DETAILNON_CREDIT_LOSS_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/nonCreditLossL
bookCost
decimal12285in_book_costFTRADESDBOTRADE_DETAILBOOK_COSTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/bookCost
cashCategory
string12128in_cash_categorySTRADESDBOTRADE_DETAILCASH_CATEGORYVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/cashCategory
cancelType
string12127in_cancel_typeSTRADESDBOTRADE_DETAILCANCEL_TYPEVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/cancelType
exchangeFeeBase
decimal13970in_exchange_fee_baseFTRADESDBOTRADEEXCHANGE_FEE_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/exchangeFeeBase
federalTaxWithholdBase
decimal13969in_federal_tax_withhold_baseFTRADESDBOTRADEFEDERAL_TAX_WITHHOLD_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/federalTaxWithholdBase
mttype
string13280in_mttypeSTRADESDBOTRADEMTTYPECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/mttype
netCash

decimal50in_net_cashFTRADESDBOTRADENET_CASHNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/netCash
origAcqDate
date216in_orig_acq_dateSTRADESDBOTRADEORIG_ACQ_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/origAcqDate
positionId
integer12092in_position_idFTRADESDBOTRADEPOSITION_IDNUMBER(38)
EagleML/warehouseTransaction/warehouseTrade/positionId
scrubId
integer12147in_scrub_idFTRADESDBOTRADESCRUB_IDNUMBER
EagleML/warehouseTransaction/warehouseTrade/scrubId
secFeesBase
decimal12148in_sec_fees_baseFTRADESDBOTRADESEC_FEES_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/secFeesBase
termLoanFeeExpB
decimal12155in_term_loan_fee_exp_bFTRADESDBOTRADETERM_LOAN_FEE_EXP_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpB
termLoanFeeExpL
decimal12156in_term_loan_fee_exp_lFTRADESDBOTRADETERM_LOAN_FEE_EXP_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpL
termLoanFeeIncB
decimal12157in_term_loan_fee_inc_bFTRADESDBOTRADETERM_LOAN_FEE_INC_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncB
termLoanFeeIncL
decimal12158in_term_loan_fee_inc_lFTRADESDBOTRADETERM_LOAN_FEE_INC_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncL
targetEventId
TransactionId26in_target_event_idSTRADESDBOTRADETARGET_EVENT_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/targetEventId
updateUserId
string12119in_update_user_idSTRADESDBOTRADEUPDATE_USER_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/updateUserId
updateSwitch
string1076in_update_switch
not stored in DB

EagleML/warehouseTransaction/warehouseTrade/updateSwitch
accruedInterestOverride
string12121in_accrued_interest_overrideSTRADESDBOTRADE_DETAILACCRUED_INTEREST_OVERRIDEVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/accruedInterestOverride
acquisitionType
string12122in_acquisition_typeSTRADESDBOTRADE_DETAILACQUISITION_TYPEVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/acquisitionType
amortizedCostPrevBase
decimal12255in_amortized_cost_prev_bFTRADESDBOTRADE_DETAILAMORTIZED_COST_PREV_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevBase
amortizedCostPrevLocal
decimal12278in_amortized_cost_prev_lFTRADESDBOTRADE_DETAILAMORTIZED_COST_PREV_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevLocal
alluprate
decimal12254in_alluprateFTRADESDBOTRADE_DETAILALLUPRATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/alluprate
asOfTradeTime
string12123in_as_of_trade_timeSTRADESDBOTRADE_DETAILAS_OF_TRADE_TIMEVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/asOfTradeTime
authorized
string12124in_authorizedSTRADESDBOTRADE_DETAILAUTHORIZEDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/authorized
autoexTradeFlag
YesNoOptionEnum12125in_autoex_trade_flagSTRADESDBOTRADE_DETAILAUTOEX_TRADE_FLAGVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/autoexTradeFlag
baseCommissionAmount
decimal12009in_base_commission_amountFTRADESDBOTRADEBASE_COMMISSION_AMOUNTNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/baseCommissionAmount
batchInstance
integer126in_batch_instanceSTRADESDBOTRADEBATCH_INSTANCENUMBER
EagleML/warehouseTransaction/warehouseTrade/batchInstance
balance
decimal12279in_balanceFTRADESDBOTRADE_DETAILBALANCENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/balance
bnchYld1
decimal12280in_bnch_yld1FTRADESDBOTRADE_DETAILBNCH_YLD1NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/bnchYld1
bnchYld2
decimal12281in_bnch_yld2FTRADESDBOTRADE_DETAILBNCH_YLD2NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/bnchYld2
bloombergProduct
string12008in_bloomberg_productSTRADESDBOTRADEBLOOMBERG_PRODUCTCHAR(8)
EagleML/warehouseTransaction/warehouseTrade/bloombergProduct
buyToBaseFxRate
decimal12014in_buy_to_base_fx_rateFTRADESDBOTRADEBUY_TO_BASE_FX_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/buyToBaseFxRate
calcYieldIntIndicator
integer12015in_calc_yield_int_indicatorFTRADESDBOTRADECALC_YIELD_INT_INDICATORNUMBER
EagleML/warehouseTransaction/warehouseTrade/calcYieldIntIndicator
cancelDueToCorrection
string12021in_cancel_due_to_correctionSTRADESDBOTRADECANCEL_DUE_TO_CORRECTIONCHAR(4)
EagleML/warehouseTransaction/warehouseTrade/cancelDueToCorrection
cashflowdate
date12140in_cashflowdateSTRADESDBOTRADE_DETAILCASHFLOWDATEDATE
EagleML/warehouseTransaction/warehouseTrade/cashflowdate
checked
string12129in_checkedSTRADESDBOTRADE_DETAILCHECKEDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/checked
clearingBroker
string12130in_clearing_brokerSTRADESDBOTRADE_DETAILCLEARING_BROKERCHAR(50)
EagleML/warehouseTransaction/warehouseTrade/clearingBroker
closeoutpl0
decimal12288in_closeoutpl0FTRADESDBOTRADE_DETAILCLOSEOUTPL0NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/closeoutpl0
closeoutpl1
decimal12292in_closeoutpl1FTRADESDBOTRADE_DETAILCLOSEOUTPL1NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/closeoutpl1
commentType
string12131in_comment_typeSTRADESDBOTRADE_DETAILCOMMENT_TYPECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/commentType
compared
string12134in_comparedSTRADESDBOTRADE_DETAILCOMPAREDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/compared
compareddate
date12142in_compareddateSTRADESDBOTRADE_DETAILCOMPAREDDATEDATE
EagleML/warehouseTransaction/warehouseTrade/compareddate
costPrevBase
decimal12295in_cost_prev_baseFTRADESDBOTRADE_DETAILCOST_PREV_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/costPrevBase
costPrevLocal
decimal12296in_cost_prev_localFTRADESDBOTRADE_DETAILCOST_PREV_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/costPrevLocal
cleanPrice
decimal12018in_clean_priceFTRADESDBOTRADECLEAN_PRICENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/cleanPrice
commissionCode
string12023in_commission_codeSTRADESDBOTRADECOMMISSION_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/commissionCode
commissionReasonCode
string12024in_commission_reason_codeSTRADESDBOTRADECOMMISSION_REASON_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/commissionReasonCode
commissionTypeCode
string78in_commission_type_codeSTRADESDBOTRADECOMMISSION_TYPE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/commissionTypeCode
customerAcctNumb
string12025in_customer_acct_numbSTRADESDBOTRADECUSTOMER_ACCT_NUMBCHAR(30)
EagleML/warehouseTransaction/warehouseTrade/customerAcctNumb
dispBookValueGaap
decimal3766in_disp_book_value_gaapFTRADESDBOTRADE_DETAILDISP_BOOK_VALUE_GAAPNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/dispBookValueGaap
dispBookValueStat
decimal3767in_disp_book_value_statFTRADESDBOTRADE_DETAILDISP_BOOK_VALUE_STATNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/dispBookValueStat
disallowGainB
decimal12311in_disallow_gain_bFTRADESDBOTRADE_DETAILDISALLOW_GAIN_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/disallowGainB
disallowGainL
decimal12312in_disallow_gain_lFTRADESDBOTRADE_DETAILDISALLOW_GAIN_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/disallowGainL
disallowLossB
decimal12314in_disallow_loss_bFTRADESDBOTRADE_DETAILDISALLOW_LOSS_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/disallowLossB
disallowLossL
decimal12315in_disallow_loss_lFTRADESDBOTRADE_DETAILDISALLOW_LOSS_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/disallowLossL
dispAccruedIncome
decimal12316in_disp_accrued_incomeFTRADESDBOTRADE_DETAILDISP_ACCRUED_INCOMENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/dispAccruedIncome
electedShareAmt
decimal12326in_elected_share_amtFTRADESDBOTRADE_DETAILELECTED_SHARE_AMTNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/electedShareAmt
electedSharePerc
decimal12328in_elected_share_percFTRADESDBOTRADE_DETAILELECTED_SHARE_PERCNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/electedSharePerc
exchangeCodeTrd
string12176in_exchange_code_trdSTRADESDBOTRADE_DETAILEXCHANGE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/exchangeCodeTrd
exchangeCurrency
string12177in_exchange_currencySTRADESDBOTRADE_DETAILEXCHANGE_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/exchangeCurrency
exchangeTypeCode
string12178in_exchange_type_codeSTRADESDBOTRADE_DETAILEXCHANGE_TYPE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/exchangeTypeCode
exchangeCode
string17in_exchange_codeSTRADESDBOTRADEEXCHANGE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/exchangeCode
exchangeFee
decimal48in_exchange_feeFTRADESDBOTRADEEXCHANGE_FEENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/exchangeFee
fairMarketValueBase
decimal12337in_fair_market_value_baseFTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/fairMarketValueBase
fairMarketValueFlag
string12179in_fair_market_value_flagSTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_FLAGVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/fairMarketValueFlag
fairMarketValueLocal
decimal12342in_fair_market_value_localFTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/fairMarketValueLocal
fairMarketValuePrice
decimal12343in_fair_market_value_priceFTRADESDBOTRADE_DETAILFAIR_MARKET_VALUE_PRICENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/fairMarketValuePrice
feeamt
decimal12344in_feeamtFTRADESDBOTRADE_DETAILFEEAMTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/feeamt
feerate
decimal12351in_feerateFTRADESDBOTRADE_DETAILFEERATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/feerate
fromEffectiveDate
date12005in_from_effective_dateSTRADESDBOTRADEFROM_EFFECTIVE_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/fromEffectiveDate
fwdCleanPrice
decimal13968in_fwd_clean_priceFTRADESDBOTRADEFWD_CLEAN_PRICENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/fwdCleanPrice
gaapRealizedGl
decimal12358in_gaap_realized_glFTRADESDBOTRADE_DETAILGAAP_REALIZED_GLNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/gaapRealizedGl
gaapSecType
string12180in_gaap_sec_typeSTRADESDBOTRADE_DETAILGAAP_SEC_TYPECHAR(4)
EagleML/warehouseTransaction/warehouseTrade/gaapSecType
goodMillionNum
integer12361in_good_million_numFTRADESDBOTRADE_DETAILGOOD_MILLION_NUMNUMBER
EagleML/warehouseTransaction/warehouseTrade/goodMillionNum
haircutFlag
YesNoOptionEnum12071in_haircut_flagSTRADESDBOTRADEHAIRCUT_FLAGVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/haircutFlag
haircutPct
decimal13967in_haircut_pctFTRADESDBOTRADEHAIRCUT_PCTNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/haircutPct
holdTradeStatus
string12072in_hold_trade_statusSTRADESDBOTRADEHOLD_TRADE_STATUSVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/holdTradeStatus
identifier2
string12181in_identifier2STRADESDBOTRADE_DETAILIDENTIFIER2VARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/identifier2
impairmentAmortOffsetB
decimal12362in_impairment_amort_offset_bFTRADESDBOTRADE_DETAILIMPAIRMENT_AMORT_OFFSET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetB
impairmentAmortOffsetL
decimal12363in_impairment_amort_offset_lFTRADESDBOTRADE_DETAILIMPAIRMENT_AMORT_OFFSET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetL
impairmentCostOffsetB
decimal12368in_impairment_cost_offset_bFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_OFFSET_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetB
impairmentCostOffsetL
decimal12370in_impairment_cost_offset_lFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_OFFSET_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetL
impairmentCostPrevB
decimal12383in_impairment_cost_prev_bFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_PREV_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevB
impairmentCostPrevL
decimal12384in_impairment_cost_prev_lFTRADESDBOTRADE_DETAILIMPAIRMENT_COST_PREV_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevL
inceptionamt
decimal13651in_inceptionamtFTRADESDBOTRADE_DETAILINCEPTIONAMTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/inceptionamt
instructed
string12182in_instructedSTRADESDBOTRADE_DETAILINSTRUCTEDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/instructed
interest
decimal13652in_interestFTRADESDBOTRADE_DETAILINTERESTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/interest
invertFlag
YesNoOptionEnum12073in_invert_flagSTRADESDBOTRADEINVERT_FLAGCHAR(4)
EagleML/warehouseTransaction/warehouseTrade/invertFlag
interestadj
decimal13653in_interestadjFTRADESDBOTRADE_DETAILINTERESTADJNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/interestadj
interestAdjBase
decimal475in_baseinterestadjFTRADESDBOTRADE_DETAILBASEINTERESTADJNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/interestAdjBase
ledgerEffectiveDate
date36in_ledger_effective_dateSTRADESDBOTRADELEDGER_EFFECTIVE_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/ledgerEffectiveDate
ledgerDate
date12144in_ledger_dateSTRADESDBOTRADE_DETAILLEDGER_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/ledgerDate
letterconfirm
string12185in_letterconfirmSTRADESDBOTRADE_DETAILLETTERCONFIRMVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/letterconfirm
lettered
string12186in_letteredSTRADESDBOTRADE_DETAILLETTEREDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/lettered
lettereddate
date12145in_lettereddateSTRADESDBOTRADE_DETAILLETTEREDDATEDATE
EagleML/warehouseTransaction/warehouseTrade/lettereddate
lmtGlElg
string12187in_lmt_gl_elgSTRADESDBOTRADE_DETAILLMT_GL_ELGVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/lmtGlElg
lmtGlInd
string12188in_lmt_gl_indSTRADESDBOTRADE_DETAILLMT_GL_INDVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/lmtGlInd
margin
decimal13654in_marginFTRADESDBOTRADE_DETAILMARGINNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/margin
marginpoints
decimal13655in_marginpointsFTRADESDBOTRADE_DETAILMARGINPOINTSNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/marginpoints
mortgageFlag
YesNoOptionEnum12074in_mortgage_flagSTRADESDBOTRADEMORTGAGE_FLAGCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/mortgageFlag
muniFlag
string13281in_muni_flagSTRADESDBOTRADEMUNI_FLAGCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/muniFlag
netsettleamt
decimal191in_netsettleamtFTRADESDBOTRADE_DETAILNETSETTLEAMTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/netsettleamt
navId
integer12080in_nav_idFTRADESDBOTRADENAV_IDNUMBER(28)
EagleML/warehouseTransaction/warehouseTrade/navId
numberOfAccuredDays
decimal12081in_number_of_accured_daysFTRADESDBOTRADENUMBER_OF_ACCURED_DAYSNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/numberOfAccuredDays
netCashLocal
decimal13660in_net_cash_localFTRADESDBOTRADE_DETAILNET_CASH_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/netCashLocal
notionalamt
decimal13663in_notionalamtFTRADESDBOTRADE_DETAILNOTIONALAMTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/notionalamt
notionalflag
string12189in_notionalflagSTRADESDBOTRADE_DETAILNOTIONALFLAGCHAR(1)
EagleML/warehouseTransaction/warehouseTrade/notionalflag
otherFee
decimal51in_other_feeFTRADESDBOTRADEOTHER_FEENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/otherFee
origTranNum
string12190in_orig_tran_numSTRADESDBOTRADE_DETAILORIG_TRAN_NUMVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/origTranNum
ownershipTransferDate
date12193in_ownership_transfer_dateSTRADESDBOTRADE_DETAILOWNERSHIP_TRANSFER_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/ownershipTransferDate
oidYield
decimal12084in_oid_yieldFTRADESDBOTRADEOID_YIELDNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/oidYield
otherFeeBase
decimal12085in_other_fee_baseFTRADESDBOTRADEOTHER_FEE_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/otherFeeBase
paceTradeEventId
string13664in_pace_trade_event_idSTRADESDBOTRADE_DETAILPACE_TRADE_EVENT_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/paceTradeEventId
positionIdTrd
integer13665in_position_id_trdFTRADESDBOTRADE_DETAILPOSITION_IDNUMBER(38)
EagleML/warehouseTransaction/warehouseTrade/positionIdTrd
productSubType
string13667in_product_sub_typeSTRADESDBOTRADE_DETAILPRODUCT_SUB_TYPECHAR(12)
EagleML/warehouseTransaction/warehouseTrade/productSubType
poolNumber
string12095in_pool_numberSTRADESDBOTRADEPOOL_NUMBERCHAR(12)
EagleML/warehouseTransaction/warehouseTrade/poolNumber
priceCurrency
string12096in_price_currencySTRADESDBOTRADEPRICE_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/priceCurrency
principalFactor
decimal4483in_principal_factorFTRADESDBOTRADEPRINCIPAL_FACTORNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/principalFactor
realizedGlBase
decimal13668in_realized_gl_baseFTRADESDBOTRADE_DETAILREALIZED_GL_BASENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/realizedGlBase
realizedGlCrB
decimal13669in_realized_gl_cr_bFTRADESDBOTRADE_DETAILREALIZED_GL_CR_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/realizedGlCrB
realizedGlCrL
decimal13670in_realized_gl_cr_lFTRADESDBOTRADE_DETAILREALIZED_GL_CR_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/realizedGlCrL
realizedGlLocal
decimal13671in_realized_gl_localFTRADESDBOTRADE_DETAILREALIZED_GL_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/realizedGlLocal
realizedGlNcrB
decimal13672in_realized_gl_ncr_bFTRADESDBOTRADE_DETAILREALIZED_GL_NCR_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/realizedGlNcrB
realizedGlNcrL
decimal13673in_realized_gl_ncr_lFTRADESDBOTRADE_DETAILREALIZED_GL_NCR_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/realizedGlNcrL
recdPayAcct1
string12208in_recd_pay_acct1STRADESDBOTRADE_DETAILRECD_PAY_ACCT1VARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/recdPayAcct1
recdPayAcct2
string12209in_recd_pay_acct2STRADESDBOTRADE_DETAILRECD_PAY_ACCT2VARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/recdPayAcct2
recdPayEventType
string12210in_recd_pay_event_typeSTRADESDBOTRADE_DETAILRECD_PAY_EVENT_TYPEVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/recdPayEventType
recdPayPostingPlanType
string12211in_recd_pay_posting_plan_typeSTRADESDBOTRADE_DETAILRECD_PAY_POSTING_PLAN_TYPEVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/recdPayPostingPlanType
refrate
decimal13674in_refrateFTRADESDBOTRADE_DETAILREFRATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/refrate
repoRate
decimal12146in_repo_rateFTRADESDBOTRADEREPO_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/repoRate
retailFeed
string12212in_retail_feedSTRADESDBOTRADE_DETAILRETAIL_FEEDVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/retailFeed
salesPersonLogin
string12213in_sales_person_loginSTRADESDBOTRADE_DETAILSALES_PERSON_LOGINVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/salesPersonLogin
secidType
string12222in_secid_typeSTRADESDBOTRADE_DETAILSECID_TYPEVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/secidType
sequencedate
date12195in_sequencedateSTRADESDBOTRADE_DETAILSEQUENCEDATEDATE
EagleML/warehouseTransaction/warehouseTrade/sequencedate
settleamt0
decimal13675in_settleamt0FTRADESDBOTRADE_DETAILSETTLEAMT0NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/settleamt0
settleamt1
decimal13676in_settleamt1FTRADESDBOTRADE_DETAILSETTLEAMT1NUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/settleamt1
settled
string12223in_settledSTRADESDBOTRADE_DETAILSETTLEDVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/settled
settleAmtAtMaturity
decimal12150in_settle_amt_at_maturityFTRADESDBOTRADESETTLE_AMT_AT_MATURITYNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/settleAmtAtMaturity
settlementMethod
string12103in_settlement_methodSTRADESDBOTRADESETTLEMENT_METHODCHAR(8)
EagleML/warehouseTransaction/warehouseTrade/settlementMethod
shortTermId
integer12151in_short_term_idFTRADESDBOTRADESHORT_TERM_IDNUMBER
EagleML/warehouseTransaction/warehouseTrade/shortTermId
sourceSystem
string12104in_source_systemSTRADESDBOTRADESOURCE_SYSTEMVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/sourceSystem
systemTradeTime
string12228in_system_trade_timeSTRADESDBOTRADE_DETAILSYSTEM_TRADE_TIMEVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/systemTradeTime
sentTradeStatus
string12099in_sent_trade_statusSTRADESDBOTRADESENT_TRADE_STATUSVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/sentTradeStatus
starTag151
string151in_star_tag151STRADESDBOTRADESTAR_TAG151VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/starTag151
starTag182
string182in_star_tag182STRADESDBOTRADESTAR_TAG182VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/starTag182
stateTaxWithholdBase
decimal12152in_state_tax_withhold_baseFTRADESDBOTRADESTATE_TAX_WITHHOLD_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/stateTaxWithholdBase
starLsInd

string15in_star_ls_indSTRADESDBOTRADESTAR_LS_INDVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/starLsInd
targetPurchaseDate
date12136in_target_purchase_dateSTRADESDBOTRADETARGET_PURCHASE_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/targetPurchaseDate
targetPurchasePrice
decimal12153in_target_purchase_priceFTRADESDBOTRADETARGET_PURCHASE_PRICENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/targetPurchasePrice
targetTradeTicketNumber
string12110in_target_trade_ticket_numberSTRADESDBOTRADETARGET_TRADE_TICKET_NUMBERVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/targetTradeTicketNumber
taxesBase
decimal12154in_taxes_baseFTRADESDBOTRADETAXES_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/taxesBase
timeOfTrade
decimal12159in_time_of_tradeFTRADESDBOTRADETIME_OF_TRADENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/timeOfTrade
toFxRate
decimal12160in_to_fx_rateFTRADESDBOTRADETO_FX_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/toFxRate
toLocalCommissionAmt
decimal12161in_to_local_commission_amtFTRADESDBOTRADETO_LOCAL_COMMISSION_AMTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/toLocalCommissionAmt
toSettleToBaseFxRate
decimal12162in_to_settle_to_base_fx_rateFTRADESDBOTRADETO_SETTLE_TO_BASE_FX_RATENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/toSettleToBaseFxRate
toSettlementCurrency
string12112in_to_settlement_currencySTRADESDBOTRADETO_SETTLEMENT_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/toSettlementCurrency
transactionId
string12117in_transaction_idSTRADESDBOTRADETRANSACTION_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/transactionId
turnaroundIndicator
string12118in_turnaround_indicatorSTRADESDBOTRADETURNAROUND_INDICATORVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/turnaroundIndicator
totalGainLocal
decimal10050in_total_gain_localFTRADESDBOTRADE_DETAILTOTAL_GAIN_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/totalGainLocal
totalAmortLocal
decimal5685in_total_amort_localFTRADESDBOTRADE_DETAILTOTAL_AMORT_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/totalAmortLocal
totalAmortBase
decimal5686in_total_amort_baseFTRADESDBOTRADE_DETAILTOTAL_AMORT_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/totalAmortBase
totalLossLocal
decimal10053in_total_loss_localFTRADESDBOTRADE_DETAILTOTAL_LOSS_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/totalLossLocal
tdUserChar1
string12229in_td_user_char1STRADESDBOTRADE_DETAILTD_USER_CHAR1VARCHAR2(8)
EagleML/warehouseTransaction/warehouseTrade/tdUserChar1
tdUserChar2
string12230in_td_user_char2STRADESDBOTRADE_DETAILTD_USER_CHAR2VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tdUserChar2
tdUserDate1
date12196in_td_user_date1STRADESDBOTRADE_DETAILTD_USER_DATE1DATE
EagleML/warehouseTransaction/warehouseTrade/tdUserDate1
tdUserDate2
date12202in_td_user_date2STRADESDBOTRADE_DETAILTD_USER_DATE2DATE
EagleML/warehouseTransaction/warehouseTrade/tdUserDate2
tdUserInt1
integer13677in_td_user_int1FTRADESDBOTRADE_DETAILTD_USER_INT1NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt1
tdUserInt2
integer13678in_td_user_int2FTRADESDBOTRADE_DETAILTD_USER_INT2NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt2
tdUserInt3
integer13679in_td_user_int3FTRADESDBOTRADE_DETAILTD_USER_INT3NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt3
tdUserInt4
integer13680in_td_user_int4FTRADESDBOTRADE_DETAILTD_USER_INT4NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt4
tdUserInt5
integer13681in_td_user_int5FTRADESDBOTRADE_DETAILTD_USER_INT5NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt5
tdUserInt6
integer13682in_td_user_int6FTRADESDBOTRADE_DETAILTD_USER_INT6NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt6
tdUserInt7
integer13683in_td_user_int7FTRADESDBOTRADE_DETAILTD_USER_INT7NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt7
tdUserInt8
integer13684in_td_user_int8FTRADESDBOTRADE_DETAILTD_USER_INT8NUMBER
EagleML/warehouseTransaction/warehouseTrade/tdUserInt8
tradeMemo3
string12238in_trade_memo3STRADESDBOTRADE_DETAILTRADE_MEMO3VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tradeMemo3
tradeMemo4
string12239in_trade_memo4STRADESDBOTRADE_DETAILTRADE_MEMO4VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tradeMemo4
tradeMemo5
string502in_trade_memo5STRADESDBOTRADE_DETAILTRADE_MEMO5VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tradeMemo5
thirdCurrencyFx
decimal13685in_third_currency_fxFTRADESDBOTRADE_DETAILTHIRD_CURRENCY_FXNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/thirdCurrencyFx
timeOfSalesTicket
string12232in_time_of_sales_ticketSTRADESDBOTRADE_DETAILTIME_OF_SALES_TICKETVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/timeOfSalesTicket
timeOfSlate
string12233in_time_of_slateSTRADESDBOTRADE_DETAILTIME_OF_SLATEVARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/timeOfSlate
tradeChar1
string12113in_trade_char1STRADESDBOTRADETRADE_CHAR1VARCHAR2(30)
EagleML/warehouseTransaction/warehouseTrade/tradeChar1
tradeFlat
string12114in_trade_flatSTRADESDBOTRADETRADE_FLATCHAR(2)
EagleML/warehouseTransaction/warehouseTrade/tradeFlat
tradersLogin
string12116in_traders_loginSTRADESDBOTRADETRADERS_LOGINCHAR(12)
EagleML/warehouseTransaction/warehouseTrade/tradersLogin
transcost4Amount
decimal13686in_transcost4_amountFTRADESDBOTRADE_DETAILTRANSCOST4_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/transcost4Amount
transcost4Code
string12240in_transcost4_codeSTRADESDBOTRADE_DETAILTRANSCOST4_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/transcost4Code
transcost4Currency
string12241in_transcost4_currencySTRADESDBOTRADE_DETAILTRANSCOST4_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/transcost4Currency
transcost4TypeCode
string12242in_transcost4_type_codeSTRADESDBOTRADE_DETAILTRANSCOST4_TYPE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/transcost4TypeCode
transcost5Amount
decimal13687in_transcost5_amountFTRADESDBOTRADE_DETAILTRANSCOST5_AMOUNTNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/transcost5Amount
transcost5Code
string12243in_transcost5_codeSTRADESDBOTRADE_DETAILTRANSCOST5_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/transcost5Code
transcost5Currency
string12244in_transcost5_currencySTRADESDBOTRADE_DETAILTRANSCOST5_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/transcost5Currency
transcost5TypeCode
string12245in_transcost5_type_codeSTRADESDBOTRADE_DETAILTRANSCOST5_TYPE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/transcost5TypeCode
updateSourceTrd
string12261in_update_source_trdSTRADESDBOTRADE_DETAILUPDATE_SOURCECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/updateSourceTrd
underlyingAccrIntB
decimal12164in_underlying_accr_int_bFTRADESDBOTRADEUNDERLYING_ACCR_INT_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntB
underlyingAccrIntL
decimal12165in_underlying_accr_int_lFTRADESDBOTRADEUNDERLYING_ACCR_INT_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntL
underlyingAccrIntLMat
decimal12201in_underlying_accr_int_l_matFTRADESDBOTRADEUNDERLYING_ACCR_INT_L_MATNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntLMat
withholdCode
string12263in_withhold_codeSTRADESDBOTRADE_DETAILWITHHOLD_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/withholdCode
withholdCurrency
string12264in_withhold_currencySTRADESDBOTRADE_DETAILWITHHOLD_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/withholdCurrency
withholdTypeCode
string12265in_withhold_type_codeSTRADESDBOTRADE_DETAILWITHHOLD_TYPE_CODECHAR(8)
EagleML/warehouseTransaction/warehouseTrade/withholdTypeCode
workoutDate
date12214in_workout_dateSTRADESDBOTRADE_DETAILWORKOUT_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/workoutDate
workoutPrice
decimal13689in_workout_priceFTRADESDBOTRADE_DETAILWORKOUT_PRICENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/workoutPrice
withholdingTax
decimal12216in_withholding_taxFTRADESDBOTRADEWITHHOLDING_TAXNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/withholdingTax
batchEventId
string701in_batch_event_idSTRADESDBOTRADE_DETAILBATCH_EVENT_IDVARCHAR2(55)
EagleML/warehouseTransaction/warehouseTrade/batchEventId
secFee
decimal3752in_sec_feesFTRADESDBOTRADESEC_FEESNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/secFee
tradeDate
date35in_trade_dateSTRADESDBOTRADETRADE_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/tradeDate
recordType
string12097in_record_typeSTRADESDBOTRADERECORD_TYPECHAR(4)
EagleML/warehouseTransaction/warehouseTrade/recordType
costLocal

decimal162in_cost_localFTRADESDBOTRADECOST_LOCALNUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/costLocal
costBase

decimal166in_cost_baseFTRADESDBOTRADECOST_BASENUMBER(28,12)
EagleML/warehouseTransaction/warehouseTrade/costBase
linkEventId
TransactionId28in_link_event_idSTRADESDBOTRADELINK_EVENT_IDVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/linkEventId
localCurrency
CurrencyCode


not stored in DB

EagleML/warehouseTransaction/warehouseTrade/localCurrency
commissionCurrency
CurrencyCode85

TRADESDBOTRADECOMMISSION_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/commissionCurrency
eventSequence
integer126

TRADESDBOTRADEEVENT_SEQUENCEINTEGER
EagleML/warehouseTransaction/warehouseTrade/eventSequence
starTag26
string26

TRADESDBOTRADESTAR_TAG26VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/starTag26
tradeCurrency
CurrencyCode85

TRADESDBOTRADETRADE_CURRENCYCHAR(3)
EagleML/warehouseTransaction/warehouseTrade/tradeCurrency
settleInstructions1
string8074in_settle_instructions1STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS1VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settleInstructions1
settleInstructions2
string8075in_settle_instructions2STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS2VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settleInstructions2
settleInstructions3
string8076in_settle_instructions3STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS3VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settleInstructions3
settleInstructions4
string8077in_settle_instructions4STRADESDBOTRADE_DETAILSETTLE_INSTRUCTIONS4VARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/settleInstructions4
orderNumber
string1092in_order_number
TRADESDBOTRADEORDER_NUMBERVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/orderNumber
priceMethod
normalizedString1872in_price_methodSTRADESDBOTRADEPRICE_METHODVARCHAR2(4)
EagleML/warehouseTransaction/warehouseTrade/priceMethod
regulatoryIntent
normalizedString8915in_regulatory_intentSTRADESDBOTRADEREGULATORY_INTENTVARCHAR2(3)
EagleML/warehouseTransaction/warehouseTrade/regulatoryIntent
holdingTerm
normalizedString9091in_holding_termSTRADESDBOTRADEHOLDING_TERMVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/holdingTerm
income
decimal2552in_incomeFTRADESDBOTRADEINCOMENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/income
incomeAmountBase
decimal2559in_income_baseFTRADESDBOTRADEINCOME_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/incomeAmountBase
deskAka
string7350in_counterparty_desk_akaSTRADESDBOTRADE_DETAIL_EXTCOUNTERPARTY_DESK_AKAVARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/deskAka
deskType
string7002in_counterparty_desk_typeSTRADESDBOTRADE_DETAIL_EXTCOUNTERPARTY_DESK_TYPEVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/deskType
desk
string7003in_counterparty_deskSTRADESDBOTRADE_DETAIL_EXTCOUNTERPARTY_DESKVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/desk
exSubBrokerId
string7004in_ex_sub_broker_idSTRADESDBOTRADE_DETAIL_EXTEX_SUB_BROKER_IDVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/exSubBrokerId
placementNum
string7005in_placement_numSTRADESDBOTRADE_DETAIL_EXTPLACEMENT_NUM

EagleML/warehouseTransaction/warehouseTrade/placementNum
subBrokerCode
string7006in_sub_broker_codeSTRADESDBOTRADE_DETAIL_EXTSUB_BROKER_CODEVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/subBrokerCode
tradeInterfaceInfo
string7007in_trade_error_noteSTRADESDBOTRADE_DETAIL_EXTTRADE_ERROR_NOTEVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/tradeInterfaceInfo
trdBrokerAka
string7008in_alt_trade_broker_codeSTRADESDBOTRADE_DETAIL_EXTALT_TRADE_BROKER_CODEVARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdBrokerAka
trdDirtyPrice
decimal7962in_trd_dirty_priceFTRADESDBOTRADE_DETAIL_EXTTRD_DIRTY_PRICENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDirtyPrice
trdExBrokerDesk
string7009in_ex_broker_deskSTRADESDBOTRADE_DETAIL_EXTEX_BROKER_DESKVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/trdExBrokerDesk
trdExDeskType
string7010in_ex_broker_desk_typeSTRADESDBOTRADE_DETAIL_EXTEX_BROKER_DESK_TYPEVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/trdExDeskType
trdExternalAccountLoc
string7011in_trd_external_account_locSTRADESDBOTRADE_DETAIL_EXTTRD_EXTERNAL_ACCOUNT_LOCVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/trdExternalAccountLoc
trdLocation
string7012in_trd_locationSTRADESDBOTRADE_DETAIL_EXTTRD_LOCATIONVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/trdLocation
trdSeriesNum
string7013in_trd_lot_num_codeSTRADESDBOTRADE_DETAIL_EXTTRD_LOT_NUM_CODEVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/trdSeriesNum
trdVersion
string7014in_trd_versionSTRADESDBOTRADE_DETAIL_EXTTRD_VERSIONVARCHAR2(50)
EagleML/warehouseTransaction/warehouseTrade/trdVersion
trdExtidId1
string7015in_trd_external_id_1STRADESDBOTRADE_DETAIL_EXTTRD_EXTERNAL_ID_1VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdExtidId1
trdExtidId2
string7016in_trd_external_id_2STRADESDBOTRADE_DETAIL_EXTTRD_EXTERNAL_ID_2VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdExtidId2
tbaInvnum
integer
in_tba_invnumFTRADESDBOTRADE_DETAIL_EXTTBA_INVNUM

EagleML/warehouseTransaction/warehouseTrade/tbaInvnum
tbaTrdDate
date
in_tba_trd_dateSTRADESDBOTRADE_DETAIL_EXTTBA_TRD_DATE

EagleML/warehouseTransaction/warehouseTrade/tbaTrdDate
collatExposureType
string
in_collat_exposure_typeSTRADESDBOTRADE_DETAIL_EXTCOLLAT_EXPOSURE_TYPE

EagleML/warehouseTransaction/warehouseTrade/collatExposureType
effTermDate
date
in_eff_term_dateSTRADESDBOTRADE_DETAIL_EXTEFF_TERM_DATE

EagleML/warehouseTransaction/warehouseTrade/effTermDate
contractRef
string
in_utiSTRADESDBOTRADE_DETAIL_EXTUTI

EagleML/warehouseTransaction/warehouseTrade/contractRef
trdExternalId1Type
string
in_trd_external_id_1_typeSTRADESDBOTRADE_DETAIL_EXTTRD_EXTERNAL_ID_1_TYPE

EagleML/warehouseTransaction/warehouseTrade/trdExternalId1Type
trdExternalId2Type
string
in_trd_external_id_2_typeSTRADESDBOTRADE_DETAIL_EXTTRD_EXTERNAL_ID_2_TYPE

EagleML/warehouseTransaction/warehouseTrade/trdExternalId2Type
newIssueIndicator
string18302in_new_issueSTRADESDBOTRADE_DETAIL_EXTNEW_ISSUEVARCHAR2(3)
EagleML/warehouseTransaction/warehouseTrade/newIssueIndicator
dealSource
string18303in_deal_sourceSTRADESDBOTRADE_DETAIL_EXTDEAL_SOURCEVARCHAR2(40)
EagleML/warehouseTransaction/warehouseTrade/dealSource
stGainSecLocal
decimal17347

TRADESDBOTRADE_EXTST_GAIN_SEC_L

EagleML/warehouseTransaction/warehouseTrade/stGainSecLocal
stLossSecLocal
decimal17348

TRADESDBOTRADE_EXTST_LOSS_SEC_L

EagleML/warehouseTransaction/warehouseTrade/stLossSecLocal
stGainSecBase
decimal17349

TRADESDBOTRADE_EXTST_GAIN_SEC_B

EagleML/warehouseTransaction/warehouseTrade/stGainSecBase
stLossSecBase
decimal17350

TRADESDBOTRADE_EXTST_LOSS_SEC_B

EagleML/warehouseTransaction/warehouseTrade/stLossSecBase
stGain
decimal17351

TRADESDBOTRADE_EXTST_GAIN

EagleML/warehouseTransaction/warehouseTrade/stGain
stLoss
decimal17352

TRADESDBOTRADE_EXTST_LOSS

EagleML/warehouseTransaction/warehouseTrade/stLoss
stGainCurrency
decimal17353

TRADESDBOTRADE_EXTST_GAIN_CRRCY

EagleML/warehouseTransaction/warehouseTrade/stGainCurrency
stLossCurrency
decimal17354

TRADESDBOTRADE_EXTST_LOSS_CRRCY

EagleML/warehouseTransaction/warehouseTrade/stLossCurrency
ltGainSecLocal
decimal17355

TRADESDBOTRADE_EXTLT_GAIN_SEC_L

EagleML/warehouseTransaction/warehouseTrade/ltGainSecLocal
ltLossSecLocal
decimal17356

TRADESDBOTRADE_EXTLT_LOSS_SEC_L

EagleML/warehouseTransaction/warehouseTrade/ltLossSecLocal
ltGainSecBase
decimal17357

TRADESDBOTRADE_EXTLT_GAIN_SEC_B

EagleML/warehouseTransaction/warehouseTrade/ltGainSecBase
ltLossSecBase
decimal17358

TRADESDBOTRADE_EXTLT_LOSS_SEC_B

EagleML/warehouseTransaction/warehouseTrade/ltLossSecBase
ltGain
decimal17359

TRADESDBOTRADE_EXTLT_GAIN

EagleML/warehouseTransaction/warehouseTrade/ltGain
ltLoss
decimal17360

TRADESDBOTRADE_EXTLT_LOSS

EagleML/warehouseTransaction/warehouseTrade/ltLoss
ltGainCurrency
decimal17361

TRADESDBOTRADE_EXTLT_GAIN_CRRCY

EagleML/warehouseTransaction/warehouseTrade/ltGainCurrency
ltLossCurrency
decimal17362

TRADESDBOTRADE_EXTLT_LOSS_CRRCY

EagleML/warehouseTransaction/warehouseTrade/ltLossCurrency
clsAmortLocal
decimal17363

TRADESDBOTRADE_EXTCLS_AMORT_LOCAL

EagleML/warehouseTransaction/warehouseTrade/clsAmortLocal
clsAmortBase
decimal17364

TRADESDBOTRADE_EXTCLS_AMORT_BASE

EagleML/warehouseTransaction/warehouseTrade/clsAmortBase
clsOidLocal
decimal17365

TRADESDBOTRADE_EXTCLS_OID_L

EagleML/warehouseTransaction/warehouseTrade/clsOidLocal
clsOidBase
decimal17366

TRADESDBOTRADE_EXTCLS_OID_B

EagleML/warehouseTransaction/warehouseTrade/clsOidBase
clsIlbIncLtdLocal
decimal17367

TRADESDBOTRADE_EXTCLS_ILB_INC_LTD_LOCAL

EagleML/warehouseTransaction/warehouseTrade/clsIlbIncLtdLocal
clsIlbIncLtdBase
decimal17368

TRADESDBOTRADE_EXTCLS_ILB_INC_LTD_BASE

EagleML/warehouseTransaction/warehouseTrade/clsIlbIncLtdBase
gainCurrency988
decimal17369in_gain_currency_988
TRADESDBOTRADE_EXTGAIN_CRRCY_988

EagleML/warehouseTransaction/warehouseTrade/gainCurrency988
lossCurrency988
decimal17370in_loss_currency_988
TRADESDBOTRADE_EXTLOSS_CRRCY_988

EagleML/warehouseTransaction/warehouseTrade/lossCurrency988
gainLossCurrency988
decimal17371

TRADESDBOTRADE_EXTGAIN_LOSS_CRRCY_988

EagleML/warehouseTransaction/warehouseTrade/gainLossCurrency988
washsaleDisallowedReversalLocal
decimal17372

TRADESDBOTRADE_EXTWS_DISALLOW_REV_L

EagleML/warehouseTransaction/warehouseTrade/washsaleDisallowedReversalLocal
washsaleDisallowedReversalBase
decimal17373

TRADESDBOTRADE_EXTWS_DISALLOW_REV_B

EagleML/warehouseTransaction/warehouseTrade/washsaleDisallowedReversalBase
impairmentLtdLocalExt
decimal17374

TRADESDBOTRADE_EXTIMPAIRMENT_LTD_LOCAL

EagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocalExt
impairmentLtdBaseExt
decimal17375

TRADESDBOTRADE_EXTIMPAIRMENT_LTD_BASE

EagleML/warehouseTransaction/warehouseTrade/impairmentLtdBaseExt
impairmentFxLtd
decimal17376

TRADESDBOTRADE_EXTIMPAIRMENT_FX_LTD

EagleML/warehouseTransaction/warehouseTrade/impairmentFxLtd
recPayAcctSecondary
string17377

TRADESDBOTRADE_EXTREC_PAY_ACCT_SECONDARY

EagleML/warehouseTransaction/warehouseTrade/recPayAcctSecondary
recPayAcct2Secondary
string17378

TRADESDBOTRADE_EXTREC_PAY_ACCT2_SECONDARY

EagleML/warehouseTransaction/warehouseTrade/recPayAcct2Secondary
nonCreditLedgerDebit
string17379

TRADESDBOTRADE_EXTNON_CREDIT_LEDGER_DR

EagleML/warehouseTransaction/warehouseTrade/nonCreditLedgerDebit
nonCreditLedgerCredit
string17380

TRADESDBOTRADE_EXTNON_CREDIT_LEDGER_CR

EagleML/warehouseTransaction/warehouseTrade/nonCreditLedgerCredit
ociLedgerDebit
string17381

TRADESDBOTRADE_EXTOCI_LEDGER_DR

EagleML/warehouseTransaction/warehouseTrade/ociLedgerDebit
ociLedgerCredit
string17382

TRADESDBOTRADE_EXTOCI_LEDGER_CR

EagleML/warehouseTransaction/warehouseTrade/ociLedgerCredit
fxImpairLedgerDebit
string17383

TRADESDBOTRADE_EXTFX_IMPAIR_LEDGER_DR

EagleML/warehouseTransaction/warehouseTrade/fxImpairLedgerDebit
fxImpairLedgerCredit
string17384

TRADESDBOTRADE_EXTFX_IMPAIR_LEDGER_CR

EagleML/warehouseTransaction/warehouseTrade/fxImpairLedgerCredit
breakageAmountLocal
decimal17385

TRADESDBOTRADE_EXTBREAKAGE_AMOUNT_LOCAL

EagleML/warehouseTransaction/warehouseTrade/breakageAmountLocal
breakageAmountBase
decimal17386

TRADESDBOTRADE_EXTBREAKAGE_AMOUNT_BASE

EagleML/warehouseTransaction/warehouseTrade/breakageAmountBase
trdDetExtUserFloat1
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT1NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat1
trdDetExtUserFloat2
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT2NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat2
trdDetExtUserFloat3
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT3NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat3
trdDetExtUserFloat4
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT4NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat4
trdDetExtUserFloat5
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT5NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat5
trdDetExtUserFloat6
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT6NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat6
trdDetExtUserFloat7
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT7NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat7
trdDetExtUserFloat8
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT8NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat8
trdDetExtUserFloat9
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT9NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat9
trdDetExtUserFloat10
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT10NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat10
trdDetExtUserFloat11
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT11NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat11
trdDetExtUserFloat12
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT12NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat12
trdDetExtUserFloat13
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT13NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat13
trdDetExtUserFloat14
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT14NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat14
trdDetExtUserFloat15
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT15NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat15
trdDetExtUserFloat16
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT16NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat16
trdDetExtUserFloat17
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT17NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat17
trdDetExtUserFloat18
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT18NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat18
trdDetExtUserFloat19
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT19NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat19
trdDetExtUserFloat20
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT20NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat20
trdDetExtUserFloat21
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT21NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat21
trdDetExtUserFloat22
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT22NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat22
trdDetExtUserFloat23
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT23NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat23
trdDetExtUserFloat24
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT24NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat24
trdDetExtUserFloat25
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT25NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat25
trdDetExtUserFloat26
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT26NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat26
trdDetExtUserFloat27
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT27NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat27
trdDetExtUserFloat28
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT28NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat28
trdDetExtUserFloat29
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT29NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat29
trdDetExtUserFloat30
decimal


TRADESDBOTRADE_DETAIL_EXTUSER_FLOAT30NUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat30
trdDetExtUserChar1
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR1VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar1
trdDetExtUserChar2
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR2VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar2
trdDetExtUserChar3
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR3VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar3
trdDetExtUserChar4
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR4VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar4
trdDetExtUserChar5
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR5VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar5
trdDetExtUserChar6
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR6VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar6
trdDetExtUserChar7
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR7VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar7
trdDetExtUserChar8
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR8VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar8
trdDetExtUserChar9
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR9VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar9
trdDetExtUserChar10
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR10VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar10
trdDetExtUserChar11
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR11VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar11
trdDetExtUserChar12
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR12VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar12
trdDetExtUserChar13
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR13VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar13
trdDetExtUserChar14
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR14VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar14
trdDetExtUserChar15
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR15VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar15
trdDetExtUserChar16
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR16VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar16
trdDetExtUserChar17
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR17VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar17
trdDetExtUserChar18
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR18VARCHAR2(60)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar18
trdDetExtUserChar19
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR19VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar19
trdDetExtUserChar20
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR20VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar20
trdDetExtUserChar21
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR21VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar21
trdDetExtUserChar22
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR22VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar22
trdDetExtUserChar23
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR23VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar23
trdDetExtUserChar24
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR24VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar24
trdDetExtUserChar25
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR25VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar25
trdDetExtUserChar26
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR26VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar26
trdDetExtUserChar27
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR27VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar27
trdDetExtUserChar28
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR28VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar28
trdDetExtUserChar29
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR29VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar29
trdDetExtUserChar30
string


TRADESDBOTRADE_DETAIL_EXTUSER_CHAR30VARCHAR2(200)
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar30
trdDetExtUserDate1
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE1DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate1
trdDetExtUserDate2
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE2DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate2
trdDetExtUserDate3
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE3DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate3
trdDetExtUserDate4
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE4DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate4
trdDetExtUserDate5
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE5DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate5
trdDetExtUserDate6
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE6DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate6
trdDetExtUserDate7
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE7DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate7
trdDetExtUserDate8
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE8DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate8
trdDetExtUserDate9
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE9DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate9
trdDetExtUserDate10
date


TRADESDBOTRADE_DETAIL_EXTUSER_DATE10DATE
EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate10
consolidatedIndicator


in_consolidated_flag
TRADESDBOTRADECONSOLIDATED_FLAGCHAR(1)
EagleML/warehouseTransaction/warehouseTrade/consolidatedIndicator
fromRegulatoryCategory


in_from_regulatory_category
TRADESDBOTRADEFROM_REGULATORY_CATEGORYVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/fromRegulatoryCategory
toRegulatoryCategory


in_to_regulatory_category
TRADESDBOTRADETO_REGULATORY_CATEGORYVARCHAR2(20)
EagleML/warehouseTransaction/warehouseTrade/toRegulatoryCategory
cancelPostDate


in_cancel_post_date
TRADESDBOTRADE_DETAILCANCEL_POST_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/cancelPostDate
cancelReasonIndicator


in_cancel_reason_flag
TRADESDBOTRADE_DETAILCANCEL_REASON_FLAGVARCHAR2(255)
EagleML/warehouseTransaction/warehouseTrade/cancelReasonIndicator
commitmentAmount


in_commitment
TRADESDBOTRADE_DETAILCOMMITMENTNUMBER(38,12) 
EagleML/warehouseTransaction/warehouseTrade/commitmentAmount
distributedInvestmentIncomeLocal


in_dist_inv_inc_l
TRADESDBOTRADE_DETAILDIST_INV_INC_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/distributedInvestmentIncomeLocal
distributedInvestmentIncomeBase


in_dist_inv_inc_b
TRADESDBOTRADE_DETAILDIST_INV_INC_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/distributedInvestmentIncomeBase
expectedCreditLossAmountLocal


in_ecl_local
TRADESDBOTRADE_DETAILECL_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossAmountLocal
expectedCreditLossAmountBase


in_ecl_base
TRADESDBOTRADE_DETAILECL_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossAmountBase
expectedCreditLossDeltaAmountLocal


in_ecl_delta_local
TRADESDBOTRADE_DETAILECL_DELTA_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossDeltaAmountLocal
expectedCreditLossDeltaAmountBase


in_ecl_delta_base
TRADESDBOTRADE_DETAILECL_DELTA_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossDeltaAmountBase
expectedCreditLossPreviousAmountLocal


in_ecl_prev_local
TRADESDBOTRADE_DETAILECL_PREV_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossPreviousAmountLocal
expectedCreditLossPreviousAmountBase


in_ecl_prev_base
TRADESDBOTRADE_DETAILECL_PREV_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossPreviousAmountBase
expectedCreditLossStageAmount


in_ecl_stage
TRADESDBOTRADE_DETAILECL_STAGENUMBER(38)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossStageAmount
expectedCreditLossPreviousStageAmount


in_ecl_prev_stage
TRADESDBOTRADE_DETAILECL_PREV_STAGENUMBER(38)
EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossPreviousStageAmount
equityMethodAcctCostIndicator


in_ema_cost_flag
TRADESDBOTRADE_DETAILEMA_COST_FLAGVARCHAR2(5)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctCostIndicator
equityMethodAcctTreatmentMethod


in_ema_treatment
TRADESDBOTRADE_DETAILEMA_TREATMENTVARCHAR2(10)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctTreatmentMethod
fxImpairmentRate


in_fx_impairment
TRADESDBOTRADE_DETAILFX_IMPAIRMENTNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/fxImpairmentRate
equityMethodAcctCRCCTGainBase


in_gain_crcct_ema_b
TRADESDBOTRADE_DETAILGAIN_CRCCT_EMA_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctCRCCTGainBase
currentPeriodCurrencyGain


in_gain_crrcy_curr_pre
TRADESDBOTRADE_DETAILGAIN_CRRCY_CURR_PRENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentPeriodCurrencyGain
currencyIncomeGain


in_gain_crrcy_income
TRADESDBOTRADE_DETAILGAIN_CRRCY_INCOMENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currencyIncomeGain
termGainLoss


in_gain_loss_term
TRADESDBOTRADE_DETAILGAIN_LOSS_TERMVARCHAR2(2)
EagleML/warehouseTransaction/warehouseTrade/termGainLoss
currentPeriodSecurityGainBase


in_gain_sec_curr_b_pre
TRADESDBOTRADE_DETAILGAIN_SEC_CURR_B_PRENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityGainBase
currentPeriodSecurityGainLocal


in_gain_sec_curr_l_pre
TRADESDBOTRADE_DETAILGAIN_SEC_CURR_L_PRENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityGainLocal
equityMethodAcctSecurityGainBase


in_gain_sec_ema_b
TRADESDBOTRADE_DETAILGAIN_SEC_EMA_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityGainBase
equityMethodAcctSecurityGainLocal


in_gain_sec_ema_l
TRADESDBOTRADE_DETAILGAIN_SEC_EMA_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityGainLocal
impairReasonCode


in_impair_reason_code
TRADESDBOTRADE_DETAILIMPAIR_REASON_CODEVARCHAR2(5)
EagleML/warehouseTransaction/warehouseTrade/impairReasonCode
equityMethodAcctCurrencyLossBase


in_loss_crccy_ema_b
TRADESDBOTRADE_DETAILLOSS_CRCCY_EMA_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctCurrencyLossBase
currentPeriodCurrencyLoss


in_loss_crrcy_curr_pre
TRADESDBOTRADE_DETAILLOSS_CRRCY_CURR_PRENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentPeriodCurrencyLoss
currencyIncomeLoss


in_loss_crrcy_income
TRADESDBOTRADE_DETAILLOSS_CRRCY_INCOMENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currencyIncomeLoss
currentPeriodSecurityLossBase


in_loss_sec_curr_b_pre
TRADESDBOTRADE_DETAILLOSS_SEC_CURR_B_PRENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityLossBase
currentPeriodSecurityLossLocal


in_loss_sec_curr_l_pre
TRADESDBOTRADE_DETAILLOSS_SEC_CURR_L_PRENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityLossLocal
equityMethodAcctSecurityLossBase


in_loss_sec_ema_b
TRADESDBOTRADE_DETAILLOSS_SEC_EMA_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityLossBase
equityMethodAcctSecurityLossLocal


in_loss_sec_ema_l
TRADESDBOTRADE_DETAILLOSS_SEC_EMA_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityLossLocal
equityMethodAcctMarketVaueBase


in_mkt_val_ema_b
TRADESDBOTRADE_DETAILMKT_VAL_EMA_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctMarketVaueBase
equityMethodAcctMarketVaueLocal


in_mkt_val_ema_l
TRADESDBOTRADE_DETAILMKT_VAL_EMA_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctMarketVaueLocal
notionalOrUnitsIndicator


in_notional_or_units_flag
TRADESDBOTRADE_DETAILNOTIONAL_OR_UNITS_FLAGVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/notionalOrUnitsIndicator
ownershipPercentage


in_ownership_percentage
TRADESDBOTRADE_DETAILOWNERSHIP_PERCENTAGENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/ownershipPercentage
cashFlowEffectiveDate


in_performance_eff_date
TRADESDBOTRADE_DETAILPERFORMANCE_EFF_DATEDATE
EagleML/warehouseTransaction/warehouseTrade/cashFlowEffectiveDate
equityMethodAcctPeriodMarketValueLocal


in_pre_mkt_val_ema_l
TRADESDBOTRADE_DETAILPRE_MKT_VAL_EMA_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctPeriodMarketValueLocal
equityMethodAcctPeriodMarketValueBase


in_pre_mkt_val_ema_b
TRADESDBOTRADE_DETAILPRE_MKT_VAL_EMA_BNUMBER(38,12) 
EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctPeriodMarketValueBase
prorataCreditNonCreditLossFlag


in_prorata_cnc_loss_flag
TRADESDBOTRADE_DETAILPRORATA_CNC_LOSS_FLAGVARCHAR2(3)
EagleML/warehouseTransaction/warehouseTrade/prorataCreditNonCreditLossFlag
purchasedImpairedIndicator


in_purchased_impaired
TRADESDBOTRADE_DETAILPURCHASED_IMPAIREDVARCHAR2(1)
EagleML/warehouseTransaction/warehouseTrade/purchasedImpairedIndicator
researchFeeLocal


in_research_fees_local
TRADESDBOTRADE_DETAILRESEARCH_FEES_LOCALNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/researchFeeLocal
researchFeeBase


in_research_fees_base
TRADESDBOTRADE_DETAILRESEARCH_FEES_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/researchFeeBase
sleeveId


in_sleeve_id
TRADESDBOTRADE_DETAILSLEEVE_IDVARCHAR2(55)
EagleML/warehouseTransaction/warehouseTrade/sleeveId
srcSysC


in_src_sys_c
TRADESDBOTRADE_DETAILSRC_SYS_CVARCHAR2(25)
EagleML/warehouseTransaction/warehouseTrade/srcSysC
starSourceLevel


in_star_src_lvl
TRADESDBOTRADE_DETAILSTAR_SRC_LVLVARCHAR2(4)
EagleML/warehouseTransaction/warehouseTrade/starSourceLevel
technicalShortLevel


in_techsh_src
TRADESDBOTRADE_DETAILTECHSH_SRCVARCHAR2(25)
EagleML/warehouseTransaction/warehouseTrade/technicalShortLevel
undistributedInvestmentIncomeBase


in_undist_inv_inc_b
TRADESDBOTRADE_DETAILUNDIST_INV_INC_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/undistributedInvestmentIncomeBase
undistributedInvestmentIncomeLocal


in_undist_inv_inc_l
TRADESDBOTRADE_DETAILUNDIST_INV_INC_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/undistributedInvestmentIncomeLocal
unrealizedUndistributedInvestmentIncomeBase


in_unreal_undist_inv_inc_l
TRADESDBOTRADE_DETAILUNREAL_UNDIST_INV_INC_LNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/unrealizedUndistributedInvestmentIncomeBase
unrealizedUndistributedInvestmentIncomeLocal


in_unreal_undist_inv_inc_b
TRADESDBOTRADE_DETAILUNREAL_UNDIST_INV_INC_BNUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/unrealizedUndistributedInvestmentIncomeLocal
settleAmountBase


in_settle_amount_base
TRADESDBOTRADE_DETAILSETTLE_AMOUNT_BASENUMBER(38,12)
EagleML/warehouseTransaction/warehouseTrade/settleAmountBase
TradeChargesModel
Trade Charges Model - see extra tableEagleML/warehouseTransaction/warehouseTrade/TradeChargesModel/
TradeQuotesModel
Trade Quotes Model - see extra tableEagleML/warehouseTransaction/warehouseTrade/TradeQuotesModel/
BrokerTradeQuoteModel
Broker Trade Quote Model - see extra tableEagleML/warehouseTransaction/warehouseTrade/BrokerTradeQuoteModel/

To add the elements below to your extact, please set IncludeExtendedDetails=ALL or IncludeExtendedDetails=Y in the RTR. For more information, see Use Calculated IDs for Transactions.
if EnhanceCalcTransactionId parameter is not specified or set to N, starTag26 is not used for calculation
if EnhanceCalcTransactionId parameter is set to Y, starTag26 is used to resolve these elements

calcTransactionId
string2983






EagleML/warehouseTransaction/warehouseTrade/calcTransactionId
calcMasterTransactionId
string2984



MASTER_TXN_ID

EagleML/warehouseTransaction/warehouseTrade/calcMasterTransactionId
calcCancelTransactionId
string2985



CXL_TARGET_ID

EagleML/warehouseTransaction/warehouseTrade/calcCancelTransactionId


  • No labels