| Element | Optional /Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | DB Required | Xpath |
|---|
| 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 |
|
|
| TRADESDBO | TRADE | UPDATE_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/updateTimestamp |
| customElements | Not recommended | CustomElements |
|
|
| reserved for customizations |
|
| EagleML/warehouseTransaction/warehouseTrade/customElements |
| sourceName |
| string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | Y | EagleML/warehouseTransaction/warehouseTrade/sourceName |
| updateSource | Required | string | 944 | in_update_source | S | TRADESDBO | TRADE | UPDATE_SOURCE | CHAR(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 |
| date | 221 | in_effective_date | S | TRADESDBO | TRADE | EFFECTIVE_DATE | DATE | Y | EagleML/warehouseTransaction/warehouseTrade/effectiveDate |
| Entity Common Id Model | EagleML/warehouseTransaction/warehouseTrade/ |
| Extended Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehouseTrade/ |
| accountingBasis |
| string | 21 | in_acct_basis | S | TRADESDBO | TRADE | ACCT_BASIS | VARCHAR2(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 Model | EagleML/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 |
| string | 88 | in_broker_code | S | TRADESDBO | TRADE | BROKER_CODE | CHAR(12) |
| EagleML/warehouseTransaction/warehouseTrade/brokerCode |
| clearingBrokerCode |
| string | 1237 | in_clearing_broker_code | S | TRADESDBO | TRADE_DETAIL | CLEARING_BROKER_CODE | CHAR(20) |
| EagleML/warehouseTransaction/warehouseTrade/clearingBrokerCode |
| status |
| string | 54 | in_trade_status | S | TRADESDBO | TRADE | TRADE_STATUS | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/status |
| taxAmountLocal |
| decimal | 46 | in_taxes | F | TRADESDBO | TRADE | TAXES | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/taxAmountLocal |
| commissionAmount |
| decimal | 12019 | in_commission_amount | F | TRADESDBO | TRADE | COMMISSION_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/commissionAmount |
| accruedInterest |
| decimal | 49 | in_accrued_interest | F | TRADESDBO | TRADE | ACCRUED_INTEREST | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/accruedInterest |
| baseCurrency |
| CurrencyCode | 86 | in_base_currency | S | TRADESDBO | TRADE | BASE_CURRENCY | VARCHAR2(3) |
| EagleML/warehouseTransaction/warehouseTrade/baseCurrency |
| monthEndAccountingDate |
| date | 4733 | in_month_end_date | S | TRADESDBO | TRADE | MONTH_END_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/monthEndAccountingDate |
| tradeId |
| integer |
|
|
| TRADESDBO | TRADE | TRADE_ID | NUMBER | Y | EagleML/warehouseTransaction/warehouseTrade/tradeId |
| accruedInterestType |
| string | 3715 | in_accrued_interest_type | S | TRADESDBO | TRADE | ACCRUED_INTEREST_TYPE | VARCHAR2(3) |
| EagleML/warehouseTransaction/warehouseTrade/accruedInterestType |
| accruedIncomeLocal |
| decimal | 10758 | in_accrued_income_local | F | TRADESDBO | TRADE | ACCRUED_INCOME_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/accruedIncomeLocal |
| cancelAccountingDt |
| date | 12138 | in_cancel_acctg_date | S | TRADESDBO | TRADE_DETAIL | CANCEL_ACCTG_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/cancelAccountingDt |
| cancelMthendAccountingDt |
| date | 12139 | in_cancel_me_acctg_date | S | TRADESDBO | TRADE_DETAIL | CANCEL_ME_ACCTG_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/cancelMthendAccountingDt |
| cancelFlag |
| string | 10045 | in_cancel_flag | S | TRADESDBO | TRADE_DETAIL | CANCEL_FLAG | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/cancelFlag |
| cancelStatus |
| string | 10046 | in_cancel_status | S | TRADESDBO | TRADE_DETAIL | CANCEL_STATUS | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/cancelStatus |
| cancelEffectiveDt |
| date | 504 | in_cancel_effective_date | S | TRADESDBO | TRADE_DETAIL | CANCEL_EFFECTIVE_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/cancelEffectiveDt |
| cancelEventId |
| TransactionId | 501 | in_cancel_event_id | S | TRADESDBO | TRADE | CANCEL_EVENT_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/cancelEventId |
| cancelLinkEventId |
| TransactionId | 506 | in_cancel_linked_event_id | S | TRADESDBO | TRADE | CANCEL_LINKED_EVENT_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/cancelLinkEventId |
| currBuiltInGlSecurity |
| decimal | 9761 | in_curr_builtin_gl_sec | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_SEC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlSecurity |
| currBuiltInGlCurrency |
| decimal | 10917 | in_curr_builtin_gl_currency | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_CURRENCY | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlCurrency |
| currBuiltInGlDeferred |
| decimal | 10918 | in_curr_builtin_gl_deferred | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_DEFERRED | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlDeferred |
| currBuiltInGlOid |
| decimal | 10919 | in_curr_builtin_gl_oid | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_OID | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlOid |
| currBuiltInGlMktDisc |
| decimal | 10920 | in_curr_builtin_gl_mkt_disc | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_MKT_DISC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlMktDisc |
| gainCurrency |
| decimal | 10049 | in_currency_gain | F | TRADESDBO | TRADE_DETAIL | CURRENCY_GAIN | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/gainCurrency |
| gainSecurityLocal |
| decimal | 10051 | in_security_gain | F | TRADESDBO | TRADE_DETAIL | SECURITY_GAIN | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/gainSecurityLocal |
| totalGain |
| decimal | 10057 | in_total_gain | F | TRADESDBO | TRADE_DETAIL | TOTAL_GAIN | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/totalGain |
| fromAccount |
| string | 351 | in_from_account | S | TRADESDBO | TRADE | FROM_ACCOUNT | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/fromAccount |
| fromAssetid |
| integer | 352 | in_from_sec_alias | F | TRADESDBO | TRADE | FROM_SECURITY_ALIAS | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/fromAssetid |
| fromLongShort |
| string | 355 | in_from_lng_short_ind | S | TRADESDBO | TRADE | FROM_LONG_SHORT_INDICATOR | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/fromLongShort |
| fromSourceSystem |
| string | 361 | in_from_source_system | S | TRADESDBO | TRADE | FROM_SOURCE_SYSTEM | VARCHAR2(25) [v2015R2.x+] |
| EagleML/warehouseTransaction/warehouseTrade/fromSourceSystem |
| VARCHAR2(2) [v12.x or 13.x] |
| fromCostBasisType |
| BasisType | 367 | in_from_cost_basis_type | S | TRADESDBO | TRADE | FROM_COST_BASIS_TYPE | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/fromCostBasisType |
| fromWashSaleEligInd |
| string | 384 | in_from_wash_sale_ind | S | TRADESDBO | TRADE | FROM_WASH_SALE_ELGBL_IND | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/fromWashSaleEligInd |
| lossCurrency |
| decimal | 10052 | in_currency_loss | F | TRADESDBO | TRADE_DETAIL | CURRENCY_LOSS | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/lossCurrency |
| lossSecurityLocal |
| decimal | 10054 | in_security_loss | F | TRADESDBO | TRADE_DETAIL | SECURITY_LOSS | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/lossSecurityLocal |
| totalLoss |
| decimal | 10058 | in_total_loss | F | TRADESDBO | TRADE_DETAIL | TOTAL_LOSS | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/totalLoss |
| originalAcquisitionCostBase |
| decimal | 3746 | in_orig_acq_cost_base | F | TRADESDBO | TRADE | ORIG_ACQ_COST_BASE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostBase |
| originalAcquisitionCostLocal |
| decimal | 3747 | in_orig_acq_cost_local | F | TRADESDBO | TRADE | ORIG_ACQ_COST_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostLocal |
| originalFaceValue |
| decimal | 109 | in_original_face_value | F | TRADESDBO | TRADE | ORIGINAL_FACE_VALUE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalFaceValue |
| originalBuiltInGlMktDisc |
| decimal | 10915 | in_orig_builtin_gl_mkt_disc | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_MKT_DISC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlMktDisc |
| originalTradePrice |
| decimal | 10906 | in_orig_trade_price | F | TRADESDBO | TRADE | ORIG_TRADE_PRICE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalTradePrice |
| originalBuiltInGlCurrency |
| decimal | 10912 | in_orig_builtin_gl_currency | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_CURRENCY | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlCurrency |
| originalBuiltInGlDeferred |
| decimal | 10913 | in_orig_builtin_gl_deferred | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_DEFERRED | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlDeferred |
| originalBuiltInGlOid |
| decimal | 10914 | in_orig_builtin_gl_oid | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_OID | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlOid |
| originalBuiltInGlSecurity |
| decimal | 9762 | in_orig_builtin_gl_sec | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_SEC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlSecurity |
| originalSettlementDate |
| date | 154 | in_orig_settlement_date | S | TRADESDBO | TRADE | ORIG_SETTLEMENT_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/originalSettlementDate |
| originalQuantity |
| decimal | 159 | in_par_or_shares | F | TRADESDBO | TRADE | PAR_OR_SHARES | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/originalQuantity |
|
| decimal | 166 | in_cost_base | F | TRADESDBO | TRADE | COST_BASE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/openCostBase |
| openHldPerDate |
| date | 164 | in_holding_period_date | S | TRADESDBO | TRADE | HOLDING_PERIOD_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/openHldPerDate |
| performanceFlow |
| decimal | 4597 | in_performance_value | F | TRADESDBO | TRADE_DETAIL | PERFORMANCE_VALUE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/performanceFlow |
| performancePrice |
| decimal | 4598 | in_performance_price | F | TRADESDBO | TRADE_DETAIL | PERFORMANCE_PRICE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/performancePrice |
| premiumLAllocated |
| decimal | 203 | in_premium_allocated_local | F | TRADESDBO | TRADE | PREMIUM_ALLOCATED_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/premiumLAllocated |
| premiumBAllocated |
| decimal | 204 | in_premium_allocated | F | TRADESDBO | TRADE | PREMIUM_ALLOCATED | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/premiumBAllocated |
| settlementAmount |
| decimal | 64 | in_settlement_amount | F | TRADESDBO | TRADE | SETTLEMENT_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/settlementAmount |
| toAccount |
| string | 301 | in_to_account | S | TRADESDBO | TRADE | TO_ACCOUNT | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/toAccount |
| toAssetid |
| integer | 302 | in_to_sec_alias | F | TRADESDBO | TRADE | TO_SECURITY_ALIAS | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/toAssetid |
| toLongShort |
| string | 305 | in_to_lng_short_ind | S | TRADESDBO | TRADE | TO_LONG_SHORT_INDICATOR | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/toLongShort |
| toSourceSystem |
| string | 311 | in_to_source_system | S | TRADESDBO | TRADE | TO_SOURCE_SYSTEM | VARCHAR2(25) [v2015R2.x+] |
| EagleML/warehouseTransaction/warehouseTrade/toSourceSystem |
| VARCHAR2(2) [v12.x or 13.x] |
| toCostBasisType |
| BasisType | 317 | in_to_cost_basis_type | S | TRADESDBO | TRADE | TO_COST_BASIS_TYPE | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/toCostBasisType |
| Anchor |
|---|
| toCashEventType |
|---|
| toCashEventType |
|---|
|
toCashEventType |
| string | 328 | in_to_cash_type | S | TRADESDBO | TRADE | TO_CASH_TYPE | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/toCashEventType |
| toWashSaleEligInd |
| string | 334 | in_to_wash_sale_ind | S | TRADESDBO | TRADE | TO_WASH_SALE_ELGBL_IND | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/toWashSaleEligInd |
| userChar1 |
| string | 1887 | in_user_char1 | S | TRADESDBO | TRADE | USER_CHAR1 | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/userChar1 |
| userChar2 |
| string | 1888 | in_user_char2 | S | TRADESDBO | TRADE | USER_CHAR2 | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/userChar2 |
| userChar3 |
| string | 1889 | in_user_char3 | S | TRADESDBO | TRADE | USER_CHAR3 | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/userChar3 |
| userDefinedFloat1 |
| decimal | 1890 | in_user_float1 | F | TRADESDBO | TRADE | USER_FLOAT1 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat1 |
| userDefinedFloat2 |
| decimal | 1891 | in_user_float2 | F | TRADESDBO | TRADE | USER_FLOAT2 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat2 |
| userDefinedFloat3 |
| decimal | 1892 | in_user_float3 | F | TRADESDBO | TRADE | USER_FLOAT3 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat3 |
| costMethod |
| string | 22 | in_cost_method | S | TRADESDBO | TRADE | COST_METHOD | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/costMethod |
| lotSelectionMethod |
| string | 27 | in_lot_selection_method | S | TRADESDBO | TRADE | LOT_SELECTION_METHOD | VARCHAR2(8) |
| EagleML/warehouseTransaction/warehouseTrade/lotSelectionMethod |
| transactionCode |
| string | 2283 | in_trans_code | S | TRADESDBO | TRADE | TRANS_CODE | CHAR(55) |
| EagleML/warehouseTransaction/warehouseTrade/transactionCode |
| factor |
| decimal | 91 | in_factor | F | TRADESDBO | TRADE | FACTOR | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/factor |
| Anchor |
|---|
| netAmountLocal |
|---|
| netAmountLocal |
|---|
|
netAmountLocal |
| decimal | 50 | in_net_cash | F | TRADESDBO | TRADE | NET_CASH | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/netAmountLocal |
| Anchor |
|---|
| netAmountBase |
|---|
| netAmountBase |
|---|
|
netAmountBase |
| decimal | 478 | in_trade_base_amount | F | TRADESDBO | TRADE | TRADE_BASE_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/netAmountBase |
| principalB |
| decimal | 169 | in_principal_base | F | TRADESDBO | TRADE | PRINCIPAL_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/principalB |
| quantityPre |
| decimal | 410 | in_target_quantity | F | TRADESDBO | TRADE | TARGET_QUANTITY | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/quantityPre |
| tradeYield |
| decimal | 9430 | in_trade_yield | F | TRADESDBO | TRADE | TRADE_YIELD | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/tradeYield |
| dirtyPrincipalLocal |
| decimal | 10781 | in_dirty_principal | F | TRADESDBO | TRADE | DIRTY_PRINCIPAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalLocal |
| dirtyPrincipalBase |
| decimal | 10782 | in_dirty_principal_base | F | TRADESDBO | TRADE | DIRTY_PRINCIPAL_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalBase |
| estimateVsFinal |
| string | 768 | in_est_vs_act | S | TRADESDBO | TRADE | EST_VS_ACT | VARCHAR2(3) |
| EagleML/warehouseTransaction/warehouseTrade/estimateVsFinal |
| reportingReplayInd |
| string | 10674 | in_replay_ind | S | TRADESDBO | TRADE | REPLAY_IND | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/reportingReplayInd |
| cashEventType |
| string | 53 | in_cash_type | S | TRADESDBO | TRADE_DETAIL | CASH_TYPE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/cashEventType |
| transactionNotes |
| string | 56 | in_transaction_notes | S | TRADESDBO | TRADE_DETAIL | TRANSACTION_NOTES | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/transactionNotes |
| partflag |
| string | 3924 | in_partflag | S | TRADESDBO | TRADE_DETAIL | PARTFLAG | CHAR(1) |
| EagleML/warehouseTransaction/warehouseTrade/partflag |
| scrubType |
| string | 3717 | in_scrub_type | S | TRADESDBO | TRADE | SCRUB_TYPE | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/scrubType |
| glAccount |
| string | 4519 | in_general_ledger_acct | S | TRADESDBO | TRADE_DETAIL | GENERAL_LEDGER_ACCT | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/glAccount |
| custodianBank |
| string | 1146 | in_custody_bank_desc | S | TRADESDBO | TRADE | CUSTODY_BANK_DESC |
|
| EagleML/warehouseTransaction/warehouseTrade/custodianBank |
| custodianBankCode |
| string | 1240 | in_custody_bank_code | S | TRADESDBO | TRADE | CUSTODY_BANK_CODE | CHAR(20) |
| EagleML/warehouseTransaction/warehouseTrade/custodianBankCode |
| custodyBankAccountNum |
| string | 1660 | in_custody_bank_acct_num | S | TRADESDBO | TRADE | CUSTODY_BANK_ACCT_NUM | VARCHAR2(15) |
| EagleML/warehouseTransaction/warehouseTrade/custodyBankAccountNum |
| custodyBankSubAccount |
| string | 1661 | in_custody_bank_sub_acct | S | TRADESDBO | TRADE | CUSTODY_BANK_SUB_ACCT | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/custodyBankSubAccount |
| corporateActionType |
| string | 1728 | in_corp_action_type | S | TRADESDBO | TRADE | CORP_ACTION_TYPE | VARCHAR2(55) |
| EagleML/warehouseTransaction/warehouseTrade/corporateActionType |
| cashEventSpawned |
| string | 751 | in_cash_event_spawned | S | TRADESDBO | TRADE | CASH_EVENT_SPAWNED | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/cashEventSpawned |
| bankAlias |
| integer | 1864 | in_bank_alias | S | TRADESDBO | TRADE | BANK_ALIAS | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/bankAlias |
| changedflag |
| string | 10705 | in_changedflag | S | TRADESDBO | TRADE_DETAIL | CHANGEDFLAG | CHAR(1) |
| EagleML/warehouseTransaction/warehouseTrade/changedflag |
| eventId |
| TransactionId | 25 | in_star_tag25 | S | TRADESDBO | TRADE | STAR_TAG25 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/eventId |
| corporateActionInstance |
| integer | 4268 | in_corporate_action_inst | S | TRADESDBO | TRADE_DETAIL | CORPORATE_ACTION_INST | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/corporateActionInstance |
| eventIdSwitch |
| TransactionId |
|
|
| TRADESDBO | TRADE | TRANSACTION_ID |
|
| EagleML/warehouseTransaction/warehouseTrade/eventIdSwitch |
| sellToBuyFXRate |
| decimal | 7 | in_sell_to_buy_fx_rate | F | TRADESDBO | TRADE | SELL_TO_BUY_FX_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/sellToBuyFXRate |
| lotNumber |
| string | 3710 | in_lot_number | S | TRADESDBO | TRADE | LOT_NUMBER | CHAR(8) | Y | EagleML/warehouseTransaction/warehouseTrade/lotNumber |
| masterTicketNumber | Required | string | 761 | in_master_ticket_number | S | TRADESDBO | TRADE | MASTER_TICKET_NUMBER | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/masterTicketNumber |
| tradeXrefIdentifier |
| TradeXrefIdentifier |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehouseTrade/ |
| acqTransNumber |
| integer | 12251 | in_acq_tnum | F | TRADESDBO | TRADE_DETAIL | ACQ_TNUM | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/acqTransNumber |
| postType |
| string | 12197 | in_post_type | S | TRADESDBO | TRADE_DETAIL | POST_TYPE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/postType |
| tradeMemo1 |
|
| 12236 | in_trade_memo1 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO1 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tradeMemo1 |
| tradeMemo2 |
| string | 12237 | in_trade_memo2 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO2 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tradeMemo2 |
| fxRate |
| decimal | 87 | in_fx_rate | F | TRADESDBO | TRADE | FX_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/fxRate |
| checkedDate |
| dateTime | 12141 | in_checkeddate | S | TRADESDBO | TRADE_DETAIL | CHECKEDDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/checkedDate |
| accountingDesignation |
| string | 7208 | in_acct_desig | S | TRADESDBO | TRADE_DETAIL_EXT | ACCT_DESIG | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/accountingDesignation |
| brokerReason |
| string | 7209 | in_broker_reason | S | TRADESDBO | TRADE_DETAIL_EXT | BROKER_REASON | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/brokerReason |
| instructedDate |
| dateTime | 12143 | in_instructeddate | S | TRADESDBO | TRADE_DETAIL | INSTRUCTEDDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/instructedDate |
| dispInterestReceived |
| decimal | 12318 | in_disp_interest_received | F | TRADESDBO | TRADE_DETAIL | DISP_INTEREST_RECEIVED | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/dispInterestReceived |
| userWhoApprovedTrade |
| string | 12262 | in_user_who_approved_trade | S | TRADESDBO | TRADE_DETAIL | USER_WHO_APPROVED_TRADE | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/userWhoApprovedTrade |
| otherFundNumber |
| string | 7211 | in_oth_fund_invnum | S | TRADESDBO | TRADE_DETAIL_EXT | OTH_FUND_INVNUM | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/otherFundNumber |
| prepaySpeed |
| decimal | 12200 | in_prepay_speed | F | TRADESDBO | TRADE_DETAIL | PREPAY_SPEED_CONTRACT_SIZE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/prepaySpeed |
| TRADESDBO | TRADE_DETAIL_EXT | PREPAY_SPEED | NUMBER(38,12) |
|
| prepayType |
| string | 7212 | in_prepay_type | S | TRADESDBO | TRADE_DETAIL_EXT | PREPAY_TYPE | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/prepayType |
| settlementExchangeRate |
| decimal | 79 | in_settlement_exchange_rate | F | TRADESDBO | TRADE | SETTLEMENT_EXCHANGE_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/settlementExchangeRate |
| touchCount |
| integer | 13688 | in_transeq | F | TRADESDBO | TRADE_DETAIL | TRANSEQ | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/touchCount |
| secTranType |
| string | 7220 | in_tran_type | S | TRADESDBO | TRADE_DETAIL_EXT | TRAN_TYPE | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/secTranType |
| authorizedDate |
| dateTime | 12137 | in_authorizeddate | S | TRADESDBO | TRADE_DETAIL | AUTHORIZEDDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/authorizedDate |
| localCommissionAmount |
| decimal | 47 | in_local_commission_amount | F | TRADESDBO | TRADE | LOCAL_COMMISSION_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/localCommissionAmount |
| salesPerson |
| string | 12098 | in_sales_person | S | TRADESDBO | TRADE | SALES_PERSON | CHAR(18) |
| EagleML/warehouseTransaction/warehouseTrade/salesPerson |
| convexity |
| decimal | 7965 | in_convexity | F | TRADESDBO | TRADE_DETAIL_EXT | CONVEXITY | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/convexity |
| broker |
| string | 12126 | in_broker | S | TRADESDBO | TRADE_DETAIL | BROKER | CHAR(50) |
| EagleML/warehouseTransaction/warehouseTrade/broker |
| settlementCurrency |
| string | 63 | in_settlement_currency | S | TRADESDBO | TRADE | SETTLEMENT_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/settlementCurrency |
| discountRate |
| decimal | 12039 | in_discount_rate | F | TRADESDBO | TRADE | DISCOUNT_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/discountRate |
| duration |
| decimal | 7966 | in_duration | F | TRADESDBO | TRADE_DETAIL_EXT | DURATION | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/duration |
| comments1 |
| string | 12133 | in_comments1 | S | TRADESDBO | TRADE_DETAIL | COMMENTS1 | CHAR(30) |
| EagleML/warehouseTransaction/warehouseTrade/comments1 |
| modifiedBy |
| string | 7213 | in_modified_by | S | TRADESDBO | TRADE_DETAIL_EXT | MODIFIED_BY | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/modifiedBy |
| price |
| decimal | 160 | in_price | F | TRADESDBO | TRADE | PRICE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/price |
| pricingIndex |
| string | 7214 | in_prc_index | S | TRADESDBO | TRADE_DETAIL_EXT | PRC_INDEX | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/pricingIndex |
| pricingSpread |
| decimal | 7967 | in_prc_spread |
| TRADESDBO | TRADE_DETAIL_EXT | PRC_SPREAD | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/pricingSpread |
| principal |
| decimal | 165 | in_tdprincipal | F | TRADESDBO | TRADE | PRINCIPAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/principal |
| comments |
| string | 12132 | in_comments | S | TRADESDBO | TRADE_DETAIL | COMMENTS | CHAR(30) |
| EagleML/warehouseTransaction/warehouseTrade/comments |
| prepared |
| string | 12199 | in_prepared | S | TRADESDBO | TRADE_DETAIL | PREPARED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/prepared |
| preparedDate |
| dateTime | 12194 | in_prepareddate | S | TRADESDBO | TRADE_DETAIL | PREPAREDDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/preparedDate |
| settlementLocation |
| string | 43 | in_settlement_location | S | TRADESDBO | TRADE | SETTLEMENT_LOCATION | CHAR(12) |
| EagleML/warehouseTransaction/warehouseTrade/settlementLocation |
| trader |
| string | 12115 | in_trader | S | TRADESDBO | TRADE | TRADER | CHAR(30) |
| EagleML/warehouseTransaction/warehouseTrade/trader |
| yield |
| decimal | 75 | in_yield | F | TRADESDBO | TRADE | YIELD | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/yield |
| blockTradeId |
| string | 7215 | in_block_trade_id | S | TRADESDBO | TRADE_DETAIL_EXT | BLOCK_TRADE_ID | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/blockTradeId |
| fromQuantity |
| decimal | 366 | in_from_quantity | F | TRADESDBO | TRADE | FROM_QUANTITY | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/fromQuantity |
| sellToBaseFxRate |
| decimal | 12149 | in_sell_to_base_fx_rate | F | TRADESDBO | TRADE | SELL_TO_BASE_FX_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/sellToBaseFxRate |
| toQuantity |
| decimal | 316 | in_to_quantity | F | TRADESDBO | TRADE | TO_QUANTITY | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/toQuantity |
| toAmountLocal |
| decimal | 327 | in_to_amount_local | F | TRADESDBO | TRADE | TO_AMOUNT_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/toAmountLocal |
|
| string | 328 | in_to_cash_type | S | TRADESDBO | TRADE | TO_CASH_TYPE | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/toCashType |
| fromAmountLocal |
| decimal | 377 | in_from_amount_local | F | TRADESDBO | TRADE | FROM_AMOUNT_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/fromAmountLocal |
| fromCashType |
| string | 378 | in_from_cash_type | S | TRADESDBO | TRADE | FROM_CASH_TYPE | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/fromCashType |
| novationType |
| string | 7216 | in_novation_type |
| TRADESDBO | TRADE_DETAIL_EXT | NOVATION_TYPE | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/novationType |
| derivTranType |
| string | 7217 | in_tran_type_deriv | S | TRADESDBO | TRADE_DETAIL_EXT | TRAN_TYPE_DERIV | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/derivTranType |
| currentWAL |
| decimal | 7968 | in_wal | F | TRADESDBO | TRADE_DETAIL_EXT | WAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currentWAL |
| purchaseType |
| string | 7218 | in_purchase_type | S | TRADESDBO | TRADE_DETAIL_EXT | PURCHASE_TYPE | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/purchaseType |
| embeddedDerivPrice |
| decimal | 7969 | in_ed_prc | F | TRADESDBO | TRADE_DETAIL_EXT | ED_PRC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/embeddedDerivPrice |
| assetLiabilityHedgeFlag |
| string | 7219 | in_al_hedge_flag | S | TRADESDBO | TRADE_DETAIL_EXT | AL_HEDGE_FlAG | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/assetLiabilityHedgeFlag |
| currentWAC |
| decimal | 7970 | in_wac | F | TRADESDBO | TRADE_DETAIL_EXT | WAC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currentWAC |
| currentWAM |
| decimal | 7971 | in_wam | F | TRADESDBO | TRADE_DETAIL_EXT | WAM | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/currentWAM |
| hedgeTaxStatus |
| string | 7188 | in_hedge_tax_status | S | TRADESDBO | TRADE_DETAIL_EXT | HEDGE_TAX_STATUS | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/hedgeTaxStatus |
| hedgeDesigCds |
| string | 7189 | in_hedge_desig_cds | S | TRADESDBO | TRADE_DETAIL_EXT | HEDGE_DESIG_CDS | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/hedgeDesigCds |
| settlementInstructions1 |
| string | 1897 | in_settlement_instructions1 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS1 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settlementInstructions1 |
| settlementInstructions2 |
| string | 12224 | in_settlement_instructions2 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS2 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settlementInstructions2 |
| settlementInstructions3 |
| string | 12225 | in_settlement_instructions3 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS3 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settlementInstructions3 |
| settlementInstructions4 |
| string | 12227 | in_settlement_instructions4 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS4 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settlementInstructions4 |
| strategy |
| string | 2514 | in_strategy_id | S | TRADESDBO | TRADE | STRATEGY_ID | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/strategy |
| TRADESDBO | TRADE_DETAIL_EXT | STRATEGY |
|
|
| executionType |
| string | 7210 | in_exec_type | S | TRADESDBO | TRADE_DETAIL_EXT | EXEC_TYPE | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/executionType |
| origEntryDate |
| date | 7207 | in_orig_entry_date | S | TRADESDBO | TRADE_DETAIL_EXT | ORIG_ENTRY_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/origEntryDate |
| settlementDate |
| date | 37 | in_settlement_date | S | TRADESDBO | TRADE | SETTLEMENT_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/settlementDate |
| fxPayCurrency |
| CurrencyCode |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehouseTrade/fxPayCurrency |
| tradeExchangeRate |
| decimal | 12163 | in_trade_exchange_rate | F | TRADESDBO | TRADE | TRADE_EXCHANGE_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/tradeExchangeRate |
| fxRcvCurrency |
| CurrencyCode |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehouseTrade/fxRcvCurrency |
| postDate |
| date | 30 | in_post_date | S | TRADESDBO | TRADE | POST_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/postDate |
| conterpartyCode |
| string |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehouseTrade/conterpartyCode |
| tradeCoupon |
| decimal | 7961 | in_trd_coupon |
| TRADESDBO | TRADE_DETAIL_EXT | TRD_COUPON | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/tradeCoupon |
| factorDate |
| date | 7187 | in_trade_factor_date | S | TRADESDBO | TRADE_DETAIL_EXT | TRADE_FACTOR_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/factorDate |
| Anchor |
|---|
| longShortIndicator |
|---|
| longShortIndicator |
|---|
|
longShortIndicator |
| LongShortIndicatorEnum |
| in_star_ls_ind |
| TRADESDBO | TRADE_DETAIL | LONG_SHORT_INDICATOR | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/longShortIndicator |
| custodianBankDesc |
| string | 1146 | in_custody_bank_desc | S | TRADESDBO | TRADE | CUSTODY_BANK_DESC | CHAR(50) |
| EagleML/warehouseTransaction/warehouseTrade/custodianBankDesc |
| Anchor |
|---|
| openCostLocal |
|---|
| openCostLocal |
|---|
|
openCostLocal |
| decimal | 162 | in_cost_local | F | TRADESDBO | TRADE | COST_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/openCostLocal |
| tradeAmount |
| decimal | 190 | in_trade_amount | F | TRADESDBO | TRADE | TRADE_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/tradeAmount |
| smInactiveFlag |
| YesNoOptionEnum | 11043 | in_sm_inactive_flag | S | not stored in DB, used for resolution logic |
|
| EagleML/warehouseTransaction/warehouseTrade/smInactiveFlag |
| clientId |
| string | 1632 | in_client_id | S | TRADESDBO | TRADE | CLIENT_ID | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/clientId |
| covFlag |
| YesNoOptionEnum | 12135 | in_cov_flag | S | TRADESDBO | TRADE_DETAIL | COV_FLAG | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/covFlag |
| eventSubPriority |
| integer | 12042 | in_event_sub_priority | F | TRADESDBO | TRADE | EVENT_SUB_PRIORITY | NUMBER(38) |
| EagleML/warehouseTransaction/warehouseTrade/eventSubPriority |
| ioIssuerAlias |
| string | 12183 | in_io_issuer_alias | S | TRADESDBO | TRADE_DETAIL | IO_ISSUER_ALIAS | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/ioIssuerAlias |
| ioIssuerId |
| string | 12184 | in_io_issuer_id | S | TRADESDBO | TRADE_DETAIL | IO_ISSUER_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/ioIssuerId |
| origAcctDate |
| date | 12036 | in_orig_acct_date | S | TRADESDBO | TRADE | ORIG_ACCT_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/origAcctDate |
| origMonthlyAcctDate |
| date | 12102 | in_orig_monthly_acct_date | S | TRADESDBO | TRADE | ORIG_MONTHLY_ACCT_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/origMonthlyAcctDate |
| pendingTradeId |
| integer | 12088 | in_pending_trade_id | F | TRADESDBO | TRADE | PENDING_TRADE_ID | NUMBER(38) |
| EagleML/warehouseTransaction/warehouseTrade/pendingTradeId |
| qtyWashSaleEligible |
| decimal | 12111 | in_qty_wash_sale_eligible | F | TRADESDBO | TRADE | QTY_WASH_SALE_ELIGIBLE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/qtyWashSaleEligible |
| washSaleEligibleInd |
| string | 12120 | in_wash_sale_eligible_indicator | S | TRADESDBO | TRADE | WASH_SALE_ELIGIBLE_INDICATOR | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/washSaleEligibleInd |
| aiaNetB |
| decimal | 12252 | in_aia_net_b | F | TRADESDBO | TRADE_DETAIL | AIA_NET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/aiaNetB |
| aiaNetL |
| decimal | 12253 | in_aia_net_l | F | TRADESDBO | TRADE_DETAIL | AIA_NET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/aiaNetL |
| buySellFlag |
| normalizedString | 12006 | in_buy_sell_flag | S | TRADESDBO | TRADE | BUY_SELL_FLAG | CHAR(4) |
| EagleML/warehouseTransaction/warehouseTrade/buySellFlag |
| bookValue |
| decimal | 4602 | in_book_value | F | TRADESDBO | TRADE_DETAIL | BOOK_VALUE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/bookValue |
| bookValueLocal |
| decimal | 4601 | in_book_value_local | F | TRADESDBO | TRADE_DETAIL | BOOK_VALUE_LOCAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/bookValueLocal |
| cpNetB |
| decimal | 12306 | in_cp_net_b | F | TRADESDBO | TRADE_DETAIL | CP_NET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/cpNetB |
| cpNetL |
| decimal | 12307 | in_cp_net_l | F | TRADESDBO | TRADE_DETAIL | CP_NET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/cpNetL |
| creditLossB |
| decimal | 12308 | in_credit_loss_b | F | TRADESDBO | TRADE_DETAIL | CREDIT_LOSS_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/creditLossB |
| creditLossL |
| decimal | 12310 | in_credit_loss_l | F | TRADESDBO | TRADE_DETAIL | CREDIT_LOSS_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/creditLossL |
| costBasisType |
| string | 24 | in_cost_basis_type | S | TRADESDBO | TRADE | COST_BASIS_TYPE | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/costBasisType |
| futureFeeNetB |
| decimal | 12352 | in_future_fee_net_b | F | TRADESDBO | TRADE_DETAIL | FUTURE_FEE_NET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/futureFeeNetB |
| futureFeeNetL |
| decimal | 12356 | in_future_fee_net_l | F | TRADESDBO | TRADE_DETAIL | FUTURE_FEE_NET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/futureFeeNetL |
| impairmentLtdBase |
| decimal | 13035 | in_impairment_ltd_base | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_LTD_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentLtdBase |
| impairmentLtdLocal |
| decimal | 13036 | in_impairment_ltd_local | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_LTD_LOCAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocal |
| mbaNetB |
| decimal | 13656 | in_mba_net_b | F | TRADESDBO | TRADE_DETAIL | MBA_NET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/mbaNetB |
| mbaNetL |
| decimal | 13657 | in_mba_net_l | F | TRADESDBO | TRADE_DETAIL | MBA_NET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/mbaNetL |
| naiaNetB |
| decimal | 13658 | in_naia_net_b | F | TRADESDBO | TRADE_DETAIL | NAIA_NET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/naiaNetB |
| naiaNetL |
| decimal | 13659 | in_naia_net_l | F | TRADESDBO | TRADE_DETAIL | NAIA_NET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/naiaNetL |
| nonCreditLossB |
| decimal | 13661 | in_non_credit_loss_b | F | TRADESDBO | TRADE_DETAIL | NON_CREDIT_LOSS_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/nonCreditLossB |
| nonCreditLossL |
| decimal | 13662 | in_non_credit_loss_l | F | TRADESDBO | TRADE_DETAIL | NON_CREDIT_LOSS_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/nonCreditLossL |
| bookCost |
| decimal | 12285 | in_book_cost | F | TRADESDBO | TRADE_DETAIL | BOOK_COST | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/bookCost |
| cashCategory |
| string | 12128 | in_cash_category | S | TRADESDBO | TRADE_DETAIL | CASH_CATEGORY | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/cashCategory |
| cancelType |
| string | 12127 | in_cancel_type | S | TRADESDBO | TRADE_DETAIL | CANCEL_TYPE | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/cancelType |
| exchangeFeeBase |
| decimal | 13970 | in_exchange_fee_base | F | TRADESDBO | TRADE | EXCHANGE_FEE_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/exchangeFeeBase |
| federalTaxWithholdBase |
| decimal | 13969 | in_federal_tax_withhold_base | F | TRADESDBO | TRADE | FEDERAL_TAX_WITHHOLD_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/federalTaxWithholdBase |
| mttype |
| string | 13280 | in_mttype | S | TRADESDBO | TRADE | MTTYPE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/mttype |
|
| decimal | 50 | in_net_cash | F | TRADESDBO | TRADE | NET_CASH | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/netCash |
| origAcqDate |
| date | 216 | in_orig_acq_date | S | TRADESDBO | TRADE | ORIG_ACQ_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/origAcqDate |
| positionId |
| integer | 12092 | in_position_id | F | TRADESDBO | TRADE | POSITION_ID | NUMBER(38) |
| EagleML/warehouseTransaction/warehouseTrade/positionId |
| scrubId |
| integer | 12147 | in_scrub_id | F | TRADESDBO | TRADE | SCRUB_ID | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/scrubId |
| secFeesBase |
| decimal | 12148 | in_sec_fees_base | F | TRADESDBO | TRADE | SEC_FEES_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/secFeesBase |
| termLoanFeeExpB |
| decimal | 12155 | in_term_loan_fee_exp_b | F | TRADESDBO | TRADE | TERM_LOAN_FEE_EXP_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpB |
| termLoanFeeExpL |
| decimal | 12156 | in_term_loan_fee_exp_l | F | TRADESDBO | TRADE | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpL |
| termLoanFeeIncB |
| decimal | 12157 | in_term_loan_fee_inc_b | F | TRADESDBO | TRADE | TERM_LOAN_FEE_INC_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncB |
| termLoanFeeIncL |
| decimal | 12158 | in_term_loan_fee_inc_l | F | TRADESDBO | TRADE | TERM_LOAN_FEE_INC_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncL |
| targetEventId |
| TransactionId | 26 | in_target_event_id | S | TRADESDBO | TRADE | TARGET_EVENT_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/targetEventId |
| updateUserId |
| string | 12119 | in_update_user_id | S | TRADESDBO | TRADE | UPDATE_USER_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/updateUserId |
| updateSwitch |
| string | 1076 | in_update_switch |
| not stored in DB |
|
| EagleML/warehouseTransaction/warehouseTrade/updateSwitch |
| accruedInterestOverride |
| string | 12121 | in_accrued_interest_override | S | TRADESDBO | TRADE_DETAIL | ACCRUED_INTEREST_OVERRIDE | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/accruedInterestOverride |
| acquisitionType |
| string | 12122 | in_acquisition_type | S | TRADESDBO | TRADE_DETAIL | ACQUISITION_TYPE | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/acquisitionType |
| amortizedCostPrevBase |
| decimal | 12255 | in_amortized_cost_prev_b | F | TRADESDBO | TRADE_DETAIL | AMORTIZED_COST_PREV_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevBase |
| amortizedCostPrevLocal |
| decimal | 12278 | in_amortized_cost_prev_l | F | TRADESDBO | TRADE_DETAIL | AMORTIZED_COST_PREV_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevLocal |
| alluprate |
| decimal | 12254 | in_alluprate | F | TRADESDBO | TRADE_DETAIL | ALLUPRATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/alluprate |
| asOfTradeTime |
| string | 12123 | in_as_of_trade_time | S | TRADESDBO | TRADE_DETAIL | AS_OF_TRADE_TIME | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/asOfTradeTime |
| authorized |
| string | 12124 | in_authorized | S | TRADESDBO | TRADE_DETAIL | AUTHORIZED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/authorized |
| autoexTradeFlag |
| YesNoOptionEnum | 12125 | in_autoex_trade_flag | S | TRADESDBO | TRADE_DETAIL | AUTOEX_TRADE_FLAG | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/autoexTradeFlag |
| baseCommissionAmount |
| decimal | 12009 | in_base_commission_amount | F | TRADESDBO | TRADE | BASE_COMMISSION_AMOUNT | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/baseCommissionAmount |
| batchInstance |
| integer | 126 | in_batch_instance | S | TRADESDBO | TRADE | BATCH_INSTANCE | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/batchInstance |
| balance |
| decimal | 12279 | in_balance | F | TRADESDBO | TRADE_DETAIL | BALANCE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/balance |
| bnchYld1 |
| decimal | 12280 | in_bnch_yld1 | F | TRADESDBO | TRADE_DETAIL | BNCH_YLD1 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/bnchYld1 |
| bnchYld2 |
| decimal | 12281 | in_bnch_yld2 | F | TRADESDBO | TRADE_DETAIL | BNCH_YLD2 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/bnchYld2 |
| bloombergProduct |
| string | 12008 | in_bloomberg_product | S | TRADESDBO | TRADE | BLOOMBERG_PRODUCT | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/bloombergProduct |
| buyToBaseFxRate |
| decimal | 12014 | in_buy_to_base_fx_rate | F | TRADESDBO | TRADE | BUY_TO_BASE_FX_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/buyToBaseFxRate |
| calcYieldIntIndicator |
| integer | 12015 | in_calc_yield_int_indicator | F | TRADESDBO | TRADE | CALC_YIELD_INT_INDICATOR | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/calcYieldIntIndicator |
| cancelDueToCorrection |
| string | 12021 | in_cancel_due_to_correction | S | TRADESDBO | TRADE | CANCEL_DUE_TO_CORRECTION | CHAR(4) |
| EagleML/warehouseTransaction/warehouseTrade/cancelDueToCorrection |
| cashflowdate |
| date | 12140 | in_cashflowdate | S | TRADESDBO | TRADE_DETAIL | CASHFLOWDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/cashflowdate |
| checked |
| string | 12129 | in_checked | S | TRADESDBO | TRADE_DETAIL | CHECKED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/checked |
| clearingBroker |
| string | 12130 | in_clearing_broker | S | TRADESDBO | TRADE_DETAIL | CLEARING_BROKER | CHAR(50) |
| EagleML/warehouseTransaction/warehouseTrade/clearingBroker |
| closeoutpl0 |
| decimal | 12288 | in_closeoutpl0 | F | TRADESDBO | TRADE_DETAIL | CLOSEOUTPL0 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/closeoutpl0 |
| closeoutpl1 |
| decimal | 12292 | in_closeoutpl1 | F | TRADESDBO | TRADE_DETAIL | CLOSEOUTPL1 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/closeoutpl1 |
| commentType |
| string | 12131 | in_comment_type | S | TRADESDBO | TRADE_DETAIL | COMMENT_TYPE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/commentType |
| compared |
| string | 12134 | in_compared | S | TRADESDBO | TRADE_DETAIL | COMPARED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/compared |
| compareddate |
| date | 12142 | in_compareddate | S | TRADESDBO | TRADE_DETAIL | COMPAREDDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/compareddate |
| costPrevBase |
| decimal | 12295 | in_cost_prev_base | F | TRADESDBO | TRADE_DETAIL | COST_PREV_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/costPrevBase |
| costPrevLocal |
| decimal | 12296 | in_cost_prev_local | F | TRADESDBO | TRADE_DETAIL | COST_PREV_LOCAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/costPrevLocal |
| cleanPrice |
| decimal | 12018 | in_clean_price | F | TRADESDBO | TRADE | CLEAN_PRICE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/cleanPrice |
| commissionCode |
| string | 12023 | in_commission_code | S | TRADESDBO | TRADE | COMMISSION_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/commissionCode |
| commissionReasonCode |
| string | 12024 | in_commission_reason_code | S | TRADESDBO | TRADE | COMMISSION_REASON_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/commissionReasonCode |
| commissionTypeCode |
| string | 78 | in_commission_type_code | S | TRADESDBO | TRADE | COMMISSION_TYPE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/commissionTypeCode |
| customerAcctNumb |
| string | 12025 | in_customer_acct_numb | S | TRADESDBO | TRADE | CUSTOMER_ACCT_NUMB | CHAR(30) |
| EagleML/warehouseTransaction/warehouseTrade/customerAcctNumb |
| dispBookValueGaap |
| decimal | 3766 | in_disp_book_value_gaap | F | TRADESDBO | TRADE_DETAIL | DISP_BOOK_VALUE_GAAP | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/dispBookValueGaap |
| dispBookValueStat |
| decimal | 3767 | in_disp_book_value_stat | F | TRADESDBO | TRADE_DETAIL | DISP_BOOK_VALUE_STAT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/dispBookValueStat |
| disallowGainB |
| decimal | 12311 | in_disallow_gain_b | F | TRADESDBO | TRADE_DETAIL | DISALLOW_GAIN_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/disallowGainB |
| disallowGainL |
| decimal | 12312 | in_disallow_gain_l | F | TRADESDBO | TRADE_DETAIL | DISALLOW_GAIN_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/disallowGainL |
| disallowLossB |
| decimal | 12314 | in_disallow_loss_b | F | TRADESDBO | TRADE_DETAIL | DISALLOW_LOSS_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/disallowLossB |
| disallowLossL |
| decimal | 12315 | in_disallow_loss_l | F | TRADESDBO | TRADE_DETAIL | DISALLOW_LOSS_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/disallowLossL |
| dispAccruedIncome |
| decimal | 12316 | in_disp_accrued_income | F | TRADESDBO | TRADE_DETAIL | DISP_ACCRUED_INCOME | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/dispAccruedIncome |
| electedShareAmt |
| decimal | 12326 | in_elected_share_amt | F | TRADESDBO | TRADE_DETAIL | ELECTED_SHARE_AMT | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/electedShareAmt |
| electedSharePerc |
| decimal | 12328 | in_elected_share_perc | F | TRADESDBO | TRADE_DETAIL | ELECTED_SHARE_PERC | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/electedSharePerc |
| exchangeCodeTrd |
| string | 12176 | in_exchange_code_trd | S | TRADESDBO | TRADE_DETAIL | EXCHANGE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/exchangeCodeTrd |
| exchangeCurrency |
| string | 12177 | in_exchange_currency | S | TRADESDBO | TRADE_DETAIL | EXCHANGE_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/exchangeCurrency |
| exchangeTypeCode |
| string | 12178 | in_exchange_type_code | S | TRADESDBO | TRADE_DETAIL | EXCHANGE_TYPE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/exchangeTypeCode |
| exchangeCode |
| string | 17 | in_exchange_code | S | TRADESDBO | TRADE | EXCHANGE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/exchangeCode |
| exchangeFee |
| decimal | 48 | in_exchange_fee | F | TRADESDBO | TRADE | EXCHANGE_FEE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/exchangeFee |
| fairMarketValueBase |
| decimal | 12337 | in_fair_market_value_base | F | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/fairMarketValueBase |
| fairMarketValueFlag |
| string | 12179 | in_fair_market_value_flag | S | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_FLAG | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/fairMarketValueFlag |
| fairMarketValueLocal |
| decimal | 12342 | in_fair_market_value_local | F | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_LOCAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/fairMarketValueLocal |
| fairMarketValuePrice |
| decimal | 12343 | in_fair_market_value_price | F | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_PRICE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/fairMarketValuePrice |
| feeamt |
| decimal | 12344 | in_feeamt | F | TRADESDBO | TRADE_DETAIL | FEEAMT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/feeamt |
| feerate |
| decimal | 12351 | in_feerate | F | TRADESDBO | TRADE_DETAIL | FEERATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/feerate |
| fromEffectiveDate |
| date | 12005 | in_from_effective_date | S | TRADESDBO | TRADE | FROM_EFFECTIVE_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/fromEffectiveDate |
| fwdCleanPrice |
| decimal | 13968 | in_fwd_clean_price | F | TRADESDBO | TRADE | FWD_CLEAN_PRICE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/fwdCleanPrice |
| gaapRealizedGl |
| decimal | 12358 | in_gaap_realized_gl | F | TRADESDBO | TRADE_DETAIL | GAAP_REALIZED_GL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/gaapRealizedGl |
| gaapSecType |
| string | 12180 | in_gaap_sec_type | S | TRADESDBO | TRADE_DETAIL | GAAP_SEC_TYPE | CHAR(4) |
| EagleML/warehouseTransaction/warehouseTrade/gaapSecType |
| goodMillionNum |
| integer | 12361 | in_good_million_num | F | TRADESDBO | TRADE_DETAIL | GOOD_MILLION_NUM | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/goodMillionNum |
| haircutFlag |
| YesNoOptionEnum | 12071 | in_haircut_flag | S | TRADESDBO | TRADE | HAIRCUT_FLAG | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/haircutFlag |
| haircutPct |
| decimal | 13967 | in_haircut_pct | F | TRADESDBO | TRADE | HAIRCUT_PCT | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/haircutPct |
| holdTradeStatus |
| string | 12072 | in_hold_trade_status | S | TRADESDBO | TRADE | HOLD_TRADE_STATUS | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/holdTradeStatus |
| identifier2 |
| string | 12181 | in_identifier2 | S | TRADESDBO | TRADE_DETAIL | IDENTIFIER2 | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/identifier2 |
| impairmentAmortOffsetB |
| decimal | 12362 | in_impairment_amort_offset_b | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_AMORT_OFFSET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetB |
| impairmentAmortOffsetL |
| decimal | 12363 | in_impairment_amort_offset_l | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_AMORT_OFFSET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetL |
| impairmentCostOffsetB |
| decimal | 12368 | in_impairment_cost_offset_b | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_OFFSET_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetB |
| impairmentCostOffsetL |
| decimal | 12370 | in_impairment_cost_offset_l | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_OFFSET_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetL |
| impairmentCostPrevB |
| decimal | 12383 | in_impairment_cost_prev_b | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_PREV_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevB |
| impairmentCostPrevL |
| decimal | 12384 | in_impairment_cost_prev_l | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_PREV_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevL |
| inceptionamt |
| decimal | 13651 | in_inceptionamt | F | TRADESDBO | TRADE_DETAIL | INCEPTIONAMT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/inceptionamt |
| instructed |
| string | 12182 | in_instructed | S | TRADESDBO | TRADE_DETAIL | INSTRUCTED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/instructed |
| interest |
| decimal | 13652 | in_interest | F | TRADESDBO | TRADE_DETAIL | INTEREST | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/interest |
| invertFlag |
| YesNoOptionEnum | 12073 | in_invert_flag | S | TRADESDBO | TRADE | INVERT_FLAG | CHAR(4) |
| EagleML/warehouseTransaction/warehouseTrade/invertFlag |
| interestadj |
| decimal | 13653 | in_interestadj | F | TRADESDBO | TRADE_DETAIL | INTERESTADJ | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/interestadj |
| interestAdjBase |
| decimal | 475 | in_baseinterestadj | F | TRADESDBO | TRADE_DETAIL | BASEINTERESTADJ | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/interestAdjBase |
| ledgerEffectiveDate |
| date | 36 | in_ledger_effective_date | S | TRADESDBO | TRADE | LEDGER_EFFECTIVE_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/ledgerEffectiveDate |
| ledgerDate |
| date | 12144 | in_ledger_date | S | TRADESDBO | TRADE_DETAIL | LEDGER_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/ledgerDate |
| letterconfirm |
| string | 12185 | in_letterconfirm | S | TRADESDBO | TRADE_DETAIL | LETTERCONFIRM | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/letterconfirm |
| lettered |
| string | 12186 | in_lettered | S | TRADESDBO | TRADE_DETAIL | LETTERED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/lettered |
| lettereddate |
| date | 12145 | in_lettereddate | S | TRADESDBO | TRADE_DETAIL | LETTEREDDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/lettereddate |
| lmtGlElg |
| string | 12187 | in_lmt_gl_elg | S | TRADESDBO | TRADE_DETAIL | LMT_GL_ELG | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/lmtGlElg |
| lmtGlInd |
| string | 12188 | in_lmt_gl_ind | S | TRADESDBO | TRADE_DETAIL | LMT_GL_IND | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/lmtGlInd |
| margin |
| decimal | 13654 | in_margin | F | TRADESDBO | TRADE_DETAIL | MARGIN | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/margin |
| marginpoints |
| decimal | 13655 | in_marginpoints | F | TRADESDBO | TRADE_DETAIL | MARGINPOINTS | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/marginpoints |
| mortgageFlag |
| YesNoOptionEnum | 12074 | in_mortgage_flag | S | TRADESDBO | TRADE | MORTGAGE_FLAG | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/mortgageFlag |
| muniFlag |
| string | 13281 | in_muni_flag | S | TRADESDBO | TRADE | MUNI_FLAG | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/muniFlag |
| netsettleamt |
| decimal | 191 | in_netsettleamt | F | TRADESDBO | TRADE_DETAIL | NETSETTLEAMT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/netsettleamt |
| navId |
| integer | 12080 | in_nav_id | F | TRADESDBO | TRADE | NAV_ID | NUMBER(28) |
| EagleML/warehouseTransaction/warehouseTrade/navId |
| numberOfAccuredDays |
| decimal | 12081 | in_number_of_accured_days | F | TRADESDBO | TRADE | NUMBER_OF_ACCURED_DAYS | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/numberOfAccuredDays |
| netCashLocal |
| decimal | 13660 | in_net_cash_local | F | TRADESDBO | TRADE_DETAIL | NET_CASH_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/netCashLocal |
| notionalamt |
| decimal | 13663 | in_notionalamt | F | TRADESDBO | TRADE_DETAIL | NOTIONALAMT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/notionalamt |
| notionalflag |
| string | 12189 | in_notionalflag | S | TRADESDBO | TRADE_DETAIL | NOTIONALFLAG | CHAR(1) |
| EagleML/warehouseTransaction/warehouseTrade/notionalflag |
| otherFee |
| decimal | 51 | in_other_fee | F | TRADESDBO | TRADE | OTHER_FEE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/otherFee |
| origTranNum |
| string | 12190 | in_orig_tran_num | S | TRADESDBO | TRADE_DETAIL | ORIG_TRAN_NUM | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/origTranNum |
| ownershipTransferDate |
| date | 12193 | in_ownership_transfer_date | S | TRADESDBO | TRADE_DETAIL | OWNERSHIP_TRANSFER_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/ownershipTransferDate |
| oidYield |
| decimal | 12084 | in_oid_yield | F | TRADESDBO | TRADE | OID_YIELD | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/oidYield |
| otherFeeBase |
| decimal | 12085 | in_other_fee_base | F | TRADESDBO | TRADE | OTHER_FEE_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/otherFeeBase |
| paceTradeEventId |
| string | 13664 | in_pace_trade_event_id | S | TRADESDBO | TRADE_DETAIL | PACE_TRADE_EVENT_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/paceTradeEventId |
| positionIdTrd |
| integer | 13665 | in_position_id_trd | F | TRADESDBO | TRADE_DETAIL | POSITION_ID | NUMBER(38) |
| EagleML/warehouseTransaction/warehouseTrade/positionIdTrd |
| productSubType |
| string | 13667 | in_product_sub_type | S | TRADESDBO | TRADE_DETAIL | PRODUCT_SUB_TYPE | CHAR(12) |
| EagleML/warehouseTransaction/warehouseTrade/productSubType |
| poolNumber |
| string | 12095 | in_pool_number | S | TRADESDBO | TRADE | POOL_NUMBER | CHAR(12) |
| EagleML/warehouseTransaction/warehouseTrade/poolNumber |
| priceCurrency |
| string | 12096 | in_price_currency | S | TRADESDBO | TRADE | PRICE_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/priceCurrency |
| principalFactor |
| decimal | 4483 | in_principal_factor | F | TRADESDBO | TRADE | PRINCIPAL_FACTOR | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/principalFactor |
| realizedGlBase |
| decimal | 13668 | in_realized_gl_base | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_BASE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/realizedGlBase |
| realizedGlCrB |
| decimal | 13669 | in_realized_gl_cr_b | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_CR_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/realizedGlCrB |
| realizedGlCrL |
| decimal | 13670 | in_realized_gl_cr_l | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_CR_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/realizedGlCrL |
| realizedGlLocal |
| decimal | 13671 | in_realized_gl_local | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/realizedGlLocal |
| realizedGlNcrB |
| decimal | 13672 | in_realized_gl_ncr_b | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_NCR_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/realizedGlNcrB |
| realizedGlNcrL |
| decimal | 13673 | in_realized_gl_ncr_l | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_NCR_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/realizedGlNcrL |
| recdPayAcct1 |
| string | 12208 | in_recd_pay_acct1 | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_ACCT1 | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/recdPayAcct1 |
| recdPayAcct2 |
| string | 12209 | in_recd_pay_acct2 | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_ACCT2 | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/recdPayAcct2 |
| recdPayEventType |
| string | 12210 | in_recd_pay_event_type | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_EVENT_TYPE | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/recdPayEventType |
| recdPayPostingPlanType |
| string | 12211 | in_recd_pay_posting_plan_type | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_POSTING_PLAN_TYPE | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/recdPayPostingPlanType |
| refrate |
| decimal | 13674 | in_refrate | F | TRADESDBO | TRADE_DETAIL | REFRATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/refrate |
| repoRate |
| decimal | 12146 | in_repo_rate | F | TRADESDBO | TRADE | REPO_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/repoRate |
| retailFeed |
| string | 12212 | in_retail_feed | S | TRADESDBO | TRADE_DETAIL | RETAIL_FEED | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/retailFeed |
| salesPersonLogin |
| string | 12213 | in_sales_person_login | S | TRADESDBO | TRADE_DETAIL | SALES_PERSON_LOGIN | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/salesPersonLogin |
| secidType |
| string | 12222 | in_secid_type | S | TRADESDBO | TRADE_DETAIL | SECID_TYPE | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/secidType |
| sequencedate |
| date | 12195 | in_sequencedate | S | TRADESDBO | TRADE_DETAIL | SEQUENCEDATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/sequencedate |
| settleamt0 |
| decimal | 13675 | in_settleamt0 | F | TRADESDBO | TRADE_DETAIL | SETTLEAMT0 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/settleamt0 |
| settleamt1 |
| decimal | 13676 | in_settleamt1 | F | TRADESDBO | TRADE_DETAIL | SETTLEAMT1 | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/settleamt1 |
| settled |
| string | 12223 | in_settled | S | TRADESDBO | TRADE_DETAIL | SETTLED | VARCHAR2(10) |
| EagleML/warehouseTransaction/warehouseTrade/settled |
| settleAmtAtMaturity |
| decimal | 12150 | in_settle_amt_at_maturity | F | TRADESDBO | TRADE | SETTLE_AMT_AT_MATURITY | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/settleAmtAtMaturity |
| settlementMethod |
| string | 12103 | in_settlement_method | S | TRADESDBO | TRADE | SETTLEMENT_METHOD | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/settlementMethod |
| shortTermId |
| integer | 12151 | in_short_term_id | F | TRADESDBO | TRADE | SHORT_TERM_ID | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/shortTermId |
| sourceSystem |
| string | 12104 | in_source_system | S | TRADESDBO | TRADE | SOURCE_SYSTEM | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/sourceSystem |
| systemTradeTime |
| string | 12228 | in_system_trade_time | S | TRADESDBO | TRADE_DETAIL | SYSTEM_TRADE_TIME | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/systemTradeTime |
| sentTradeStatus |
| string | 12099 | in_sent_trade_status | S | TRADESDBO | TRADE | SENT_TRADE_STATUS | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/sentTradeStatus |
| starTag151 |
| string | 151 | in_star_tag151 | S | TRADESDBO | TRADE | STAR_TAG151 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/starTag151 |
| starTag182 |
| string | 182 | in_star_tag182 | S | TRADESDBO | TRADE | STAR_TAG182 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/starTag182 |
| stateTaxWithholdBase |
| decimal | 12152 | in_state_tax_withhold_base | F | TRADESDBO | TRADE | STATE_TAX_WITHHOLD_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/stateTaxWithholdBase |
|
| string | 15 | in_star_ls_ind | S | TRADESDBO | TRADE | STAR_LS_IND | VARCHAR2(1) |
| EagleML/warehouseTransaction/warehouseTrade/starLsInd |
| targetPurchaseDate |
| date | 12136 | in_target_purchase_date | S | TRADESDBO | TRADE | TARGET_PURCHASE_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/targetPurchaseDate |
| targetPurchasePrice |
| decimal | 12153 | in_target_purchase_price | F | TRADESDBO | TRADE | TARGET_PURCHASE_PRICE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/targetPurchasePrice |
| targetTradeTicketNumber |
| string | 12110 | in_target_trade_ticket_number | S | TRADESDBO | TRADE | TARGET_TRADE_TICKET_NUMBER | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/targetTradeTicketNumber |
| taxesBase |
| decimal | 12154 | in_taxes_base | F | TRADESDBO | TRADE | TAXES_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/taxesBase |
| timeOfTrade |
| decimal | 12159 | in_time_of_trade | F | TRADESDBO | TRADE | TIME_OF_TRADE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/timeOfTrade |
| toFxRate |
| decimal | 12160 | in_to_fx_rate | F | TRADESDBO | TRADE | TO_FX_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/toFxRate |
| toLocalCommissionAmt |
| decimal | 12161 | in_to_local_commission_amt | F | TRADESDBO | TRADE | TO_LOCAL_COMMISSION_AMT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/toLocalCommissionAmt |
| toSettleToBaseFxRate |
| decimal | 12162 | in_to_settle_to_base_fx_rate | F | TRADESDBO | TRADE | TO_SETTLE_TO_BASE_FX_RATE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/toSettleToBaseFxRate |
| toSettlementCurrency |
| string | 12112 | in_to_settlement_currency | S | TRADESDBO | TRADE | TO_SETTLEMENT_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/toSettlementCurrency |
| transactionId |
| string | 12117 | in_transaction_id | S | TRADESDBO | TRADE | TRANSACTION_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/transactionId |
| turnaroundIndicator |
| string | 12118 | in_turnaround_indicator | S | TRADESDBO | TRADE | TURNAROUND_INDICATOR | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/turnaroundIndicator |
| totalGainLocal |
| decimal | 10050 | in_total_gain_local | F | TRADESDBO | TRADE_DETAIL | TOTAL_GAIN_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/totalGainLocal |
| totalAmortLocal |
| decimal | 5685 | in_total_amort_local | F | TRADESDBO | TRADE_DETAIL | TOTAL_AMORT_LOCAL | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/totalAmortLocal |
| totalAmortBase |
| decimal | 5686 | in_total_amort_base | F | TRADESDBO | TRADE_DETAIL | TOTAL_AMORT_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/totalAmortBase |
| totalLossLocal |
| decimal | 10053 | in_total_loss_local | F | TRADESDBO | TRADE_DETAIL | TOTAL_LOSS_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/totalLossLocal |
| tdUserChar1 |
| string | 12229 | in_td_user_char1 | S | TRADESDBO | TRADE_DETAIL | TD_USER_CHAR1 | VARCHAR2(8) |
| EagleML/warehouseTransaction/warehouseTrade/tdUserChar1 |
| tdUserChar2 |
| string | 12230 | in_td_user_char2 | S | TRADESDBO | TRADE_DETAIL | TD_USER_CHAR2 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tdUserChar2 |
| tdUserDate1 |
| date | 12196 | in_td_user_date1 | S | TRADESDBO | TRADE_DETAIL | TD_USER_DATE1 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/tdUserDate1 |
| tdUserDate2 |
| date | 12202 | in_td_user_date2 | S | TRADESDBO | TRADE_DETAIL | TD_USER_DATE2 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/tdUserDate2 |
| tdUserInt1 |
| integer | 13677 | in_td_user_int1 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT1 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt1 |
| tdUserInt2 |
| integer | 13678 | in_td_user_int2 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT2 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt2 |
| tdUserInt3 |
| integer | 13679 | in_td_user_int3 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT3 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt3 |
| tdUserInt4 |
| integer | 13680 | in_td_user_int4 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT4 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt4 |
| tdUserInt5 |
| integer | 13681 | in_td_user_int5 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT5 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt5 |
| tdUserInt6 |
| integer | 13682 | in_td_user_int6 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT6 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt6 |
| tdUserInt7 |
| integer | 13683 | in_td_user_int7 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT7 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt7 |
| tdUserInt8 |
| integer | 13684 | in_td_user_int8 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT8 | NUMBER |
| EagleML/warehouseTransaction/warehouseTrade/tdUserInt8 |
| tradeMemo3 |
| string | 12238 | in_trade_memo3 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO3 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tradeMemo3 |
| tradeMemo4 |
| string | 12239 | in_trade_memo4 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO4 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tradeMemo4 |
| tradeMemo5 |
| string | 502 | in_trade_memo5 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO5 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tradeMemo5 |
| thirdCurrencyFx |
| decimal | 13685 | in_third_currency_fx | F | TRADESDBO | TRADE_DETAIL | THIRD_CURRENCY_FX | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/thirdCurrencyFx |
| timeOfSalesTicket |
| string | 12232 | in_time_of_sales_ticket | S | TRADESDBO | TRADE_DETAIL | TIME_OF_SALES_TICKET | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/timeOfSalesTicket |
| timeOfSlate |
| string | 12233 | in_time_of_slate | S | TRADESDBO | TRADE_DETAIL | TIME_OF_SLATE | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/timeOfSlate |
| tradeChar1 |
| string | 12113 | in_trade_char1 | S | TRADESDBO | TRADE | TRADE_CHAR1 | VARCHAR2(30) |
| EagleML/warehouseTransaction/warehouseTrade/tradeChar1 |
| tradeFlat |
| string | 12114 | in_trade_flat | S | TRADESDBO | TRADE | TRADE_FLAT | CHAR(2) |
| EagleML/warehouseTransaction/warehouseTrade/tradeFlat |
| tradersLogin |
| string | 12116 | in_traders_login | S | TRADESDBO | TRADE | TRADERS_LOGIN | CHAR(12) |
| EagleML/warehouseTransaction/warehouseTrade/tradersLogin |
| transcost4Amount |
| decimal | 13686 | in_transcost4_amount | F | TRADESDBO | TRADE_DETAIL | TRANSCOST4_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/transcost4Amount |
| transcost4Code |
| string | 12240 | in_transcost4_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST4_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/transcost4Code |
| transcost4Currency |
| string | 12241 | in_transcost4_currency | S | TRADESDBO | TRADE_DETAIL | TRANSCOST4_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/transcost4Currency |
| transcost4TypeCode |
| string | 12242 | in_transcost4_type_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST4_TYPE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/transcost4TypeCode |
| transcost5Amount |
| decimal | 13687 | in_transcost5_amount | F | TRADESDBO | TRADE_DETAIL | TRANSCOST5_AMOUNT | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/transcost5Amount |
| transcost5Code |
| string | 12243 | in_transcost5_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST5_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/transcost5Code |
| transcost5Currency |
| string | 12244 | in_transcost5_currency | S | TRADESDBO | TRADE_DETAIL | TRANSCOST5_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/transcost5Currency |
| transcost5TypeCode |
| string | 12245 | in_transcost5_type_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST5_TYPE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/transcost5TypeCode |
| updateSourceTrd |
| string | 12261 | in_update_source_trd | S | TRADESDBO | TRADE_DETAIL | UPDATE_SOURCE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/updateSourceTrd |
| underlyingAccrIntB |
| decimal | 12164 | in_underlying_accr_int_b | F | TRADESDBO | TRADE | UNDERLYING_ACCR_INT_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntB |
| underlyingAccrIntL |
| decimal | 12165 | in_underlying_accr_int_l | F | TRADESDBO | TRADE | UNDERLYING_ACCR_INT_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntL |
| underlyingAccrIntLMat |
| decimal | 12201 | in_underlying_accr_int_l_mat | F | TRADESDBO | TRADE | UNDERLYING_ACCR_INT_L_MAT | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntLMat |
| withholdCode |
| string | 12263 | in_withhold_code | S | TRADESDBO | TRADE_DETAIL | WITHHOLD_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/withholdCode |
| withholdCurrency |
| string | 12264 | in_withhold_currency | S | TRADESDBO | TRADE_DETAIL | WITHHOLD_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/withholdCurrency |
| withholdTypeCode |
| string | 12265 | in_withhold_type_code | S | TRADESDBO | TRADE_DETAIL | WITHHOLD_TYPE_CODE | CHAR(8) |
| EagleML/warehouseTransaction/warehouseTrade/withholdTypeCode |
| workoutDate |
| date | 12214 | in_workout_date | S | TRADESDBO | TRADE_DETAIL | WORKOUT_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/workoutDate |
| workoutPrice |
| decimal | 13689 | in_workout_price | F | TRADESDBO | TRADE_DETAIL | WORKOUT_PRICE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/workoutPrice |
| withholdingTax |
| decimal | 12216 | in_withholding_tax | F | TRADESDBO | TRADE | WITHHOLDING_TAX | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/withholdingTax |
| batchEventId |
| string | 701 | in_batch_event_id | S | TRADESDBO | TRADE_DETAIL | BATCH_EVENT_ID | VARCHAR2(55) |
| EagleML/warehouseTransaction/warehouseTrade/batchEventId |
| secFee |
| decimal | 3752 | in_sec_fees | F | TRADESDBO | TRADE | SEC_FEES | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/secFee |
| tradeDate |
| date | 35 | in_trade_date | S | TRADESDBO | TRADE | TRADE_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/tradeDate |
| recordType |
| string | 12097 | in_record_type | S | TRADESDBO | TRADE | RECORD_TYPE | CHAR(4) |
| EagleML/warehouseTransaction/warehouseTrade/recordType |
|
| decimal | 162 | in_cost_local | F | TRADESDBO | TRADE | COST_LOCAL | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/costLocal |
|
| decimal | 166 | in_cost_base | F | TRADESDBO | TRADE | COST_BASE | NUMBER(28,12) |
| EagleML/warehouseTransaction/warehouseTrade/costBase |
| linkEventId |
| TransactionId | 28 | in_link_event_id | S | TRADESDBO | TRADE | LINK_EVENT_ID | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/linkEventId |
| localCurrency |
| CurrencyCode |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehouseTrade/localCurrency |
| commissionCurrency |
| CurrencyCode | 85 |
|
| TRADESDBO | TRADE | COMMISSION_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/commissionCurrency |
| eventSequence |
| integer | 126 |
|
| TRADESDBO | TRADE | EVENT_SEQUENCE | INTEGER |
| EagleML/warehouseTransaction/warehouseTrade/eventSequence |
| starTag26 |
| string | 26 |
|
| TRADESDBO | TRADE | STAR_TAG26 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/starTag26 |
| tradeCurrency |
| CurrencyCode | 85 |
|
| TRADESDBO | TRADE | TRADE_CURRENCY | CHAR(3) |
| EagleML/warehouseTransaction/warehouseTrade/tradeCurrency |
| settleInstructions1 |
| string | 8074 | in_settle_instructions1 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS1 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settleInstructions1 |
| settleInstructions2 |
| string | 8075 | in_settle_instructions2 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS2 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settleInstructions2 |
| settleInstructions3 |
| string | 8076 | in_settle_instructions3 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS3 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settleInstructions3 |
| settleInstructions4 |
| string | 8077 | in_settle_instructions4 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS4 | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/settleInstructions4 |
| orderNumber |
| string | 1092 | in_order_number |
| TRADESDBO | TRADE | ORDER_NUMBER | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/orderNumber |
| priceMethod |
| normalizedString | 1872 | in_price_method | S | TRADESDBO | TRADE | PRICE_METHOD | VARCHAR2(4) |
| EagleML/warehouseTransaction/warehouseTrade/priceMethod |
| regulatoryIntent |
| normalizedString | 8915 | in_regulatory_intent | S | TRADESDBO | TRADE | REGULATORY_INTENT | VARCHAR2(3) |
| EagleML/warehouseTransaction/warehouseTrade/regulatoryIntent |
| holdingTerm |
| normalizedString | 9091 | in_holding_term | S | TRADESDBO | TRADE | HOLDING_TERM | VARCHAR2(2) |
| EagleML/warehouseTransaction/warehouseTrade/holdingTerm |
| income |
| decimal | 2552 | in_income | F | TRADESDBO | TRADE | INCOME | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/income |
| incomeAmountBase |
| decimal | 2559 | in_income_base | F | TRADESDBO | TRADE | INCOME_BASE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/incomeAmountBase |
| deskAka |
| string | 7350 | in_counterparty_desk_aka | S | TRADESDBO | TRADE_DETAIL_EXT | COUNTERPARTY_DESK_AKA | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/deskAka |
| deskType |
| string | 7002 | in_counterparty_desk_type | S | TRADESDBO | TRADE_DETAIL_EXT | COUNTERPARTY_DESK_TYPE | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/deskType |
| desk |
| string | 7003 | in_counterparty_desk | S | TRADESDBO | TRADE_DETAIL_EXT | COUNTERPARTY_DESK | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/desk |
| exSubBrokerId |
| string | 7004 | in_ex_sub_broker_id | S | TRADESDBO | TRADE_DETAIL_EXT | EX_SUB_BROKER_ID | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/exSubBrokerId |
| placementNum |
| string | 7005 | in_placement_num | S | TRADESDBO | TRADE_DETAIL_EXT | PLACEMENT_NUM |
|
| EagleML/warehouseTransaction/warehouseTrade/placementNum |
| subBrokerCode |
| string | 7006 | in_sub_broker_code | S | TRADESDBO | TRADE_DETAIL_EXT | SUB_BROKER_CODE | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/subBrokerCode |
| tradeInterfaceInfo |
| string | 7007 | in_trade_error_note | S | TRADESDBO | TRADE_DETAIL_EXT | TRADE_ERROR_NOTE | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/tradeInterfaceInfo |
| trdBrokerAka |
| string | 7008 | in_alt_trade_broker_code | S | TRADESDBO | TRADE_DETAIL_EXT | ALT_TRADE_BROKER_CODE | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdBrokerAka |
| trdDirtyPrice |
| decimal | 7962 | in_trd_dirty_price | F | TRADESDBO | TRADE_DETAIL_EXT | TRD_DIRTY_PRICE | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDirtyPrice |
| trdExBrokerDesk |
| string | 7009 | in_ex_broker_desk | S | TRADESDBO | TRADE_DETAIL_EXT | EX_BROKER_DESK | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/trdExBrokerDesk |
| trdExDeskType |
| string | 7010 | in_ex_broker_desk_type | S | TRADESDBO | TRADE_DETAIL_EXT | EX_BROKER_DESK_TYPE | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/trdExDeskType |
| trdExternalAccountLoc |
| string | 7011 | in_trd_external_account_loc | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ACCOUNT_LOC | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/trdExternalAccountLoc |
| trdLocation |
| string | 7012 | in_trd_location | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_LOCATION | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/trdLocation |
| trdSeriesNum |
| string | 7013 | in_trd_lot_num_code | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_LOT_NUM_CODE | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/trdSeriesNum |
| trdVersion |
| string | 7014 | in_trd_version | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_VERSION | VARCHAR2(50) |
| EagleML/warehouseTransaction/warehouseTrade/trdVersion |
| trdExtidId1 |
| string | 7015 | in_trd_external_id_1 | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ID_1 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdExtidId1 |
| trdExtidId2 |
| string | 7016 | in_trd_external_id_2 | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ID_2 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdExtidId2 |
| tbaInvnum |
| integer |
| in_tba_invnum | F | TRADESDBO | TRADE_DETAIL_EXT | TBA_INVNUM |
|
| EagleML/warehouseTransaction/warehouseTrade/tbaInvnum |
| tbaTrdDate |
| date |
| in_tba_trd_date | S | TRADESDBO | TRADE_DETAIL_EXT | TBA_TRD_DATE |
|
| EagleML/warehouseTransaction/warehouseTrade/tbaTrdDate |
| collatExposureType |
| string |
| in_collat_exposure_type | S | TRADESDBO | TRADE_DETAIL_EXT | COLLAT_EXPOSURE_TYPE |
|
| EagleML/warehouseTransaction/warehouseTrade/collatExposureType |
| effTermDate |
| date |
| in_eff_term_date | S | TRADESDBO | TRADE_DETAIL_EXT | EFF_TERM_DATE |
|
| EagleML/warehouseTransaction/warehouseTrade/effTermDate |
| contractRef |
| string |
| in_uti | S | TRADESDBO | TRADE_DETAIL_EXT | UTI |
|
| EagleML/warehouseTransaction/warehouseTrade/contractRef |
| trdExternalId1Type |
| string |
| in_trd_external_id_1_type | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ID_1_TYPE |
|
| EagleML/warehouseTransaction/warehouseTrade/trdExternalId1Type |
| trdExternalId2Type |
| string |
| in_trd_external_id_2_type | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ID_2_TYPE |
|
| EagleML/warehouseTransaction/warehouseTrade/trdExternalId2Type |
| newIssueIndicator |
| string | 18302 | in_new_issue | S | TRADESDBO | TRADE_DETAIL_EXT | NEW_ISSUE | VARCHAR2(3) |
| EagleML/warehouseTransaction/warehouseTrade/newIssueIndicator |
| dealSource |
| string | 18303 | in_deal_source | S | TRADESDBO | TRADE_DETAIL_EXT | DEAL_SOURCE | VARCHAR2(40) |
| EagleML/warehouseTransaction/warehouseTrade/dealSource |
| stGainSecLocal |
| decimal | 17347 |
|
| TRADESDBO | TRADE_EXT | ST_GAIN_SEC_L |
|
| EagleML/warehouseTransaction/warehouseTrade/stGainSecLocal |
| stLossSecLocal |
| decimal | 17348 |
|
| TRADESDBO | TRADE_EXT | ST_LOSS_SEC_L |
|
| EagleML/warehouseTransaction/warehouseTrade/stLossSecLocal |
| stGainSecBase |
| decimal | 17349 |
|
| TRADESDBO | TRADE_EXT | ST_GAIN_SEC_B |
|
| EagleML/warehouseTransaction/warehouseTrade/stGainSecBase |
| stLossSecBase |
| decimal | 17350 |
|
| TRADESDBO | TRADE_EXT | ST_LOSS_SEC_B |
|
| EagleML/warehouseTransaction/warehouseTrade/stLossSecBase |
| stGain |
| decimal | 17351 |
|
| TRADESDBO | TRADE_EXT | ST_GAIN |
|
| EagleML/warehouseTransaction/warehouseTrade/stGain |
| stLoss |
| decimal | 17352 |
|
| TRADESDBO | TRADE_EXT | ST_LOSS |
|
| EagleML/warehouseTransaction/warehouseTrade/stLoss |
| stGainCurrency |
| decimal | 17353 |
|
| TRADESDBO | TRADE_EXT | ST_GAIN_CRRCY |
|
| EagleML/warehouseTransaction/warehouseTrade/stGainCurrency |
| stLossCurrency |
| decimal | 17354 |
|
| TRADESDBO | TRADE_EXT | ST_LOSS_CRRCY |
|
| EagleML/warehouseTransaction/warehouseTrade/stLossCurrency |
| ltGainSecLocal |
| decimal | 17355 |
|
| TRADESDBO | TRADE_EXT | LT_GAIN_SEC_L |
|
| EagleML/warehouseTransaction/warehouseTrade/ltGainSecLocal |
| ltLossSecLocal |
| decimal | 17356 |
|
| TRADESDBO | TRADE_EXT | LT_LOSS_SEC_L |
|
| EagleML/warehouseTransaction/warehouseTrade/ltLossSecLocal |
| ltGainSecBase |
| decimal | 17357 |
|
| TRADESDBO | TRADE_EXT | LT_GAIN_SEC_B |
|
| EagleML/warehouseTransaction/warehouseTrade/ltGainSecBase |
| ltLossSecBase |
| decimal | 17358 |
|
| TRADESDBO | TRADE_EXT | LT_LOSS_SEC_B |
|
| EagleML/warehouseTransaction/warehouseTrade/ltLossSecBase |
| ltGain |
| decimal | 17359 |
|
| TRADESDBO | TRADE_EXT | LT_GAIN |
|
| EagleML/warehouseTransaction/warehouseTrade/ltGain |
| ltLoss |
| decimal | 17360 |
|
| TRADESDBO | TRADE_EXT | LT_LOSS |
|
| EagleML/warehouseTransaction/warehouseTrade/ltLoss |
| ltGainCurrency |
| decimal | 17361 |
|
| TRADESDBO | TRADE_EXT | LT_GAIN_CRRCY |
|
| EagleML/warehouseTransaction/warehouseTrade/ltGainCurrency |
| ltLossCurrency |
| decimal | 17362 |
|
| TRADESDBO | TRADE_EXT | LT_LOSS_CRRCY |
|
| EagleML/warehouseTransaction/warehouseTrade/ltLossCurrency |
| clsAmortLocal |
| decimal | 17363 |
|
| TRADESDBO | TRADE_EXT | CLS_AMORT_LOCAL |
|
| EagleML/warehouseTransaction/warehouseTrade/clsAmortLocal |
| clsAmortBase |
| decimal | 17364 |
|
| TRADESDBO | TRADE_EXT | CLS_AMORT_BASE |
|
| EagleML/warehouseTransaction/warehouseTrade/clsAmortBase |
| clsOidLocal |
| decimal | 17365 |
|
| TRADESDBO | TRADE_EXT | CLS_OID_L |
|
| EagleML/warehouseTransaction/warehouseTrade/clsOidLocal |
| clsOidBase |
| decimal | 17366 |
|
| TRADESDBO | TRADE_EXT | CLS_OID_B |
|
| EagleML/warehouseTransaction/warehouseTrade/clsOidBase |
| clsIlbIncLtdLocal |
| decimal | 17367 |
|
| TRADESDBO | TRADE_EXT | CLS_ILB_INC_LTD_LOCAL |
|
| EagleML/warehouseTransaction/warehouseTrade/clsIlbIncLtdLocal |
| clsIlbIncLtdBase |
| decimal | 17368 |
|
| TRADESDBO | TRADE_EXT | CLS_ILB_INC_LTD_BASE |
|
| EagleML/warehouseTransaction/warehouseTrade/clsIlbIncLtdBase |
| gainCurrency988 |
| decimal | 17369 | in_gain_currency_988 |
| TRADESDBO | TRADE_EXT | GAIN_CRRCY_988 |
|
| EagleML/warehouseTransaction/warehouseTrade/gainCurrency988 |
| lossCurrency988 |
| decimal | 17370 | in_loss_currency_988 |
| TRADESDBO | TRADE_EXT | LOSS_CRRCY_988 |
|
| EagleML/warehouseTransaction/warehouseTrade/lossCurrency988 |
| gainLossCurrency988 |
| decimal | 17371 |
|
| TRADESDBO | TRADE_EXT | GAIN_LOSS_CRRCY_988 |
|
| EagleML/warehouseTransaction/warehouseTrade/gainLossCurrency988 |
| washsaleDisallowedReversalLocal |
| decimal | 17372 |
|
| TRADESDBO | TRADE_EXT | WS_DISALLOW_REV_L |
|
| EagleML/warehouseTransaction/warehouseTrade/washsaleDisallowedReversalLocal |
| washsaleDisallowedReversalBase |
| decimal | 17373 |
|
| TRADESDBO | TRADE_EXT | WS_DISALLOW_REV_B |
|
| EagleML/warehouseTransaction/warehouseTrade/washsaleDisallowedReversalBase |
| impairmentLtdLocalExt |
| decimal | 17374 |
|
| TRADESDBO | TRADE_EXT | IMPAIRMENT_LTD_LOCAL |
|
| EagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocalExt |
| impairmentLtdBaseExt |
| decimal | 17375 |
|
| TRADESDBO | TRADE_EXT | IMPAIRMENT_LTD_BASE |
|
| EagleML/warehouseTransaction/warehouseTrade/impairmentLtdBaseExt |
| impairmentFxLtd |
| decimal | 17376 |
|
| TRADESDBO | TRADE_EXT | IMPAIRMENT_FX_LTD |
|
| EagleML/warehouseTransaction/warehouseTrade/impairmentFxLtd |
| recPayAcctSecondary |
| string | 17377 |
|
| TRADESDBO | TRADE_EXT | REC_PAY_ACCT_SECONDARY |
|
| EagleML/warehouseTransaction/warehouseTrade/recPayAcctSecondary |
| recPayAcct2Secondary |
| string | 17378 |
|
| TRADESDBO | TRADE_EXT | REC_PAY_ACCT2_SECONDARY |
|
| EagleML/warehouseTransaction/warehouseTrade/recPayAcct2Secondary |
| nonCreditLedgerDebit |
| string | 17379 |
|
| TRADESDBO | TRADE_EXT | NON_CREDIT_LEDGER_DR |
|
| EagleML/warehouseTransaction/warehouseTrade/nonCreditLedgerDebit |
| nonCreditLedgerCredit |
| string | 17380 |
|
| TRADESDBO | TRADE_EXT | NON_CREDIT_LEDGER_CR |
|
| EagleML/warehouseTransaction/warehouseTrade/nonCreditLedgerCredit |
| ociLedgerDebit |
| string | 17381 |
|
| TRADESDBO | TRADE_EXT | OCI_LEDGER_DR |
|
| EagleML/warehouseTransaction/warehouseTrade/ociLedgerDebit |
| ociLedgerCredit |
| string | 17382 |
|
| TRADESDBO | TRADE_EXT | OCI_LEDGER_CR |
|
| EagleML/warehouseTransaction/warehouseTrade/ociLedgerCredit |
| fxImpairLedgerDebit |
| string | 17383 |
|
| TRADESDBO | TRADE_EXT | FX_IMPAIR_LEDGER_DR |
|
| EagleML/warehouseTransaction/warehouseTrade/fxImpairLedgerDebit |
| fxImpairLedgerCredit |
| string | 17384 |
|
| TRADESDBO | TRADE_EXT | FX_IMPAIR_LEDGER_CR |
|
| EagleML/warehouseTransaction/warehouseTrade/fxImpairLedgerCredit |
| breakageAmountLocal |
| decimal | 17385 |
|
| TRADESDBO | TRADE_EXT | BREAKAGE_AMOUNT_LOCAL |
|
| EagleML/warehouseTransaction/warehouseTrade/breakageAmountLocal |
| breakageAmountBase |
| decimal | 17386 |
|
| TRADESDBO | TRADE_EXT | BREAKAGE_AMOUNT_BASE |
|
| EagleML/warehouseTransaction/warehouseTrade/breakageAmountBase |
| trdDetExtUserFloat1 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT1 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat1 |
| trdDetExtUserFloat2 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT2 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat2 |
| trdDetExtUserFloat3 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT3 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat3 |
| trdDetExtUserFloat4 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT4 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat4 |
| trdDetExtUserFloat5 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT5 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat5 |
| trdDetExtUserFloat6 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT6 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat6 |
| trdDetExtUserFloat7 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT7 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat7 |
| trdDetExtUserFloat8 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT8 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat8 |
| trdDetExtUserFloat9 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT9 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat9 |
| trdDetExtUserFloat10 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT10 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat10 |
| trdDetExtUserFloat11 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT11 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat11 |
| trdDetExtUserFloat12 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT12 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat12 |
| trdDetExtUserFloat13 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT13 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat13 |
| trdDetExtUserFloat14 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT14 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat14 |
| trdDetExtUserFloat15 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT15 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat15 |
| trdDetExtUserFloat16 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT16 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat16 |
| trdDetExtUserFloat17 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT17 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat17 |
| trdDetExtUserFloat18 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT18 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat18 |
| trdDetExtUserFloat19 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT19 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat19 |
| trdDetExtUserFloat20 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT20 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat20 |
| trdDetExtUserFloat21 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT21 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat21 |
| trdDetExtUserFloat22 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT22 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat22 |
| trdDetExtUserFloat23 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT23 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat23 |
| trdDetExtUserFloat24 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT24 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat24 |
| trdDetExtUserFloat25 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT25 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat25 |
| trdDetExtUserFloat26 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT26 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat26 |
| trdDetExtUserFloat27 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT27 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat27 |
| trdDetExtUserFloat28 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT28 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat28 |
| trdDetExtUserFloat29 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT29 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat29 |
| trdDetExtUserFloat30 |
| decimal |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_FLOAT30 | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserFloat30 |
| trdDetExtUserChar1 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR1 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar1 |
| trdDetExtUserChar2 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR2 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar2 |
| trdDetExtUserChar3 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR3 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar3 |
| trdDetExtUserChar4 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR4 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar4 |
| trdDetExtUserChar5 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR5 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar5 |
| trdDetExtUserChar6 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR6 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar6 |
| trdDetExtUserChar7 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR7 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar7 |
| trdDetExtUserChar8 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR8 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar8 |
| trdDetExtUserChar9 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR9 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar9 |
| trdDetExtUserChar10 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR10 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar10 |
| trdDetExtUserChar11 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR11 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar11 |
| trdDetExtUserChar12 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR12 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar12 |
| trdDetExtUserChar13 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR13 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar13 |
| trdDetExtUserChar14 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR14 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar14 |
| trdDetExtUserChar15 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR15 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar15 |
| trdDetExtUserChar16 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR16 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar16 |
| trdDetExtUserChar17 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR17 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar17 |
| trdDetExtUserChar18 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR18 | VARCHAR2(60) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar18 |
| trdDetExtUserChar19 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR19 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar19 |
| trdDetExtUserChar20 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR20 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar20 |
| trdDetExtUserChar21 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR21 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar21 |
| trdDetExtUserChar22 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR22 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar22 |
| trdDetExtUserChar23 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR23 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar23 |
| trdDetExtUserChar24 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR24 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar24 |
| trdDetExtUserChar25 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR25 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar25 |
| trdDetExtUserChar26 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR26 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar26 |
| trdDetExtUserChar27 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR27 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar27 |
| trdDetExtUserChar28 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR28 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar28 |
| trdDetExtUserChar29 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR29 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar29 |
| trdDetExtUserChar30 |
| string |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_CHAR30 | VARCHAR2(200) |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserChar30 |
| trdDetExtUserDate1 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE1 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate1 |
| trdDetExtUserDate2 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE2 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate2 |
| trdDetExtUserDate3 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE3 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate3 |
| trdDetExtUserDate4 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE4 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate4 |
| trdDetExtUserDate5 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE5 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate5 |
| trdDetExtUserDate6 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE6 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate6 |
| trdDetExtUserDate7 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE7 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate7 |
| trdDetExtUserDate8 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE8 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate8 |
| trdDetExtUserDate9 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE9 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate9 |
| trdDetExtUserDate10 |
| date |
|
|
| TRADESDBO | TRADE_DETAIL_EXT | USER_DATE10 | DATE |
| EagleML/warehouseTransaction/warehouseTrade/trdDetExtUserDate10 |
| consolidatedIndicator |
|
|
| in_consolidated_flag |
| TRADESDBO | TRADE | CONSOLIDATED_FLAG | CHAR(1) |
| EagleML/warehouseTransaction/warehouseTrade/consolidatedIndicator |
| fromRegulatoryCategory |
|
|
| in_from_regulatory_category |
| TRADESDBO | TRADE | FROM_REGULATORY_CATEGORY | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/fromRegulatoryCategory |
| toRegulatoryCategory |
|
|
| in_to_regulatory_category |
| TRADESDBO | TRADE | TO_REGULATORY_CATEGORY | VARCHAR2(20) |
| EagleML/warehouseTransaction/warehouseTrade/toRegulatoryCategory |
| cancelPostDate |
|
|
| in_cancel_post_date |
| TRADESDBO | TRADE_DETAIL | CANCEL_POST_DATE | DATE |
| EagleML/warehouseTransaction/warehouseTrade/cancelPostDate |
| cancelReasonIndicator |
|
|
| in_cancel_reason_flag |
| TRADESDBO | TRADE_DETAIL | CANCEL_REASON_FLAG | VARCHAR2(255) |
| EagleML/warehouseTransaction/warehouseTrade/cancelReasonIndicator |
| commitmentAmount |
|
|
| in_commitment |
| TRADESDBO | TRADE_DETAIL | COMMITMENT | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/commitmentAmount |
| distributedInvestmentIncomeLocal |
|
|
| in_dist_inv_inc_l |
| TRADESDBO | TRADE_DETAIL | DIST_INV_INC_L | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/distributedInvestmentIncomeLocal |
| distributedInvestmentIncomeBase |
|
|
| in_dist_inv_inc_b |
| TRADESDBO | TRADE_DETAIL | DIST_INV_INC_B | NUMBER(38,12) |
| EagleML/warehouseTransaction/warehouseTrade/distributedInvestmentIncomeBase |
| TradeChargesModel |
| Trade Charges Model - see extra table | EagleML/warehouseTransaction/warehouseTrade/TradeChargesModel/ |
| TradeQuotesModel |
| Trade Quotes Model - see extra table | EagleML/warehouseTransaction/warehouseTrade/TradeQuotesModel/ |
| BrokerTradeQuoteModel |
| Broker Trade Quote Model - see extra table | EagleML/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 |
| string | 2983 |
|
|
|
|
|
|
| EagleML/warehouseTransaction/warehouseTrade/calcTransactionId |
| calcMasterTransactionId |
| string | 2984 |
|
|
|
| MASTER_TXN_ID |
|
| EagleML/warehouseTransaction/warehouseTrade/calcMasterTransactionId |
| calcCancelTransactionId |
| string | 2985 |
|
|
|
| CXL_TARGET_ID |
|
| EagleML/warehouseTransaction/warehouseTrade/calcCancelTransactionId |