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