Important Note
- Warehouse Trade Data Map Table#netCash and Warehouse Trade Data Map Table#netAmountLocal are passed into the same DB field TRADESDBO.TRADE.NET_CASH. You should use either of these two nodes in your incoming message, but not both of them at the same time.
- Warehouse Trade Data Map Table#toCashType and Warehouse Trade Data Map Table#toCashEventType are passed into the same DB field TRADESDBO.TRADE.TO_CASH_TYPE. You should use either of these two nodes in your incoming message, but not both of them at the same time (if you try to load both, only toCashType will be processed).
- the SP is currently designed to load Warehouse Trade Data Map Table#longShortIndicator and Warehouse Trade Data Map Table#starLsInd via the same SP parameter in_star_ls_ind. Therefore, these nodes are populated with the same value into DB.
- Warehouse Trade Data Map Table#costLocal and Warehouse Trade Data Map Table#openCostLocal, Warehouse Trade Data Map Table#costBase and Warehouse Trade Data Map Table#openCostBase are mapped via in_cost_local and in_cost_base SP parameters respectively (costLocal and costBase have a higher priority)
Please note, that some fields are not supported by the underlying core stored procedure (TRD_EGL_GEN_INTERFACE) for earlier DB versions and therefore these fields will not be processed - you need DB version >= v17R2.23 to do that.
load/extract: costLocal, costBase, settleInstructions1, settleInstructions2, settleInstructions3, settleInstructions4, orderNumber, priceMethod, regulatoryIntent, holdingTermUSER fields below are supported for Extracts Only due to the underlying core stored procedure limitation:
from trdDetExtUserDate1 to trdDetExtUserDate10
- trdDetExtUserChar1 to trdDetExtUserChar3
- trdDetExtUserFloat1 to trdDetExtUserFloat3
| 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 | ||
| gainSecurityBase | decimal | 10051 | in_security_gain | F | TRADESDBO | TRADE_DETAIL | SECURITY_GAIN | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseTrade/gainSecurityBase | ||
| 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 | ||
| lossSecurityBase | decimal | 10054 | in_security_loss | F | TRADESDBO | TRADE_DETAIL | SECURITY_LOSS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseTrade/lossSecurityBase | ||
| 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 | ||
openCostBase | 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 | ||
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 | ||
netAmountLocal | decimal | 50 | in_net_cash | F | TRADESDBO | TRADE | NET_CASH | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseTrade/netAmountLocal | ||
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 | ||
toCashType | 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 | ||
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 | ||
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 | ||
netCash | 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 | ||
starLsInd | 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 | ||
costLocal | decimal | 162 | in_cost_local | F | TRADESDBO | TRADE | COST_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseTrade/costLocal | ||
costBase | 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 | |||||
| expectedCreditLossAmountLocal | in_ecl_local | TRADESDBO | TRADE_DETAIL | ECL_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossAmountLocal | |||||
| expectedCreditLossAmountBase | in_ecl_base | TRADESDBO | TRADE_DETAIL | ECL_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossAmountBase | |||||
| expectedCreditLossDeltaAmountLocal | in_ecl_delta_local | TRADESDBO | TRADE_DETAIL | ECL_DELTA_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossDeltaAmountLocal | |||||
| expectedCreditLossDeltaAmountBase | in_ecl_delta_base | TRADESDBO | TRADE_DETAIL | ECL_DELTA_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossDeltaAmountBase | |||||
| expectedCreditLossPreviousAmountLocal | in_ecl_prev_local | TRADESDBO | TRADE_DETAIL | ECL_PREV_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossPreviousAmountLocal | |||||
| expectedCreditLossPreviousAmountBase | in_ecl_prev_base | TRADESDBO | TRADE_DETAIL | ECL_PREV_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossPreviousAmountBase | |||||
| expectedCreditLossStageAmount | in_ecl_stage | TRADESDBO | TRADE_DETAIL | ECL_STAGE | NUMBER(38) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossStageAmount | |||||
| expectedCreditLossPreviousStageAmount | in_ecl_prev_stage | TRADESDBO | TRADE_DETAIL | ECL_PREV_STAGE | NUMBER(38) | EagleML/warehouseTransaction/warehouseTrade/expectedCreditLossPreviousStageAmount | |||||
| equityMethodAcctCostIndicator | in_ema_cost_flag | TRADESDBO | TRADE_DETAIL | EMA_COST_FLAG | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctCostIndicator | |||||
| equityMethodAcctTreatmentMethod | in_ema_treatment | TRADESDBO | TRADE_DETAIL | EMA_TREATMENT | VARCHAR2(10) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctTreatmentMethod | |||||
| fxImpairmentRate | in_fx_impairment | TRADESDBO | TRADE_DETAIL | FX_IMPAIRMENT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/fxImpairmentRate | |||||
| equityMethodAcctCRCCTGainBase | in_gain_crcct_ema_b | TRADESDBO | TRADE_DETAIL | GAIN_CRCCT_EMA_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctCRCCTGainBase | |||||
| currentPeriodCurrencyGain | in_gain_crrcy_curr_pre | TRADESDBO | TRADE_DETAIL | GAIN_CRRCY_CURR_PRE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currentPeriodCurrencyGain | |||||
| currencyIncomeGain | in_gain_crrcy_income | TRADESDBO | TRADE_DETAIL | GAIN_CRRCY_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currencyIncomeGain | |||||
| termGainLoss | in_gain_loss_term | TRADESDBO | TRADE_DETAIL | GAIN_LOSS_TERM | VARCHAR2(2) | EagleML/warehouseTransaction/warehouseTrade/termGainLoss | |||||
| currentPeriodSecurityGainBase | in_gain_sec_curr_b_pre | TRADESDBO | TRADE_DETAIL | GAIN_SEC_CURR_B_PRE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityGainBase | |||||
| currentPeriodSecurityGainLocal | in_gain_sec_curr_l_pre | TRADESDBO | TRADE_DETAIL | GAIN_SEC_CURR_L_PRE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityGainLocal | |||||
| equityMethodAcctSecurityGainBase | in_gain_sec_ema_b | TRADESDBO | TRADE_DETAIL | GAIN_SEC_EMA_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityGainBase | |||||
| equityMethodAcctSecurityGainLocal | in_gain_sec_ema_l | TRADESDBO | TRADE_DETAIL | GAIN_SEC_EMA_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityGainLocal | |||||
| impairReasonCode | in_impair_reason_code | TRADESDBO | TRADE_DETAIL | IMPAIR_REASON_CODE | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseTrade/impairReasonCode | |||||
| equityMethodAcctCurrencyLossBase | in_loss_crccy_ema_b | TRADESDBO | TRADE_DETAIL | LOSS_CRCCY_EMA_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctCurrencyLossBase | |||||
| currentPeriodCurrencyLoss | in_loss_crrcy_curr_pre | TRADESDBO | TRADE_DETAIL | LOSS_CRRCY_CURR_PRE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currentPeriodCurrencyLoss | |||||
| currencyIncomeLoss | in_loss_crrcy_income | TRADESDBO | TRADE_DETAIL | LOSS_CRRCY_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currencyIncomeLoss | |||||
| currentPeriodSecurityLossBase | in_loss_sec_curr_b_pre | TRADESDBO | TRADE_DETAIL | LOSS_SEC_CURR_B_PRE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityLossBase | |||||
| currentPeriodSecurityLossLocal | in_loss_sec_curr_l_pre | TRADESDBO | TRADE_DETAIL | LOSS_SEC_CURR_L_PRE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/currentPeriodSecurityLossLocal | |||||
| equityMethodAcctSecurityLossBase | in_loss_sec_ema_b | TRADESDBO | TRADE_DETAIL | LOSS_SEC_EMA_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityLossBase | |||||
| equityMethodAcctSecurityLossLocal | in_loss_sec_ema_l | TRADESDBO | TRADE_DETAIL | LOSS_SEC_EMA_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctSecurityLossLocal | |||||
| equityMethodAcctMarketVaueBase | in_mkt_val_ema_b | TRADESDBO | TRADE_DETAIL | MKT_VAL_EMA_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctMarketVaueBase | |||||
| equityMethodAcctMarketVaueLocal | in_mkt_val_ema_l | TRADESDBO | TRADE_DETAIL | MKT_VAL_EMA_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctMarketVaueLocal | |||||
| notionalOrUnitsIndicator | in_notional_or_units_flag | TRADESDBO | TRADE_DETAIL | NOTIONAL_OR_UNITS_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseTrade/notionalOrUnitsIndicator | |||||
| ownershipPercentage | in_ownership_percentage | TRADESDBO | TRADE_DETAIL | OWNERSHIP_PERCENTAGE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/ownershipPercentage | |||||
| cashFlowEffectiveDate | in_performance_eff_date | TRADESDBO | TRADE_DETAIL | PERFORMANCE_EFF_DATE | DATE | EagleML/warehouseTransaction/warehouseTrade/cashFlowEffectiveDate | |||||
| equityMethodAcctPeriodMarketValueLocal | in_pre_mkt_val_ema_l | TRADESDBO | TRADE_DETAIL | PRE_MKT_VAL_EMA_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctPeriodMarketValueLocal | |||||
| equityMethodAcctPeriodMarketValueBase | in_pre_mkt_val_ema_b | TRADESDBO | TRADE_DETAIL | PRE_MKT_VAL_EMA_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/equityMethodAcctPeriodMarketValueBase | |||||
| prorataCreditNonCreditLossFlag | in_prorata_cnc_loss_flag | TRADESDBO | TRADE_DETAIL | PRORATA_CNC_LOSS_FLAG | VARCHAR2(3) | EagleML/warehouseTransaction/warehouseTrade/prorataCreditNonCreditLossFlag | |||||
| purchasedImpairedIndicator | in_purchased_impaired | TRADESDBO | TRADE_DETAIL | PURCHASED_IMPAIRED | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseTrade/purchasedImpairedIndicator | |||||
| researchFeeLocal | in_research_fees_local | TRADESDBO | TRADE_DETAIL | RESEARCH_FEES_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/researchFeeLocal | |||||
| researchFeeBase | in_research_fees_base | TRADESDBO | TRADE_DETAIL | RESEARCH_FEES_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/researchFeeBase | |||||
| sleeveId | in_sleeve_id | TRADESDBO | TRADE_DETAIL | SLEEVE_ID | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseTrade/sleeveId | |||||
| srcSysC | in_src_sys_c | TRADESDBO | TRADE_DETAIL | SRC_SYS_C | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseTrade/srcSysC | |||||
| starSourceLevel | in_star_src_lvl | TRADESDBO | TRADE_DETAIL | STAR_SRC_LVL | VARCHAR2(4) | EagleML/warehouseTransaction/warehouseTrade/starSourceLevel | |||||
| technicalShortLevel | in_techsh_src | TRADESDBO | TRADE_DETAIL | TECHSH_SRC | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseTrade/technicalShortLevel | |||||
| undistributedInvestmentIncomeBase | in_undist_inv_inc_b | TRADESDBO | TRADE_DETAIL | UNDIST_INV_INC_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/undistributedInvestmentIncomeBase | |||||
| undistributedInvestmentIncomeLocal | in_undist_inv_inc_l | TRADESDBO | TRADE_DETAIL | UNDIST_INV_INC_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/undistributedInvestmentIncomeLocal | |||||
| unrealizedUndistributedInvestmentIncomeBase | in_unreal_undist_inv_inc_l | TRADESDBO | TRADE_DETAIL | UNREAL_UNDIST_INV_INC_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/unrealizedUndistributedInvestmentIncomeBase | |||||
| unrealizedUndistributedInvestmentIncomeLocal | in_unreal_undist_inv_inc_b | TRADESDBO | TRADE_DETAIL | UNREAL_UNDIST_INV_INC_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/unrealizedUndistributedInvestmentIncomeLocal | |||||
| settleAmountBase | in_settle_amount_base | TRADESDBO | TRADE_DETAIL | SETTLE_AMOUNT_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseTrade/settleAmountBase | |||||
| 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. | |||||||||||
| 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 | |||||||