Important Note
- Warehouse Trade Data Map Table#netCash and Warehouse Trade Data Map Table#netAmountLocal are passed into the same DB field TRADESDBO.TRADE.NET_CASH. You should use either of these two nodes in your incoming message, but not both of them at the same time.
- Warehouse Trade Data Map Table#toCashType and Warehouse Trade Data Map Table#toCashEventType are passed into the same DB field TRADESDBO.TRADE.TO_CASH_TYPE. You should use either of these two nodes in your incoming message, but not both of them at the same time (if you try to load both, only toCashType will be processed).
- the SP is currently designed to load longShortIndicator and Warehouse Trade Data Map Table#starLsInd via the same SP parameter in_star_ls_ind. Therefore, these nodes are populated with the same value into DB.
- Warehouse Trade Data Map Table#costLocal and Warehouse Trade Data Map Table#openCostLocal, Warehouse Trade Data Map Table#costBase and Warehouse Trade Data Map Table#openCostBase are mapped via in_cost_local and in_cost_base SP parameters respectively (costLocal and costBase have a higher priority)
Fields denoted by * (supported in 2017R1) exist in the XML schema today. However, these fields are not supported yet by the underlying core stored procedure (TRD_EGL_GEN_INTERFACE) and therefore these fields will not be loaded/exported. The stored procedure will be updated in 2017R1 to include these additional fields.
| 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 | N | 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 | string | 944 | in_update_source | S | TRADESDBO | TRADE | UPDATE_SOURCE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/updateSource | |
| batchCollectErrorsFlag | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/batchCollectErrorsFlag | ||||||||
| singleRowCommitFlag | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/singleRowCommitFlag | ||||||||
| effectiveDate | date | 221 | in_effective_date | S | TRADESDBO | TRADE | EFFECTIVE_DATE | DATE | Y | EagleML/warehouseTransaction/warehouseTrade/effectiveDate | |
| Entity Common Id Model | EagleML/warehouseTransaction/warehouseTrade/ | ||||||||||
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehouseTrade/ | ||||||||||
| accountingBasis | string | 21 | in_acct_basis | S | TRADESDBO | TRADE | ACCT_BASIS | VARCHAR2(5) | N | EagleML/warehouseTransaction/warehouseTrade/accountingBasis | |
| entityIDLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/entityIDLookupSwitch | ||||||||
| entityNameLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/entityNameLookupSwitch | ||||||||
| securityQueryFlag | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/securityQueryFlag | ||||||||
| sourceLookupSwitch | LookupSwitchEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/sourceLookupSwitch | ||||||||
| procedureMode | ProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/procedureMode | ||||||||
| procedureFlag | ProcedureFlagTypeEnum | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/procedureFlag | ||||||||
| Asset Identifiers Model | EagleML/warehouseTransaction/warehouseTrade/ | ||||||||||
| Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/warehouseTrade/ | ||||||||||
| Extended CA Properties Model (extract only) | EagleML/warehouseTransaction/warehouseTrade/ | ||||||||||
| maturityDate | date | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/maturityDate | ||||||||
| brokerCode | string | 88 | in_broker_code | S | TRADESDBO | TRADE | BROKER_CODE | CHAR(12) | N | EagleML/warehouseTransaction/warehouseTrade/brokerCode | |
| clearingBrokerCode | string | 1237 | in_clearing_broker_code | S | TRADESDBO | TRADE_DETAIL | CLEARING_BROKER_CODE | CHAR(20) | N | EagleML/warehouseTransaction/warehouseTrade/clearingBrokerCode | |
| status | string | 54 | in_trade_status | S | TRADESDBO | TRADE | TRADE_STATUS | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/status | |
| taxAmountLocal | decimal | 46 | in_taxes | F | TRADESDBO | TRADE | TAXES | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/taxAmountLocal | |
| commissionAmount | decimal | 12019 | in_commission_amount | F | TRADESDBO | TRADE | COMMISSION_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/commissionAmount | |
| accruedInterest | decimal | 49 | in_accrued_interest | F | TRADESDBO | TRADE | ACCRUED_INTEREST | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/accruedInterest | |
| baseCurrency | CurrencyCode | 86 | in_base_currency | S | TRADESDBO | TRADE | BASE_CURRENCY | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehouseTrade/baseCurrency | |
| monthEndAccountingDate | date | 4733 | in_month_end_date | S | TRADESDBO | TRADE | MONTH_END_DATE | DATE | N | 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) | N | EagleML/warehouseTransaction/warehouseTrade/accruedInterestType | |
| accruedIncomeLocal | decimal | 10758 | in_accrued_income_local | F | TRADESDBO | TRADE | ACCRUED_INCOME_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/accruedIncomeLocal | |
| cancelAccountingDt | date | 12138 | in_cancel_acctg_date | S | TRADESDBO | TRADE_DETAIL | CANCEL_ACCTG_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/cancelAccountingDt | |
| cancelMthendAccountingDt | date | 12139 | in_cancel_me_acctg_date | S | TRADESDBO | TRADE_DETAIL | CANCEL_ME_ACCTG_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/cancelMthendAccountingDt | |
| cancelFlag | string | 10045 | in_cancel_flag | S | TRADESDBO | TRADE_DETAIL | CANCEL_FLAG | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/cancelFlag | |
| cancelStatus | string | 10046 | in_cancel_status | S | TRADESDBO | TRADE_DETAIL | CANCEL_STATUS | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/cancelStatus | |
| cancelEffectiveDt | date | 504 | in_cancel_effective_date | S | TRADESDBO | TRADE_DETAIL | CANCEL_EFFECTIVE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/cancelEffectiveDt | |
| cancelEventId | TransactionId | 501 | in_cancel_event_id | S | TRADESDBO | TRADE | CANCEL_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/cancelEventId | |
| cancelLinkEventId | TransactionId | 506 | in_cancel_linked_event_id | S | TRADESDBO | TRADE | CANCEL_LINKED_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/cancelLinkEventId | |
| currBuiltInGlSecurity | decimal | 9761 | in_curr_builtin_gl_sec | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_SEC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlSecurity | |
| currBuiltInGlCurrency | decimal | 10917 | in_curr_builtin_gl_currency | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_CURRENCY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlCurrency | |
| currBuiltInGlDeferred | decimal | 10918 | in_curr_builtin_gl_deferred | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_DEFERRED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlDeferred | |
| currBuiltInGlOid | decimal | 10919 | in_curr_builtin_gl_oid | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_OID | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlOid | |
| currBuiltInGlMktDisc | decimal | 10920 | in_curr_builtin_gl_mkt_disc | F | TRADESDBO | TRADE | CURR_BUILTIN_GL_MKT_DISC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/currBuiltInGlMktDisc | |
| gainCurrency | decimal | 10049 | in_currency_gain | F | TRADESDBO | TRADE_DETAIL | CURRENCY_GAIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/gainCurrency | |
| gainSecurityLocal | decimal | 10051 | in_security_gain | F | TRADESDBO | TRADE_DETAIL | SECURITY_GAIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/gainSecurityLocal | |
| totalGain | decimal | 10057 | in_total_gain | F | TRADESDBO | TRADE_DETAIL | TOTAL_GAIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/totalGain | |
| fromAccount | string | 351 | in_from_account | S | TRADESDBO | TRADE | FROM_ACCOUNT | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/fromAccount | |
| fromAssetid | integer | 352 | in_from_sec_alias | F | TRADESDBO | TRADE | FROM_SECURITY_ALIAS | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/fromAssetid | |
| fromLongShort | string | 355 | in_from_lng_short_ind | S | TRADESDBO | TRADE | FROM_LONG_SHORT_INDICATOR | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/fromLongShort | |
| fromSourceSystem | string | 361 | in_from_source_system | S | TRADESDBO | TRADE | FROM_SOURCE_SYSTEM | VARCHAR2(25) [v2015R2.x+] | N | 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) | N | EagleML/warehouseTransaction/warehouseTrade/fromCostBasisType | |
| fromWashSaleEligInd | string | 384 | in_from_wash_sale_ind | S | TRADESDBO | TRADE | FROM_WASH_SALE_ELGBL_IND | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/fromWashSaleEligInd | |
| lossCurrency | decimal | 10052 | in_currency_loss | F | TRADESDBO | TRADE_DETAIL | CURRENCY_LOSS | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/lossCurrency | |
| lossSecurityLocal | decimal | 10054 | in_security_loss | F | TRADESDBO | TRADE_DETAIL | SECURITY_LOSS | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/lossSecurityLocal | |
| totalLoss | decimal | 10058 | in_total_loss | F | TRADESDBO | TRADE_DETAIL | TOTAL_LOSS | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/totalLoss | |
| originalAcquisitionCostBase | decimal | 3746 | in_orig_acq_cost_base | F | TRADESDBO | TRADE | ORIG_ACQ_COST_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostBase | |
| originalAcquisitionCostLocal | decimal | 3747 | in_orig_acq_cost_local | F | TRADESDBO | TRADE | ORIG_ACQ_COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalAcquisitionCostLocal | |
| originalFaceValue | decimal | 109 | in_original_face_value | F | TRADESDBO | TRADE | ORIGINAL_FACE_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalFaceValue | |
| originalBuiltInGlMktDisc | decimal | 10915 | in_orig_builtin_gl_mkt_disc | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_MKT_DISC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlMktDisc | |
| originalTradePrice | decimal | 10906 | in_orig_trade_price | F | TRADESDBO | TRADE | ORIG_TRADE_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalTradePrice | |
| originalBuiltInGlCurrency | decimal | 10912 | in_orig_builtin_gl_currency | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_CURRENCY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlCurrency | |
| originalBuiltInGlDeferred | decimal | 10913 | in_orig_builtin_gl_deferred | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_DEFERRED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlDeferred | |
| originalBuiltInGlOid | decimal | 10914 | in_orig_builtin_gl_oid | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_OID | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlOid | |
| originalBuiltInGlSecurity | decimal | 9762 | in_orig_builtin_gl_sec | F | TRADESDBO | TRADE | ORIG_BUILTIN_GL_SEC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalBuiltInGlSecurity | |
| originalSettlementDate | date | 154 | in_orig_settlement_date | S | TRADESDBO | TRADE | ORIG_SETTLEMENT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/originalSettlementDate | |
| originalQuantity | decimal | 159 | in_par_or_shares | F | TRADESDBO | TRADE | PAR_OR_SHARES | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/originalQuantity | |
| openCostBase | decimal | 166 | in_cost_base | F | TRADESDBO | TRADE | COST_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/openCostBase | |
| openHldPerDate | date | 164 | in_holding_period_date | S | TRADESDBO | TRADE | HOLDING_PERIOD_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/openHldPerDate | |
| performanceFlow | decimal | 4597 | in_performance_value | F | TRADESDBO | TRADE_DETAIL | PERFORMANCE_VALUE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/performanceFlow | |
| performancePrice | decimal | 4598 | in_performance_price | F | TRADESDBO | TRADE_DETAIL | PERFORMANCE_PRICE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/performancePrice | |
| premiumLAllocated | decimal | 203 | in_premium_allocated_local | F | TRADESDBO | TRADE | PREMIUM_ALLOCATED_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/premiumLAllocated | |
| premiumBAllocated | decimal | 204 | in_premium_allocated | F | TRADESDBO | TRADE | PREMIUM_ALLOCATED | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/premiumBAllocated | |
| settlementAmount | decimal | 64 | in_settlement_amount | F | TRADESDBO | TRADE | SETTLEMENT_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/settlementAmount | |
| toAccount | string | 301 | in_to_account | S | TRADESDBO | TRADE | TO_ACCOUNT | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/toAccount | |
| toAssetid | integer | 302 | in_to_sec_alias | F | TRADESDBO | TRADE | TO_SECURITY_ALIAS | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/toAssetid | |
| toLongShort | string | 305 | in_to_lng_short_ind | S | TRADESDBO | TRADE | TO_LONG_SHORT_INDICATOR | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/toLongShort | |
| toSourceSystem | string | 311 | in_to_source_system | S | TRADESDBO | TRADE | TO_SOURCE_SYSTEM | VARCHAR2(25) [v2015R2.x+] | N | 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) | N | EagleML/warehouseTransaction/warehouseTrade/toCostBasisType | |
| toCashEventType | string | 328 | in_to_cash_type | S | TRADESDBO | TRADE | TO_CASH_TYPE | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/toCashEventType | |
| toWashSaleEligInd | string | 334 | in_to_wash_sale_ind | S | TRADESDBO | TRADE | TO_WASH_SALE_ELGBL_IND | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/toWashSaleEligInd | |
| userChar1 | string | 1887 | in_user_char1 | S | TRADESDBO | TRADE | USER_CHAR1 | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/userChar1 | |
| userChar2 | string | 1888 | in_user_char2 | S | TRADESDBO | TRADE | USER_CHAR2 | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/userChar2 | |
| userChar3 | string | 1889 | in_user_char3 | S | TRADESDBO | TRADE | USER_CHAR3 | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/userChar3 | |
| userDefinedFloat1 | decimal | 1890 | in_user_float1 | F | TRADESDBO | TRADE | USER_FLOAT1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat1 | |
| userDefinedFloat2 | decimal | 1891 | in_user_float2 | F | TRADESDBO | TRADE | USER_FLOAT2 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat2 | |
| userDefinedFloat3 | decimal | 1892 | in_user_float3 | F | TRADESDBO | TRADE | USER_FLOAT3 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/userDefinedFloat3 | |
| costMethod | string | 22 | in_cost_method | S | TRADESDBO | TRADE | COST_METHOD | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/costMethod | |
| lotSelectionMethod | string | 27 | in_lot_selection_method | S | TRADESDBO | TRADE | LOT_SELECTION_METHOD | VARCHAR2(8) | N | EagleML/warehouseTransaction/warehouseTrade/lotSelectionMethod | |
| transactionCode | string | 2283 | in_trans_code | S | TRADESDBO | TRADE | TRANS_CODE | CHAR(55) | N | EagleML/warehouseTransaction/warehouseTrade/transactionCode | |
| factor | decimal | 91 | in_factor | F | TRADESDBO | TRADE | FACTOR | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/factor | |
| netAmountLocal | decimal | 50 | in_net_cash | F | TRADESDBO | TRADE | NET_CASH | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/netAmountLocal | |
| netAmountBase | decimal | 478 | in_trade_base_amount | F | TRADESDBO | TRADE | TRADE_BASE_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/netAmountBase | |
| principalB | decimal | 169 | in_principal_base | F | TRADESDBO | TRADE | PRINCIPAL_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/principalB | |
| quantityPre | decimal | 410 | in_target_quantity | F | TRADESDBO | TRADE | TARGET_QUANTITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/quantityPre | |
| tradeYield | decimal | 9430 | in_trade_yield | F | TRADESDBO | TRADE | TRADE_YIELD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/tradeYield | |
| dirtyPrincipalLocal | decimal | 10781 | in_dirty_principal | F | TRADESDBO | TRADE | DIRTY_PRINCIPAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalLocal | |
| dirtyPrincipalBase | decimal | 10782 | in_dirty_principal_base | F | TRADESDBO | TRADE | DIRTY_PRINCIPAL_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/dirtyPrincipalBase | |
| estimateVsFinal | string | 768 | in_est_vs_act | S | TRADESDBO | TRADE | EST_VS_ACT | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehouseTrade/estimateVsFinal | |
| reportingReplayInd | string | 10674 | in_replay_ind | S | TRADESDBO | TRADE | REPLAY_IND | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/reportingReplayInd | |
| cashEventType | string | 53 | in_cash_type | S | TRADESDBO | TRADE_DETAIL | CASH_TYPE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/cashEventType | |
| transactionNotes | string | 56 | in_transaction_notes | S | TRADESDBO | TRADE_DETAIL | TRANSACTION_NOTES | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/transactionNotes | |
| partflag | string | 3924 | in_partflag | S | TRADESDBO | TRADE_DETAIL | PARTFLAG | CHAR(1) | N | EagleML/warehouseTransaction/warehouseTrade/partflag | |
| scrubType | string | 3717 | in_scrub_type | S | TRADESDBO | TRADE | SCRUB_TYPE | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/scrubType | |
| glAccount | string | 4519 | in_general_ledger_acct | S | TRADESDBO | TRADE_DETAIL | GENERAL_LEDGER_ACCT | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/glAccount | |
| custodianBank | string | not stored in DB | N | EagleML/warehouseTransaction/warehouseTrade/custodianBank | |||||||
| custodianBankCode | string | 1240 | in_custody_bank_code | S | TRADESDBO | TRADE | CUSTODY_BANK_CODE | CHAR(20) | N | EagleML/warehouseTransaction/warehouseTrade/custodianBankCode | |
| custodyBankAccountNum | string | 1660 | in_custody_bank_acct_num | S | TRADESDBO | TRADE | CUSTODY_BANK_ACCT_NUM | VARCHAR2(15) | N | EagleML/warehouseTransaction/warehouseTrade/custodyBankAccountNum | |
| custodyBankSubAccount | string | 1661 | in_custody_bank_sub_acct | S | TRADESDBO | TRADE | CUSTODY_BANK_SUB_ACCT | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/custodyBankSubAccount | |
| corporateActionType | string | 1728 | in_corp_action_type | S | TRADESDBO | TRADE | CORP_ACTION_TYPE | VARCHAR2(55) | N | EagleML/warehouseTransaction/warehouseTrade/corporateActionType | |
| cashEventSpawned | string | 751 | in_cash_event_spawned | S | TRADESDBO | TRADE | CASH_EVENT_SPAWNED | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/cashEventSpawned | |
| bankAlias | integer | 1864 | in_bank_alias | S | TRADESDBO | TRADE | BANK_ALIAS | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/bankAlias | |
| changedflag | string | 10705 | in_changedflag | S | TRADESDBO | TRADE_DETAIL | CHANGEDFLAG | CHAR(1) | N | EagleML/warehouseTransaction/warehouseTrade/changedflag | |
| eventId | TransactionId | 25 | in_star_tag25 | S | TRADESDBO | TRADE | STAR_TAG25 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/eventId | |
| corporateActionInstance | integer | 4268 | in_corporate_action_inst | S | TRADESDBO | TRADE_DETAIL | CORPORATE_ACTION_INST | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/corporateActionInstance | |
| eventIdSwitch | TransactionId | TRADESDBO | TRADE | TRANSACTION_ID | N | EagleML/warehouseTransaction/warehouseTrade/eventIdSwitch | |||||
| sellToBuyFXRate | decimal | 7 | in_sell_to_buy_fx_rate | F | TRADESDBO | TRADE | SELL_TO_BUY_FX_RATE | NUMBER(28,12) | N | 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) | N | 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 | N | EagleML/warehouseTransaction/warehouseTrade/acqTransNumber | |
| postType | string | 12197 | in_post_type | S | TRADESDBO | TRADE_DETAIL | POST_TYPE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/postType | |
| tradeMemo1 | 12236 | in_trade_memo1 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO1 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/tradeMemo1 | ||
| tradeMemo2 | string | 12237 | in_trade_memo2 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO2 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/tradeMemo2 | |
| fxRate | decimal | 87 | in_fx_rate | F | TRADESDBO | TRADE | FX_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/fxRate | |
| checkedDate | dateTime | 12141 | in_checkeddate | S | TRADESDBO | TRADE_DETAIL | CHECKEDDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/checkedDate | |
| accountingDesignation | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/accountingDesignation | ||||||||
| brokerReason | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/brokerReason | ||||||||
| instructedDate | dateTime | 12143 | in_instructeddate | S | TRADESDBO | TRADE_DETAIL | INSTRUCTEDDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/instructedDate | |
| dispInterestReceived | decimal | 12318 | in_disp_interest_received | F | TRADESDBO | TRADE_DETAIL | DISP_INTEREST_RECEIVED | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/dispInterestReceived | |
| userWhoApprovedTrade | string | 12262 | in_user_who_approved_trade | S | TRADESDBO | TRADE_DETAIL | USER_WHO_APPROVED_TRADE | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehouseTrade/userWhoApprovedTrade | |
| otherFundNumber | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/otherFundNumber | ||||||||
| prepaySpeed | decimal | 7315 | in_prepay_speed_contract_size | F | TRADESDBO | TRADE_DETAIL | PREPAY_SPEED_CONTRACT_SIZE | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/prepaySpeed | |
| prepayType | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/prepayType | ||||||||
| settlementExchangeRate | decimal | 79 | in_settlement_exchange_rate | F | TRADESDBO | TRADE | SETTLEMENT_EXCHANGE_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/settlementExchangeRate | |
| touchCount | integer | 13688 | in_transeq | F | TRADESDBO | TRADE_DETAIL | TRANSEQ | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/touchCount | |
| secTranType | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/secTranType | ||||||||
| authorizedDate | dateTime | 12137 | in_authorizeddate | S | TRADESDBO | TRADE_DETAIL | AUTHORIZEDDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/authorizedDate | |
| localCommissionAmount | decimal | 47 | in_local_commission_amount | F | TRADESDBO | TRADE | LOCAL_COMMISSION_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/localCommissionAmount | |
| salesPerson | string | 12098 | in_sales_person | S | TRADESDBO | TRADE | SALES_PERSON | CHAR(18) | N | EagleML/warehouseTransaction/warehouseTrade/salesPerson | |
| convexity | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/convexity | ||||||||
| broker | string | 12126 | in_broker | S | TRADESDBO | TRADE_DETAIL | BROKER | CHAR(50) | N | EagleML/warehouseTransaction/warehouseTrade/broker | |
| settlementCurrency | string | 63 | in_settlement_currency | S | TRADESDBO | TRADE | SETTLEMENT_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/settlementCurrency | |
| discountRate | decimal | 12039 | in_discount_rate | F | TRADESDBO | TRADE | DISCOUNT_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/discountRate | |
| duration | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/duration | ||||||||
| comments1 | string | 12133 | in_comments1 | S | TRADESDBO | TRADE_DETAIL | COMMENTS1 | CHAR(30) | N | EagleML/warehouseTransaction/warehouseTrade/comments1 | |
| modifiedBy | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/modifiedBy | ||||||||
| price | decimal | 160 | in_price | F | TRADESDBO | TRADE | PRICE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/price | |
| pricingIndex | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/pricingIndex | ||||||||
| pricingSpread | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/pricingSpread | ||||||||
| principal | decimal | 165 | in_tdprincipal | F | TRADESDBO | TRADE | PRINCIPAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/principal | |
| comments | string | 12132 | in_comments | S | TRADESDBO | TRADE_DETAIL | COMMENTS | CHAR(30) | N | EagleML/warehouseTransaction/warehouseTrade/comments | |
| prepared | string | 12199 | in_prepared | S | TRADESDBO | TRADE_DETAIL | PREPARED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/prepared | |
| preparedDate | dateTime | 12194 | in_prepareddate | S | TRADESDBO | TRADE_DETAIL | PREPAREDDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/preparedDate | |
| settlementLocation | string | 43 | in_settlement_location | S | TRADESDBO | TRADE | SETTLEMENT_LOCATION | CHAR(12) | N | EagleML/warehouseTransaction/warehouseTrade/settlementLocation | |
| trader | string | 12115 | in_trader | S | TRADESDBO | TRADE | TRADER | CHAR(30) | N | EagleML/warehouseTransaction/warehouseTrade/trader | |
| yield | decimal | 75 | in_yield | F | TRADESDBO | TRADE | YIELD | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/yield | |
| blockTradeId | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/blockTradeId | ||||||||
| fromQuantity | decimal | 366 | in_from_quantity | F | TRADESDBO | TRADE | FROM_QUANTITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/fromQuantity | |
| sellToBaseFxRate | decimal | 12149 | in_sell_to_base_fx_rate | F | TRADESDBO | TRADE | SELL_TO_BASE_FX_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/sellToBaseFxRate | |
| toQuantity | decimal | 316 | in_to_quantity | F | TRADESDBO | TRADE | TO_QUANTITY | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/toQuantity | |
| toAmountLocal | decimal | 327 | in_to_amount_local | F | TRADESDBO | TRADE | TO_AMOUNT_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/toAmountLocal | |
| toCashType | string | 328 | in_to_cash_type | S | TRADESDBO | TRADE | TO_CASH_TYPE | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/toCashType | |
| fromAmountLocal | decimal | 377 | in_from_amount_local | F | TRADESDBO | TRADE | FROM_AMOUNT_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/fromAmountLocal | |
| fromCashType | string | 378 | in_from_cash_type | S | TRADESDBO | TRADE | FROM_CASH_TYPE | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/fromCashType | |
| novationType | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/novationType | ||||||||
| derivTranType | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/derivTranType | ||||||||
| currentWAL | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/currentWAL | ||||||||
| purchaseType | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/purchaseType | ||||||||
| embeddedDerivPrice | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/embeddedDerivPrice | ||||||||
| assetLiabilityHedgeFlag | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/assetLiabilityHedgeFlag | ||||||||
| currentWAC | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/currentWAC | ||||||||
| currentWAM | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/currentWAM | ||||||||
| hedgeTaxStatus | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/hedgeTaxStatus | ||||||||
| hedgeDesigCds | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/hedgeDesigCds | ||||||||
| settlementInstructions1 | string | 1897 | in_settlement_instructions1 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS1 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settlementInstructions1 | |
| settlementInstructions2 | string | 12224 | in_settlement_instructions2 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS2 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settlementInstructions2 | |
| settlementInstructions3 | string | 12225 | in_settlement_instructions3 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS3 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settlementInstructions3 | |
| settlementInstructions4 | string | 12227 | in_settlement_instructions4 | S | TRADESDBO | TRADE_DETAIL | SETTLEMENT_INSTRUCTIONS4 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settlementInstructions4 | |
| strategy | string | 12105 | in_strategy_id | S | TRADESDBO | TRADE | STRATEGY_ID | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehouseTrade/strategy | |
| executionType | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/executionType | ||||||||
| origEntryDate | date | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/origEntryDate | ||||||||
| settlementDate | date | 37 | in_settlement_date | S | TRADESDBO | TRADE | SETTLEMENT_DATE | DATE | N | 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) | N | 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 | N | EagleML/warehouseTransaction/warehouseTrade/postDate | |
| conterpartyCode | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/conterpartyCode | ||||||||
| tradeCoupon | decimal | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/tradeCoupon | ||||||||
| factorDate | date | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/factorDate | ||||||||
| longShortIndicator | LongShortIndicatorEnum | in_star_ls_ind | TRADESDBO | TRADE_DETAIL | LONG_SHORT_INDICATOR | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/longShortIndicator | |||
| custodianBankDesc | string | 1146 | in_custody_bank_desc | S | TRADESDBO | TRADE | CUSTODY_BANK_DESC | CHAR(50) | N | EagleML/warehouseTransaction/warehouseTrade/custodianBankDesc | |
| openCostLocal | decimal | 162 | in_cost_local | F | TRADESDBO | TRADE | COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/openCostLocal | |
| tradeAmount | decimal | 190 | in_trade_amount | F | TRADESDBO | TRADE | TRADE_AMOUNT | NUMBER(28,12) | N | 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) | N | EagleML/warehouseTransaction/warehouseTrade/clientId | |
| covFlag | YesNoOptionEnum | 12135 | in_cov_flag | S | TRADESDBO | TRADE_DETAIL | COV_FLAG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/covFlag | |
| eventSubPriority | integer | 12042 | in_event_sub_priority | F | TRADESDBO | TRADE | EVENT_SUB_PRIORITY | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseTrade/eventSubPriority | |
| ioIssuerAlias | string | 12183 | in_io_issuer_alias | S | TRADESDBO | TRADE_DETAIL | IO_ISSUER_ALIAS | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/ioIssuerAlias | |
| ioIssuerId | string | 12184 | in_io_issuer_id | S | TRADESDBO | TRADE_DETAIL | IO_ISSUER_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/ioIssuerId | |
| origAcctDate | date | 12036 | in_orig_acct_date | S | TRADESDBO | TRADE | ORIG_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/origAcctDate | |
| origMonthlyAcctDate | date | 12102 | in_orig_monthly_acct_date | S | TRADESDBO | TRADE | ORIG_MONTHLY_ACCT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/origMonthlyAcctDate | |
| pendingTradeId | integer | 12088 | in_pending_trade_id | F | TRADESDBO | TRADE | PENDING_TRADE_ID | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseTrade/pendingTradeId | |
| qtyWashSaleEligible | decimal | 12111 | in_qty_wash_sale_eligible | F | TRADESDBO | TRADE | QTY_WASH_SALE_ELIGIBLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/qtyWashSaleEligible | |
| washSaleEligibleInd | string | 12120 | in_wash_sale_eligible_indicator | S | TRADESDBO | TRADE | WASH_SALE_ELIGIBLE_INDICATOR | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/washSaleEligibleInd | |
| aiaNetB | decimal | 12252 | in_aia_net_b | F | TRADESDBO | TRADE_DETAIL | AIA_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/aiaNetB | |
| aiaNetL | decimal | 12253 | in_aia_net_l | F | TRADESDBO | TRADE_DETAIL | AIA_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/aiaNetL | |
| buySellFlag | normalizedString | 12006 | in_buy_sell_flag | S | TRADESDBO | TRADE | BUY_SELL_FLAG | CHAR(4) | N | EagleML/warehouseTransaction/warehouseTrade/buySellFlag | |
| bookValue | decimal | 4602 | in_book_value | F | TRADESDBO | TRADE_DETAIL | BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/bookValue | |
| bookValueLocal | decimal | 4601 | in_book_value_local | F | TRADESDBO | TRADE_DETAIL | BOOK_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/bookValueLocal | |
| cpNetB | decimal | 12306 | in_cp_net_b | F | TRADESDBO | TRADE_DETAIL | CP_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/cpNetB | |
| cpNetL | decimal | 12307 | in_cp_net_l | F | TRADESDBO | TRADE_DETAIL | CP_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/cpNetL | |
| creditLossB | decimal | 12308 | in_credit_loss_b | F | TRADESDBO | TRADE_DETAIL | CREDIT_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/creditLossB | |
| creditLossL | decimal | 12310 | in_credit_loss_l | F | TRADESDBO | TRADE_DETAIL | CREDIT_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/creditLossL | |
| costBasisType | string | 24 | in_cost_basis_type | S | TRADESDBO | TRADE | COST_BASIS_TYPE | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/costBasisType | |
| futureFeeNetB | decimal | 12352 | in_future_fee_net_b | F | TRADESDBO | TRADE_DETAIL | FUTURE_FEE_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/futureFeeNetB | |
| futureFeeNetL | decimal | 12356 | in_future_fee_net_l | F | TRADESDBO | TRADE_DETAIL | FUTURE_FEE_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/futureFeeNetL | |
| impairmentLtdBase | decimal | 13035 | in_impairment_ltd_base | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_LTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentLtdBase | |
| impairmentLtdLocal | decimal | 13036 | in_impairment_ltd_local | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocal | |
| mbaNetB | decimal | 13656 | in_mba_net_b | F | TRADESDBO | TRADE_DETAIL | MBA_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/mbaNetB | |
| mbaNetL | decimal | 13657 | in_mba_net_l | F | TRADESDBO | TRADE_DETAIL | MBA_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/mbaNetL | |
| naiaNetB | decimal | 13658 | in_naia_net_b | F | TRADESDBO | TRADE_DETAIL | NAIA_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/naiaNetB | |
| naiaNetL | decimal | 13659 | in_naia_net_l | F | TRADESDBO | TRADE_DETAIL | NAIA_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/naiaNetL | |
| nonCreditLossB | decimal | 13661 | in_non_credit_loss_b | F | TRADESDBO | TRADE_DETAIL | NON_CREDIT_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/nonCreditLossB | |
| nonCreditLossL | decimal | 13662 | in_non_credit_loss_l | F | TRADESDBO | TRADE_DETAIL | NON_CREDIT_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/nonCreditLossL | |
| bookCost | Optional | decimal | 12285 | in_book_cost | F | TRADESDBO | TRADE_DETAIL | BOOK_COST | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/bookCost |
| cashCategory | Optional | string | 12128 | in_cash_category | S | TRADESDBO | TRADE_DETAIL | CASH_CATEGORY | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/cashCategory |
| cancelType | string | 12127 | in_cancel_type | S | TRADESDBO | TRADE_DETAIL | CANCEL_TYPE | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/cancelType | |
| exchangeFeeBase | decimal | 13970 | in_exchange_fee_base | F | TRADESDBO | TRADE | EXCHANGE_FEE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/exchangeFeeBase | |
| federalTaxWithholdBase | decimal | 13969 | in_federal_tax_withhold_base | F | TRADESDBO | TRADE | FEDERAL_TAX_WITHHOLD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/federalTaxWithholdBase | |
| mttype | string | 13280 | in_mttype | S | TRADESDBO | TRADE | MTTYPE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/mttype | |
| netCash | decimal | 50 | in_net_cash | F | TRADESDBO | TRADE | NET_CASH | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/netCash | |
| origAcqDate | date | 216 | in_orig_acq_date | S | TRADESDBO | TRADE | ORIG_ACQ_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/origAcqDate | |
| positionId | integer | 12092 | in_position_id | F | TRADESDBO | TRADE | POSITION_ID | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseTrade/positionId | |
| scrubId | integer | 12147 | in_scrub_id | F | TRADESDBO | TRADE | SCRUB_ID | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/scrubId | |
| secFeesBase | decimal | 12148 | in_sec_fees_base | F | TRADESDBO | TRADE | SEC_FEES_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/secFeesBase | |
| termLoanFeeExpB | decimal | 12155 | in_term_loan_fee_exp_b | F | TRADESDBO | TRADE | TERM_LOAN_FEE_EXP_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpB | |
| termLoanFeeExpL | decimal | 12156 | in_term_loan_fee_exp_l | F | TRADESDBO | TRADE | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/termLoanFeeExpL | |
| termLoanFeeIncB | decimal | 12157 | in_term_loan_fee_inc_b | F | TRADESDBO | TRADE | TERM_LOAN_FEE_INC_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncB | |
| termLoanFeeIncL | decimal | 12158 | in_term_loan_fee_inc_l | F | TRADESDBO | TRADE | TERM_LOAN_FEE_INC_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/termLoanFeeIncL | |
| targetEventId | TransactionId | 26 | in_target_event_id | S | TRADESDBO | TRADE | TARGET_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/targetEventId | |
| updateUserId | string | 12119 | in_update_user_id | S | TRADESDBO | TRADE | UPDATE_USER_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/updateUserId | |
| updateSwitch | string | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/updateSwitch | ||||||||
| accruedInterestOverride | string | 12121 | in_accrued_interest_override | S | TRADESDBO | TRADE_DETAIL | ACCRUED_INTEREST_OVERRIDE | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehouseTrade/accruedInterestOverride | |
| acquisitionType | string | 12122 | in_acquisition_type | S | TRADESDBO | TRADE_DETAIL | ACQUISITION_TYPE | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/acquisitionType | |
| amortizedCostPrevBase | decimal | 12255 | in_amortized_cost_prev_b | F | TRADESDBO | TRADE_DETAIL | AMORTIZED_COST_PREV_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevBase | |
| amortizedCostPrevLocal | decimal | 12278 | in_amortized_cost_prev_l | F | TRADESDBO | TRADE_DETAIL | AMORTIZED_COST_PREV_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/amortizedCostPrevLocal | |
| alluprate | decimal | 12254 | in_alluprate | F | TRADESDBO | TRADE_DETAIL | ALLUPRATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/alluprate | |
| asOfTradeTime | string | 12123 | in_as_of_trade_time | S | TRADESDBO | TRADE_DETAIL | AS_OF_TRADE_TIME | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/asOfTradeTime | |
| authorized | string | 12124 | in_authorized | S | TRADESDBO | TRADE_DETAIL | AUTHORIZED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/authorized | |
| autoexTradeFlag | YesNoOptionEnum | 12125 | in_autoex_trade_flag | S | TRADESDBO | TRADE_DETAIL | AUTOEX_TRADE_FLAG | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehouseTrade/autoexTradeFlag | |
| baseCommissionAmount | decimal | 12009 | in_base_commission_amount | F | TRADESDBO | TRADE | BASE_COMMISSION_AMOUNT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/baseCommissionAmount | |
| batchInstance | integer | 126 | in_batch_instance | S | TRADESDBO | TRADE | BATCH_INSTANCE | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/batchInstance | |
| balance | decimal | 12279 | in_balance | F | TRADESDBO | TRADE_DETAIL | BALANCE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/balance | |
| bnchYld1 | decimal | 12280 | in_bnch_yld1 | F | TRADESDBO | TRADE_DETAIL | BNCH_YLD1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/bnchYld1 | |
| bnchYld2 | decimal | 12281 | in_bnch_yld2 | F | TRADESDBO | TRADE_DETAIL | BNCH_YLD2 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/bnchYld2 | |
| bloombergProduct | string | 12008 | in_bloomberg_product | S | TRADESDBO | TRADE | BLOOMBERG_PRODUCT | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/bloombergProduct | |
| buyToBaseFxRate | decimal | 12014 | in_buy_to_base_fx_rate | F | TRADESDBO | TRADE | BUY_TO_BASE_FX_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/buyToBaseFxRate | |
| calcYieldIntIndicator | integer | 12015 | in_calc_yield_int_indicator | F | TRADESDBO | TRADE | CALC_YIELD_INT_INDICATOR | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/calcYieldIntIndicator | |
| cancelDueToCorrection | string | 12021 | in_cancel_due_to_correction | S | TRADESDBO | TRADE | CANCEL_DUE_TO_CORRECTION | CHAR(4) | N | EagleML/warehouseTransaction/warehouseTrade/cancelDueToCorrection | |
| cashflowdate | date | 12140 | in_cashflowdate | S | TRADESDBO | TRADE_DETAIL | CASHFLOWDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/cashflowdate | |
| checked | string | 12129 | in_checked | S | TRADESDBO | TRADE_DETAIL | CHECKED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/checked | |
| clearingBroker | string | 1230 | in_clearing_broker | S | TRADESDBO | TRADE_DETAIL | CLEARING_BROKER | CHAR(50) | N | EagleML/warehouseTransaction/warehouseTrade/clearingBroker | |
| closeoutpl0 | decimal | 12288 | in_closeoutpl0 | F | TRADESDBO | TRADE_DETAIL | CLOSEOUTPL0 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/closeoutpl0 | |
| closeoutpl1 | decimal | 12292 | in_closeoutpl1 | F | TRADESDBO | TRADE_DETAIL | CLOSEOUTPL1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/closeoutpl1 | |
| commentType | string | 12131 | in_comment_type | S | TRADESDBO | TRADE_DETAIL | COMMENT_TYPE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/commentType | |
| compared | string | 12134 | in_compared | S | TRADESDBO | TRADE_DETAIL | COMPARED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/compared | |
| compareddate | date | 12142 | in_compareddate | S | TRADESDBO | TRADE_DETAIL | COMPAREDDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/compareddate | |
| costPrevBase | decimal | 12295 | in_cost_prev_base | F | TRADESDBO | TRADE_DETAIL | COST_PREV_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/costPrevBase | |
| costPrevLocal | decimal | 12296 | in_cost_prev_local | F | TRADESDBO | TRADE_DETAIL | COST_PREV_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/costPrevLocal | |
| cleanPrice | decimal | 12018 | in_clean_price | F | TRADESDBO | TRADE | CLEAN_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/cleanPrice | |
| commissionCode | string | 12023 | in_commission_code | S | TRADESDBO | TRADE | COMMISSION_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/commissionCode | |
| commissionReasonCode | string | 12024 | in_commission_reason_code | S | TRADESDBO | TRADE | COMMISSION_REASON_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/commissionReasonCode | |
| commissionTypeCode | string | 78 | in_commission_type_code | S | TRADESDBO | TRADE | COMMISSION_TYPE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/commissionTypeCode | |
| customerAcctNumb | string | 12025 | in_customer_acct_numb | S | TRADESDBO | TRADE | CUSTOMER_ACCT_NUMB | CHAR(30) | N | EagleML/warehouseTransaction/warehouseTrade/customerAcctNumb | |
| dispBookValueGaap | decimal | 3766 | in_disp_book_value_gaap | F | TRADESDBO | TRADE_DETAIL | DISP_BOOK_VALUE_GAAP | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/dispBookValueGaap | |
| dispBookValueStat | decimal | 3767 | in_disp_book_value_stat | F | TRADESDBO | TRADE_DETAIL | DISP_BOOK_VALUE_STAT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/dispBookValueStat | |
| disallowGainB | decimal | 12311 | in_disallow_gain_b | F | TRADESDBO | TRADE_DETAIL | DISALLOW_GAIN_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/disallowGainB | |
| disallowGainL | decimal | 12312 | in_disallow_gain_l | F | TRADESDBO | TRADE_DETAIL | DISALLOW_GAIN_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/disallowGainL | |
| disallowLossB | decimal | 12314 | in_disallow_loss_b | F | TRADESDBO | TRADE_DETAIL | DISALLOW_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/disallowLossB | |
| disallowLossL | decimal | 12315 | in_disallow_loss_l | F | TRADESDBO | TRADE_DETAIL | DISALLOW_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/disallowLossL | |
| dispAccruedIncome | decimal | 12316 | in_disp_accrued_income | F | TRADESDBO | TRADE_DETAIL | DISP_ACCRUED_INCOME | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/dispAccruedIncome | |
| electedShareAmt | decimal | 12326 | in_elected_share_amt | F | TRADESDBO | TRADE_DETAIL | ELECTED_SHARE_AMT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/electedShareAmt | |
| electedSharePerc | decimal | 12328 | in_elected_share_perc | F | TRADESDBO | TRADE_DETAIL | ELECTED_SHARE_PERC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/electedSharePerc | |
| exchangeCodeTrd | string | 12176 | in_exchange_code_trd | S | TRADESDBO | TRADE_DETAIL | EXCHANGE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/exchangeCodeTrd | |
| exchangeCurrency | string | 12177 | in_exchange_currency | S | TRADESDBO | TRADE_DETAIL | EXCHANGE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/exchangeCurrency | |
| exchangeTypeCode | string | 12178 | in_exchange_type_code | S | TRADESDBO | TRADE_DETAIL | EXCHANGE_TYPE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/exchangeTypeCode | |
| exchangeCode | string | 17 | in_exchange_code | S | TRADESDBO | TRADE | EXCHANGE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/exchangeCode | |
| exchangeFee | decimal | 48 | in_exchange_fee | F | TRADESDBO | TRADE | EXCHANGE_FEE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/exchangeFee | |
| fairMarketValueBase | decimal | 12337 | in_fair_market_value_base | F | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/fairMarketValueBase | |
| fairMarketValueFlag | string | 12179 | in_fair_market_value_flag | S | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_FLAG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/fairMarketValueFlag | |
| fairMarketValueLocal | decimal | 12342 | in_fair_market_value_local | F | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/fairMarketValueLocal | |
| fairMarketValuePrice | decimal | 12343 | in_fair_market_value_price | F | TRADESDBO | TRADE_DETAIL | FAIR_MARKET_VALUE_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/fairMarketValuePrice | |
| feeamt | decimal | 12344 | in_feeamt | F | TRADESDBO | TRADE_DETAIL | FEEAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/feeamt | |
| feerate | decimal | 12351 | in_feerate | F | TRADESDBO | TRADE_DETAIL | FEERATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/feerate | |
| fromEffectiveDate | date | 12005 | in_from_effective_date | S | TRADESDBO | TRADE | FROM_EFFECTIVE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/fromEffectiveDate | |
| fwdCleanPrice | decimal | 13968 | in_fwd_clean_price | F | TRADESDBO | TRADE | FWD_CLEAN_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/fwdCleanPrice | |
| gaapRealizedGl | decimal | 12358 | in_gaap_realized_gl | F | TRADESDBO | TRADE_DETAIL | GAAP_REALIZED_GL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/gaapRealizedGl | |
| gaapSecType | string | 12180 | in_gaap_sec_type | S | TRADESDBO | TRADE_DETAIL | GAAP_SEC_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehouseTrade/gaapSecType | |
| goodMillionNum | integer | 12361 | in_good_million_num | F | TRADESDBO | TRADE_DETAIL | GOOD_MILLION_NUM | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/goodMillionNum | |
| haircutFlag | YesNoOptionEnum | 12071 | in_haircut_flag | S | TRADESDBO | TRADE | HAIRCUT_FLAG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/haircutFlag | |
| haircutPct | decimal | 13967 | in_haircut_pct | F | TRADESDBO | TRADE | HAIRCUT_PCT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/haircutPct | |
| holdTradeStatus | string | 12072 | in_hold_trade_status | S | TRADESDBO | TRADE | HOLD_TRADE_STATUS | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/holdTradeStatus | |
| identifier2 | string | 12181 | in_identifier2 | S | TRADESDBO | TRADE_DETAIL | IDENTIFIER2 | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/identifier2 | |
| impairmentAmortOffsetB | decimal | 12362 | in_impairment_amort_offset_b | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_AMORT_OFFSET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetB | |
| impairmentAmortOffsetL | decimal | 12363 | in_impairment_amort_offset_l | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_AMORT_OFFSET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentAmortOffsetL | |
| impairmentCostOffsetB | decimal | 12368 | in_impairment_cost_offset_b | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_OFFSET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetB | |
| impairmentCostOffsetL | decimal | 12370 | in_impairment_cost_offset_l | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_OFFSET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentCostOffsetL | |
| impairmentCostPrevB | decimal | 12383 | in_impairment_cost_prev_b | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_PREV_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevB | |
| impairmentCostPrevL | decimal | 12384 | in_impairment_cost_prev_l | F | TRADESDBO | TRADE_DETAIL | IMPAIRMENT_COST_PREV_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/impairmentCostPrevL | |
| inceptionamt | decimal | 13651 | in_inceptionamt | F | TRADESDBO | TRADE_DETAIL | INCEPTIONAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/inceptionamt | |
| instructed | string | 12182 | in_instructed | S | TRADESDBO | TRADE_DETAIL | INSTRUCTED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/instructed | |
| interest | decimal | 13652 | in_interest | F | TRADESDBO | TRADE_DETAIL | INTEREST | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/interest | |
| invertFlag | YesNoOptionEnum | 12073 | in_invert_flag | S | TRADESDBO | TRADE | INVERT_FLAG | CHAR(4) | N | EagleML/warehouseTransaction/warehouseTrade/invertFlag | |
| interestadj | decimal | 13653 | in_interestadj | F | TRADESDBO | TRADE_DETAIL | INTERESTADJ | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/interestadj | |
| interestAdjBase | decimal | 475 | in_baseinterestadj | F | TRADESDBO | TRADE_DETAIL | BASEINTERESTADJ | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/interestAdjBase | |
| ledgerEffectiveDate | date | 36 | in_ledger_effective_date | S | TRADESDBO | TRADE | LEDGER_EFFECTIVE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/ledgerEffectiveDate | |
| ledgerDate | date | 12144 | in_ledger_date | S | TRADESDBO | TRADE_DETAIL | LEDGER_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/ledgerDate | |
| letterconfirm | string | 12185 | in_letterconfirm | S | TRADESDBO | TRADE_DETAIL | LETTERCONFIRM | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/letterconfirm | |
| lettered | string | 12186 | in_lettered | S | TRADESDBO | TRADE_DETAIL | LETTERED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/lettered | |
| lettereddate | date | 12145 | in_lettereddate | S | TRADESDBO | TRADE_DETAIL | LETTEREDDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/lettereddate | |
| lmtGlElg | string | 12187 | in_lmt_gl_elg | S | TRADESDBO | TRADE_DETAIL | LMT_GL_ELG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/lmtGlElg | |
| lmtGlInd | string | 12188 | in_lmt_gl_ind | S | TRADESDBO | TRADE_DETAIL | LMT_GL_IND | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/lmtGlInd | |
| margin | decimal | 13654 | in_margin | F | TRADESDBO | TRADE_DETAIL | MARGIN | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/margin | |
| marginpoints | decimal | 13655 | in_marginpoints | F | TRADESDBO | TRADE_DETAIL | MARGINPOINTS | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/marginpoints | |
| mortgageFlag | YesNoOptionEnum | 12074 | in_mortgage_flag | S | TRADESDBO | TRADE | MORTGAGE_FLAG | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/mortgageFlag | |
| muniFlag | string | 13281 | in_muni_flag | S | TRADESDBO | TRADE | MUNI_FLAG | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/muniFlag | |
| netsettleamt | decimal | 191 | in_netsettleamt | F | TRADESDBO | TRADE_DETAIL | NETSETTLEAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/netsettleamt | |
| navId | integer | 12080 | in_nav_id | F | TRADESDBO | TRADE | NAV_ID | NUMBER(28) | N | EagleML/warehouseTransaction/warehouseTrade/navId | |
| numberOfAccuredDays | decimal | 12081 | in_number_of_accured_days | F | TRADESDBO | TRADE | NUMBER_OF_ACCURED_DAYS | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/numberOfAccuredDays | |
| netCashLocal | decimal | 13660 | in_net_cash_local | F | TRADESDBO | TRADE_DETAIL | NET_CASH_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/netCashLocal | |
| notionalamt | decimal | 13663 | in_notionalamt | F | TRADESDBO | TRADE_DETAIL | NOTIONALAMT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/notionalamt | |
| notionalflag | string | 12189 | in_notionalflag | S | TRADESDBO | TRADE_DETAIL | NOTIONALFLAG | CHAR(1) | N | EagleML/warehouseTransaction/warehouseTrade/notionalflag | |
| otherFee | decimal | 51 | in_other_fee | F | TRADESDBO | TRADE | OTHER_FEE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/otherFee | |
| origTranNum | string | 12190 | in_orig_tran_num | S | TRADESDBO | TRADE_DETAIL | ORIG_TRAN_NUM | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/origTranNum | |
| ownershipTransferDate | date | 12193 | in_ownership_transfer_date | S | TRADESDBO | TRADE_DETAIL | OWNERSHIP_TRANSFER_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/ownershipTransferDate | |
| oidYield | decimal | 12084 | in_oid_yield | F | TRADESDBO | TRADE | OID_YIELD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/oidYield | |
| otherFeeBase | decimal | 12085 | in_other_fee_base | F | TRADESDBO | TRADE | OTHER_FEE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/otherFeeBase | |
| paceTradeEventId | string | 13664 | in_pace_trade_event_id | S | TRADESDBO | TRADE_DETAIL | PACE_TRADE_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/paceTradeEventId | |
| positionIdTrd | integer | 13665 | in_position_id_trd | F | TRADESDBO | TRADE_DETAIL | POSITION_ID | NUMBER(38) | N | EagleML/warehouseTransaction/warehouseTrade/positionIdTrd | |
| productSubType | string | 13667 | in_product_sub_type | S | TRADESDBO | TRADE_DETAIL | PRODUCT_SUB_TYPE | CHAR(12) | N | EagleML/warehouseTransaction/warehouseTrade/productSubType | |
| poolNumber | string | 12095 | in_pool_number | S | TRADESDBO | TRADE | POOL_NUMBER | CHAR(12) | N | EagleML/warehouseTransaction/warehouseTrade/poolNumber | |
| priceCurrency | string | 12096 | in_price_currency | S | TRADESDBO | TRADE | PRICE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/priceCurrency | |
| principalFactor | decimal | 4483 | in_principal_factor | F | TRADESDBO | TRADE | PRINCIPAL_FACTOR | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/principalFactor | |
| realizedGlBase | decimal | 13668 | in_realized_gl_base | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/realizedGlBase | |
| realizedGlCrB | decimal | 13669 | in_realized_gl_cr_b | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_CR_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/realizedGlCrB | |
| realizedGlCrL | decimal | 13670 | in_realized_gl_cr_l | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_CR_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/realizedGlCrL | |
| realizedGlLocal | decimal | 13671 | in_realized_gl_local | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/realizedGlLocal | |
| realizedGlNcrB | decimal | 13672 | in_realized_gl_ncr_b | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_NCR_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/realizedGlNcrB | |
| realizedGlNcrL | decimal | 13673 | in_realized_gl_ncr_l | F | TRADESDBO | TRADE_DETAIL | REALIZED_GL_NCR_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/realizedGlNcrL | |
| recdPayAcct1 | string | 12208 | in_recd_pay_acct1 | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_ACCT1 | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/recdPayAcct1 | |
| recdPayAcct2 | string | 12209 | in_recd_pay_acct2 | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_ACCT2 | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/recdPayAcct2 | |
| recdPayEventType | string | 12210 | in_recd_pay_event_type | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_EVENT_TYPE | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/recdPayEventType | |
| recdPayPostingPlanType | string | 12211 | in_recd_pay_posting_plan_type | S | TRADESDBO | TRADE_DETAIL | RECD_PAY_POSTING_PLAN_TYPE | VARCHAR2(50) | N | EagleML/warehouseTransaction/warehouseTrade/recdPayPostingPlanType | |
| refrate | decimal | 13674 | in_refrate | F | TRADESDBO | TRADE_DETAIL | REFRATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/refrate | |
| repoRate | decimal | 12146 | in_repo_rate | F | TRADESDBO | TRADE | REPO_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/repoRate | |
| retailFeed | string | 12212 | in_retail_feed | S | TRADESDBO | TRADE_DETAIL | RETAIL_FEED | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehouseTrade/retailFeed | |
| salesPersonLogin | string | 12213 | in_sales_person_login | S | TRADESDBO | TRADE_DETAIL | SALES_PERSON_LOGIN | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/salesPersonLogin | |
| secidType | string | 12222 | in_secid_type | S | TRADESDBO | TRADE_DETAIL | SECID_TYPE | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/secidType | |
| sequencedate | date | 12195 | in_sequencedate | S | TRADESDBO | TRADE_DETAIL | SEQUENCEDATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/sequencedate | |
| settleamt0 | decimal | 13675 | in_settleamt0 | F | TRADESDBO | TRADE_DETAIL | SETTLEAMT0 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/settleamt0 | |
| settleamt1 | decimal | 13676 | in_settleamt1 | F | TRADESDBO | TRADE_DETAIL | SETTLEAMT1 | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/settleamt1 | |
| settled | string | 12223 | in_settled | S | TRADESDBO | TRADE_DETAIL | SETTLED | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehouseTrade/settled | |
| settleAmtAtMaturity | decimal | 12150 | in_settle_amt_at_maturity | F | TRADESDBO | TRADE | SETTLE_AMT_AT_MATURITY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/settleAmtAtMaturity | |
| settlementMethod | string | 12103 | in_settlement_method | S | TRADESDBO | TRADE | SETTLEMENT_METHOD | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/settlementMethod | |
| shortTermId | integer | 12151 | in_short_term_id | F | TRADESDBO | TRADE | SHORT_TERM_ID | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/shortTermId | |
| sourceSystem | string | 12104 | in_source_system | S | TRADESDBO | TRADE | SOURCE_SYSTEM | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/sourceSystem | |
| systemTradeTime | string | 12228 | in_system_trade_time | S | TRADESDBO | TRADE_DETAIL | SYSTEM_TRADE_TIME | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/systemTradeTime | |
| sentTradeStatus | string | 12099 | in_sent_trade_status | S | TRADESDBO | TRADE | SENT_TRADE_STATUS | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/sentTradeStatus | |
| starTag151 | string | 151 | in_star_tag151 | S | TRADESDBO | TRADE | STAR_TAG151 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/starTag151 | |
| starTag182 | string | 182 | in_star_tag182 | S | TRADESDBO | TRADE | STAR_TAG182 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/starTag182 | |
| stateTaxWithholdBase | decimal | 12152 | in_state_tax_withhold_base | F | TRADESDBO | TRADE | STATE_TAX_WITHHOLD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/stateTaxWithholdBase | |
| starLsInd | string | 15 | in_star_ls_ind | S | TRADESDBO | TRADE | STAR_LS_IND | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehouseTrade/starLsInd | |
| targetPurchaseDate | date | 12136 | in_target_purchase_date | S | TRADESDBO | TRADE | TARGET_PURCHASE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/targetPurchaseDate | |
| targetPurchasePrice | decimal | 12153 | in_target_purchase_price | F | TRADESDBO | TRADE | TARGET_PURCHASE_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/targetPurchasePrice | |
| targetTradeTicketNumber | string | 12110 | in_target_trade_ticket_number | S | TRADESDBO | TRADE | TARGET_TRADE_TICKET_NUMBER | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/targetTradeTicketNumber | |
| taxesBase | decimal | 12154 | in_taxes_base | F | TRADESDBO | TRADE | TAXES_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/taxesBase | |
| timeOfTrade | decimal | 12159 | in_time_of_trade | F | TRADESDBO | TRADE | TIME_OF_TRADE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/timeOfTrade | |
| toFxRate | decimal | 12160 | in_to_fx_rate | F | TRADESDBO | TRADE | TO_FX_RATE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/toFxRate | |
| toLocalCommissionAmt | decimal | 12161 | in_to_local_commission_amt | F | TRADESDBO | TRADE | TO_LOCAL_COMMISSION_AMT | NUMBER(28,12) | N | 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) | N | EagleML/warehouseTransaction/warehouseTrade/toSettleToBaseFxRate | |
| toSettlementCurrency | string | 12112 | in_to_settlement_currency | S | TRADESDBO | TRADE | TO_SETTLEMENT_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/toSettlementCurrency | |
| transactionId | string | 12117 | in_transaction_id | S | TRADESDBO | TRADE | TRANSACTION_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/transactionId | |
| turnaroundIndicator | string | 12118 | in_turnaround_indicator | S | TRADESDBO | TRADE | TURNAROUND_INDICATOR | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/turnaroundIndicator | |
| totalGainLocal | decimal | 10050 | in_total_gain_local | F | TRADESDBO | TRADE_DETAIL | TOTAL_GAIN_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/totalGainLocal | |
| totalAmortLocal | decimal | 5685 | in_total_amort_local | F | TRADESDBO | TRADE_DETAIL | TOTAL_AMORT_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/totalAmortLocal | |
| totalAmortBase | decimal | 5686 | in_total_amort_base | F | TRADESDBO | TRADE_DETAIL | TOTAL_AMORT_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/totalAmortBase | |
| totalLossLocal | decimal | 10053 | in_total_loss_local | F | TRADESDBO | TRADE_DETAIL | TOTAL_LOSS_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/totalLossLocal | |
| tdUserChar1 | string | 12229 | in_td_user_char1 | S | TRADESDBO | TRADE_DETAIL | TD_USER_CHAR1 | VARCHAR2(8) | N | EagleML/warehouseTransaction/warehouseTrade/tdUserChar1 | |
| tdUserChar2 | string | 12230 | in_td_user_char2 | S | TRADESDBO | TRADE_DETAIL | TD_USER_CHAR2 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/tdUserChar2 | |
| tdUserDate1 | date | 12196 | in_td_user_date1 | S | TRADESDBO | TRADE_DETAIL | TD_USER_DATE1 | DATE | N | EagleML/warehouseTransaction/warehouseTrade/tdUserDate1 | |
| tdUserDate2 | date | 12202 | in_td_user_date2 | S | TRADESDBO | TRADE_DETAIL | TD_USER_DATE2 | DATE | N | EagleML/warehouseTransaction/warehouseTrade/tdUserDate2 | |
| tdUserInt1 | integer | 13677 | in_td_user_int1 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT1 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt1 | |
| tdUserInt2 | integer | 13678 | in_td_user_int2 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT2 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt2 | |
| tdUserInt3 | integer | 13679 | in_td_user_int3 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT3 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt3 | |
| tdUserInt4 | integer | 13680 | in_td_user_int4 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT4 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt4 | |
| tdUserInt5 | integer | 13681 | in_td_user_int5 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT5 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt5 | |
| tdUserInt6 | integer | 13682 | in_td_user_int6 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT6 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt6 | |
| tdUserInt7 | integer | 13683 | in_td_user_int7 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT7 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt7 | |
| tdUserInt8 | integer | 13684 | in_td_user_int8 | F | TRADESDBO | TRADE_DETAIL | TD_USER_INT8 | NUMBER | N | EagleML/warehouseTransaction/warehouseTrade/tdUserInt8 | |
| tradeMemo3 | string | 12238 | in_trade_memo3 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO3 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/tradeMemo3 | |
| tradeMemo4 | string | 12239 | in_trade_memo4 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO4 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/tradeMemo4 | |
| tradeMemo5 | string | 502 | in_trade_memo5 | S | TRADESDBO | TRADE_DETAIL | TRADE_MEMO5 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/tradeMemo5 | |
| thirdCurrencyFx | decimal | 13685 | in_third_currency_fx | F | TRADESDBO | TRADE_DETAIL | THIRD_CURRENCY_FX | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/thirdCurrencyFx | |
| timeOfSalesTicket | string | 12232 | in_time_of_sales_ticket | S | TRADESDBO | TRADE_DETAIL | TIME_OF_SALES_TICKET | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/timeOfSalesTicket | |
| timeOfSlate | string | 12233 | in_time_of_slate | S | TRADESDBO | TRADE_DETAIL | TIME_OF_SLATE | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/timeOfSlate | |
| tradeChar1 | string | 12113 | in_trade_char1 | S | TRADESDBO | TRADE | TRADE_CHAR1 | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehouseTrade/tradeChar1 | |
| tradeFlat | string | 12114 | in_trade_flat | S | TRADESDBO | TRADE | TRADE_FLAT | CHAR(2) | N | EagleML/warehouseTransaction/warehouseTrade/tradeFlat | |
| tradersLogin | string | 12116 | in_traders_login | S | TRADESDBO | TRADE | TRADERS_LOGIN | CHAR(12) | N | EagleML/warehouseTransaction/warehouseTrade/tradersLogin | |
| transcost4Amount | decimal | 13686 | in_transcost4_amount | F | TRADESDBO | TRADE_DETAIL | TRANSCOST4_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/transcost4Amount | |
| transcost4Code | string | 12240 | in_transcost4_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST4_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/transcost4Code | |
| transcost4Currency | string | 12241 | in_transcost4_currency | S | TRADESDBO | TRADE_DETAIL | TRANSCOST4_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/transcost4Currency | |
| transcost4TypeCode | string | 12242 | in_transcost4_type_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST4_TYPE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/transcost4TypeCode | |
| transcost5Amount | decimal | 13687 | in_transcost5_amount | F | TRADESDBO | TRADE_DETAIL | TRANSCOST5_AMOUNT | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/transcost5Amount | |
| transcost5Code | string | 12243 | in_transcost5_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST5_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/transcost5Code | |
| transcost5Currency | string | 12244 | in_transcost5_currency | S | TRADESDBO | TRADE_DETAIL | TRANSCOST5_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/transcost5Currency | |
| transcost5TypeCode | string | 12245 | in_transcost5_type_code | S | TRADESDBO | TRADE_DETAIL | TRANSCOST5_TYPE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/transcost5TypeCode | |
| updateSourceTrd | string | 12261 | in_update_source_trd | S | TRADESDBO | TRADE_DETAIL | UPDATE_SOURCE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/updateSourceTrd | |
| underlyingAccrIntB | decimal | 12164 | in_underlying_accr_int_b | F | TRADESDBO | TRADE | UNDERLYING_ACCR_INT_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntB | |
| underlyingAccrIntL | decimal | 12165 | in_underlying_accr_int_l | F | TRADESDBO | TRADE | UNDERLYING_ACCR_INT_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntL | |
| underlyingAccrIntLMat | decimal | 12201 | in_underlying_accr_int_l_mat | F | TRADESDBO | TRADE | UNDERLYING_ACCR_INT_L_MAT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehouseTrade/underlyingAccrIntLMat | |
| withholdCode | string | 12263 | in_withhold_code | S | TRADESDBO | TRADE_DETAIL | WITHHOLD_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/withholdCode | |
| withholdCurrency | string | 12264 | in_withhold_currency | S | TRADESDBO | TRADE_DETAIL | WITHHOLD_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/withholdCurrency | |
| withholdTypeCode | string | 12265 | in_withhold_type_code | S | TRADESDBO | TRADE_DETAIL | WITHHOLD_TYPE_CODE | CHAR(8) | N | EagleML/warehouseTransaction/warehouseTrade/withholdTypeCode | |
| workoutDate | date | 12214 | in_workout_date | S | TRADESDBO | TRADE_DETAIL | WORKOUT_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/workoutDate | |
| workoutPrice | decimal | 13689 | in_workout_price | F | TRADESDBO | TRADE_DETAIL | WORKOUT_PRICE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/workoutPrice | |
| withholdingTax | decimal | 12216 | in_withholding_tax | F | TRADESDBO | TRADE | WITHHOLDING_TAX | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/withholdingTax | |
| batchEventId | string | 701 | in_batch_event_id | S | TRADESDBO | TRADE_DETAIL | BATCH_EVENT_ID | VARCHAR2(55) | N | EagleML/warehouseTransaction/warehouseTrade/batchEventId | |
| secFee | decimal | 3752 | in_sec_fees | F | TRADESDBO | TRADE | SEC_FEES | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/secFee | |
| tradeDate | date | 35 | in_trade_date | S | TRADESDBO | TRADE | TRADE_DATE | DATE | N | EagleML/warehouseTransaction/warehouseTrade/tradeDate | |
| recordType | string | 12097 | in_record_type | S | TRADESDBO | TRADE | RECORD_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehouseTrade/recordType | |
| costLocal* (supported in 2017R1) | decimal | 162 | in_cost_local | F | TRADESDBO | TRADE | COST_LOCAL | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/costLocal | |
| costBase* (supported in 2017R1) | decimal | 166 | in_cost_base | F | TRADESDBO | TRADE | COST_BASE | NUMBER(28,12) | N | EagleML/warehouseTransaction/warehouseTrade/costBase | |
| linkEventId | TransactionId | 28 | in_link_event_id | S | TRADESDBO | TRADE | LINK_EVENT_ID | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/linkEventId | |
| localCurrency | CurrencyCode | not stored in DB | EagleML/warehouseTransaction/warehouseTrade/localCurrency | ||||||||
| commissionCurrency | CurrencyCode | 85 | TRADESDBO | TRADE | COMMISSION_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/commissionCurrency | |||
| eventSequence | integer | 126 | TRADESDBO | TRADE | EVENT_SEQUENCE | INTEGER | N | EagleML/warehouseTransaction/warehouseTrade/eventSequence | |||
| starTag26 | string | 26 | TRADESDBO | TRADE | STAR_TAG26 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/starTag26 | |||
| tradeCurrency | CurrencyCode | 85 | TRADESDBO | TRADE | TRADE_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehouseTrade/tradeCurrency | |||
| settleInstructions1* (supported in 2017R1) | string | 8074 | in_settle_instructions1 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS1 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settleInstructions1 | |
| settleInstructions2* (supported in 2017R1) | string | 8075 | in_settle_instructions2 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS2 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settleInstructions2 | |
| settleInstructions3* (supported in 2017R1) | string | 8076 | in_settle_instructions3 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS3 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settleInstructions3 | |
| settleInstructions4* (supported in 2017R1) | string | 8077 | in_settle_instructions4 | S | TRADESDBO | TRADE_DETAIL | SETTLE_INSTRUCTIONS4 | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/settleInstructions4 | |
| orderNumber* (supported in 2017R1) | string | 1092 | in_order_number | TRADESDBO | TRADE | ORDER_NUMBER | VARCHAR2(255) | N | EagleML/warehouseTransaction/warehouseTrade/orderNumber | ||
| priceMethod* (supported in 2017R1) | normalizedString | 1872 | in_price_method | S | TRADESDBO | TRADE | PRICE_METHOD | VARCHAR2(4) | N | EagleML/warehouseTransaction/warehouseTrade/priceMethod | |
| regulatoryIntent* (supported in 2017R1) | normalizedString | 8915 | in_regulatory_intent | S | TRADESDBO | TRADE | REGULATORY_INTENT | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehouseTrade/regulatoryIntent | |
| holdingTerm* (supported in 2017R1) | normalizedString | 9091 | in_holding_term | S | TRADESDBO | TRADE | HOLDING_TERM | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehouseTrade/holdingTerm | |
| deskAka | string | 7350 | in_counterparty_desk_aka | S | TRADESDBO | TRADE_DETAIL_EXT | COUNTERPARTY_DESK_AKA | EagleML/warehouseTransaction/warehouseTrade/deskAka | |||
| deskType | string | 7351 | in_counterparty_desk_type | S | TRADESDBO | TRADE_DETAIL_EXT | COUNTERPARTY_DESK_TYPE | EagleML/warehouseTransaction/warehouseTrade/deskType | |||
| desk | string | 7352 | in_counterparty_desk | S | TRADESDBO | TRADE_DETAIL_EXT | COUNTERPARTY_DESK | EagleML/warehouseTransaction/warehouseTrade/desk | |||
| exSubBrokerId | string | 7353 | in_ex_sub_broker_id | S | TRADESDBO | TRADE_DETAIL_EXT | EX_SUB_BROKER_ID | EagleML/warehouseTransaction/warehouseTrade/exSubBrokerId | |||
| placementNum | string | 7354 | in_placement_num | S | TRADESDBO | TRADE_DETAIL_EXT | PLACEMENT_NUM | EagleML/warehouseTransaction/warehouseTrade/placementNum | |||
| subBrokerCode | string | 7355 | in_sub_broker_code | S | TRADESDBO | TRADE_DETAIL_EXT | SUB_BROKER_CODE | EagleML/warehouseTransaction/warehouseTrade/subBrokerCode | |||
| tradeInterfaceInfo | string | 7356 | in_trade_error_note | S | TRADESDBO | TRADE_DETAIL_EXT | TRADE_ERROR_NOTE | EagleML/warehouseTransaction/warehouseTrade/tradeInterfaceInfo | |||
| trdBrokerAka | string | 7357 | in_alt_trade_broker_code | S | TRADESDBO | TRADE_DETAIL_EXT | ALT_TRADE_BROKER_CODE | EagleML/warehouseTransaction/warehouseTrade/trdBrokerAka | |||
| trdDirtyPrice | decimal | 7358 | in_trd_dirty_price | F | TRADESDBO | TRADE_DETAIL_EXT | TRD_DIRTY_PRICE | EagleML/warehouseTransaction/warehouseTrade/trdDirtyPrice | |||
| trdExBrokerDesk | string | 7359 | in_ex_broker_desk | S | TRADESDBO | TRADE_DETAIL_EXT | EX_BROKER_DESK | EagleML/warehouseTransaction/warehouseTrade/trdExBrokerDesk | |||
| trdExDeskType | string | 7360 | in_ex_broker_desk_type | S | TRADESDBO | TRADE_DETAIL_EXT | EX_BROKER_DESK_TYPE | EagleML/warehouseTransaction/warehouseTrade/trdExDeskType | |||
| trdExternalAccountLoc | string | 7361 | in_trd_external_account_loc | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ACCOUNT_LOC | EagleML/warehouseTransaction/warehouseTrade/trdExternalAccountLoc | |||
| trdLocation | string | 7362 | in_trd_location | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_LOCATION | EagleML/warehouseTransaction/warehouseTrade/trdLocation | |||
| trdSeriesNum | string | 7363 | in_trd_lot_num_code | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_LOT_NUM_CODE | EagleML/warehouseTransaction/warehouseTrade/trdSeriesNum | |||
| trdVersion | string | 7364 | in_trd_version | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_VERSION | EagleML/warehouseTransaction/warehouseTrade/trdVersion | |||
| trdExtidId1 | string | 7365 | in_trd_external_id_1 | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ID_1 | EagleML/warehouseTransaction/warehouseTrade/trdExtidId1 | |||
| trdExtidId2 | string | 7366 | in_trd_external_id_2 | S | TRADESDBO | TRADE_DETAIL_EXT | TRD_EXTERNAL_ID_2 | 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 | ||||
| stGainSecLocal | 17347 | TRADESDBO | TRADE_EXT | ST_GAIN_SEC_L | EagleML/warehouseTransaction/warehouseTrade/stGainSecLocal | ||||||
| stLossSecLocal | 17348 | TRADESDBO | TRADE_EXT | ST_LOSS_SEC_L | EagleML/warehouseTransaction/warehouseTrade/stLossSecLocal | ||||||
| stGainSecBase | 17349 | TRADESDBO | TRADE_EXT | ST_GAIN_SEC_B | EagleML/warehouseTransaction/warehouseTrade/stGainSecBase | ||||||
| stLossSecBase | 17350 | TRADESDBO | TRADE_EXT | ST_LOSS_SEC_B | EagleML/warehouseTransaction/warehouseTrade/stLossSecBase | ||||||
| stGain | 17351 | TRADESDBO | TRADE_EXT | ST_GAIN | EagleML/warehouseTransaction/warehouseTrade/stGain | ||||||
| stLoss | 17352 | TRADESDBO | TRADE_EXT | ST_LOSS | EagleML/warehouseTransaction/warehouseTrade/stLoss | ||||||
| stGainCurrency | 17353 | TRADESDBO | TRADE_EXT | ST_GAIN_CRRCY | EagleML/warehouseTransaction/warehouseTrade/stGainCurrency | ||||||
| stLossCurrency | 17354 | TRADESDBO | TRADE_EXT | ST_LOSS_CRRCY | EagleML/warehouseTransaction/warehouseTrade/stLossCurrency | ||||||
| ltGainSecLocal | 17355 | TRADESDBO | TRADE_EXT | LT_GAIN_SEC_L | EagleML/warehouseTransaction/warehouseTrade/ltGainSecLocal | ||||||
| ltLossSecLocal | 17356 | TRADESDBO | TRADE_EXT | LT_LOSS_SEC_L | EagleML/warehouseTransaction/warehouseTrade/ltLossSecLocal | ||||||
| ltGainSecBase | 17357 | TRADESDBO | TRADE_EXT | LT_GAIN_SEC_B | EagleML/warehouseTransaction/warehouseTrade/ltGainSecBase | ||||||
| ltLossSecBase | 17358 | TRADESDBO | TRADE_EXT | LT_LOSS_SEC_B | EagleML/warehouseTransaction/warehouseTrade/ltLossSecBase | ||||||
| ltGain | 17359 | TRADESDBO | TRADE_EXT | LT_GAIN | EagleML/warehouseTransaction/warehouseTrade/ltGain | ||||||
| ltLoss | 17360 | TRADESDBO | TRADE_EXT | LT_LOSS | EagleML/warehouseTransaction/warehouseTrade/ltLoss | ||||||
| ltGainCurrency | 17361 | TRADESDBO | TRADE_EXT | LT_GAIN_CRRCY | EagleML/warehouseTransaction/warehouseTrade/ltGainCurrency | ||||||
| ltLossCurrency | 17362 | TRADESDBO | TRADE_EXT | LT_LOSS_CRRCY | EagleML/warehouseTransaction/warehouseTrade/ltLossCurrency | ||||||
| clsAmortLocal | 17363 | TRADESDBO | TRADE_EXT | CLS_AMORT_LOCAL | EagleML/warehouseTransaction/warehouseTrade/clsAmortLocal | ||||||
| clsAmortBase | 17364 | TRADESDBO | TRADE_EXT | CLS_AMORT_BASE | EagleML/warehouseTransaction/warehouseTrade/clsAmortBase | ||||||
| clsOidLocal | 17365 | TRADESDBO | TRADE_EXT | CLS_OID_L | EagleML/warehouseTransaction/warehouseTrade/clsOidLocal | ||||||
| clsOidBase | 17366 | TRADESDBO | TRADE_EXT | CLS_OID_B | EagleML/warehouseTransaction/warehouseTrade/clsOidBase | ||||||
| clsIlbIncLtdLocal | 17367 | TRADESDBO | TRADE_EXT | CLS_ILB_INC_LTD_LOCAL | EagleML/warehouseTransaction/warehouseTrade/clsIlbIncLtdLocal | ||||||
| clsIlbIncLtdBase | 17368 | TRADESDBO | TRADE_EXT | CLS_ILB_INC_LTD_BASE | EagleML/warehouseTransaction/warehouseTrade/clsIlbIncLtdBase | ||||||
| gainCurrency988 | 17369 | in_gain_currency_988 | TRADESDBO | TRADE_EXT | GAIN_CRRCY_988 | EagleML/warehouseTransaction/warehouseTrade/gainCurrency988 | |||||
| lossCurrency988 | 17370 | in_loss_currency_988 | TRADESDBO | TRADE_EXT | LOSS_CRRCY_988 | EagleML/warehouseTransaction/warehouseTrade/lossCurrency988 | |||||
| gainLossCurrency988 | 17371 | TRADESDBO | TRADE_EXT | GAIN_LOSS_CRRCY_988 | EagleML/warehouseTransaction/warehouseTrade/gainLossCurrency988 | ||||||
| washsaleDisallowedReversalLocal | 17372 | TRADESDBO | TRADE_EXT | WS_DISALLOW_REV_L | EagleML/warehouseTransaction/warehouseTrade/washsaleDisallowedReversalLocal | ||||||
| washsaleDisallowedReversalBase | 17373 | TRADESDBO | TRADE_EXT | WS_DISALLOW_REV_B | EagleML/warehouseTransaction/warehouseTrade/washsaleDisallowedReversalBase | ||||||
| impairmentLtdLocalExt | 17374 | TRADESDBO | TRADE_EXT | IMPAIRMENT_LTD_LOCAL | EagleML/warehouseTransaction/warehouseTrade/impairmentLtdLocalExt | ||||||
| impairmentLtdBaseExt | 17375 | TRADESDBO | TRADE_EXT | IMPAIRMENT_LTD_BASE | EagleML/warehouseTransaction/warehouseTrade/impairmentLtdBaseExt | ||||||
| impairmentFxLtd | 17376 | TRADESDBO | TRADE_EXT | IMPAIRMENT_FX_LTD | EagleML/warehouseTransaction/warehouseTrade/impairmentFxLtd | ||||||
| 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, please set IncludeExtendedDetails=ALL or IncludeExtendedDetails=Y in the RTR | |||||||||||
| calcTransactionId | Optional | string | 2983 | EagleML/warehouseTransaction/warehouseTrade/calcTransactionId | |||||||
| calcMasterTransactionId | Optional | string | 2984 | MASTER_TXN_ID | EagleML/warehouseTransaction/warehouseTrade/calcMasterTransactionId | ||||||
| calcCancelTransactionId | Optional | string | 2985 | CXL_TARGET_ID | EagleML/warehouseTransaction/warehouseTrade/calcCancelTransactionId | ||||||