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