...
| title | Important Note |
|---|
...
| Info |
|---|
|
...
|
...
|
...
|
...
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
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. | |||||||||||
...
EnhanceCalcTransactionId parameter is not specified or set to N, starTag26 is not used for calculation |
...
EnhanceCalcTransactionId parameter is set to Y, |
...
starTag26 is used to resolve these elements | |||||||||||
calcTransactionId | string | 2983 | EagleML/warehouseTransaction/warehouseTrade/calcTransactionId | ||||||||
calcMasterTransactionId | string | 2984 | MASTER_TXN_ID | EagleML/warehouseTransaction/warehouseTrade/calcMasterTransactionId | |||||||
calcCancelTransactionId | string | 2985 | CXL_TARGET_ID | EagleML/warehouseTransaction/warehouseTrade/calcCancelTransactionId | |||||||