| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle Database | Database Table | Database Field | DB Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Optional | objectType | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/objectType | ||||||
| objectId | Optional | objectId | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/objectId | ||||||
| objectDescription | Optional | objectDescription | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/objectDescription | ||||||
| updateTimestamp | Optional | dateTime | TRADESDBO | PENDING_TRADES | UPDATE_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/updateTimestamp | |||
| customElements | Not recommended | CustomElements | reserved for customizations | EagleML/warehouseTransaction/warehousePendingTrade/customElements | ||||||
| sourceName | Optional | string | 1102 | IN_SRC_INTFC_INST | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/warehouseTransaction/warehousePendingTrade/sourceName |
| updateSource | Optional | string | 944 | in_update_source | S | TRADESDBO | PENDING_TRADES | UPDATE_SOURCE | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/updateSource |
| batchCollectErrorsFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/batchCollectErrorsFlag | ||||||
| singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/singleRowCommitFlag | ||||||
| reportType | Optional | normalizedString | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/reportType | ||||||
| effectiveDate | Optional | date | 1109 | in_effective_date | S | TRADESDBO | PENDING_TRADES | EFFECTIVE_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/effectiveDate |
| Entity Common Id Model | EagleML/warehouseTransaction/warehousePendingTrade/ | |||||||||
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehousePendingTrade/ | |||||||||
| Asset Identifiers Model | EagleML/warehouseTransaction/warehousePendingTrade/ | |||||||||
| Extended Asset Properties Model (extract only) | EagleML/warehouseTransaction/warehousePendingTrade/ | |||||||||
| maturityDate | Optional | date | not stored in DB | EagleML/warehouseTransaction/warehousePendingTrade/maturityDate | ||||||
| accountBasis | Optional | normalizedString | 21 | in_acct_basis | S | TRADESDBO | PENDING_TRADES | ACCT_BASIS | VARCHAR2(5) | EagleML/warehouseTransaction/warehousePendingTrade/accountBasis |
| accruedInterestType | Optional | normalizedString | 3715 | in_accrued_interest_type | S | TRADESDBO | PENDING_TRADES | ACCRUED_INTEREST_TYPE | VARCHAR2(3) | EagleML/warehouseTransaction/warehousePendingTrade/accruedInterestType |
| acquisitionType | Optional | normalizedString | 2425 | in_acquisition_type | S | TRADESDBO | PENDING_TRADES | ACQUISITION_TYPE | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/acquisitionType |
| amortAtDispLtdB | Optional | decimal | 5549 | in_amort_at_disp_ltd_b | F | TRADESDBO | PENDING_TRADES | AMORT_AT_DISP_LTD_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/amortAtDispLtdB |
| amortAtDispLtdL | Optional | decimal | 5548 | in_amort_at_disp_ltd_l | F | TRADESDBO | PENDING_TRADES | AMORT_AT_DISP_LTD_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/amortAtDispLtdL |
| amortYield | Optional | decimal | 75 | in_amort_yield | F | TRADESDBO | PENDING_TRADES | AMORT_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/amortYield |
| autoSettleIndicator | Optional | normalizedString | 58 | in_auto_settle_ind | S | TRADESDBO | PENDING_TRADES | AUTO_SETTLE_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/autoSettleIndicator |
| backupWithholdingL | Optional | decimal | 2712 | in_backup_withholding_l | F | TRADESDBO | PENDING_TRADES | BACKUP_WITHHOLDING_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/backupWithholdingL |
| bankAlias | Optional | integer | 16 | in_bank_alias | F | TRADESDBO | PENDING_TRADES | BANK_ALIAS | NUMBER(38,0) | EagleML/warehouseTransaction/warehousePendingTrade/bankAlias |
| batchEventId | Optional | string | in_batch_event_id | S | TRADESDBO | PENDING_TRADES | BATCH_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/batchEventId | |
| brokerCode | Optional | string | 88 | in_broker_code | S | TRADESDBO | PENDING_TRADES | BROKER_CODE | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/brokerCode |
| brokerName | Optional | string | in_broker_name | S | TRADESDBO | PENDING_TRADES | BROKER_NAME | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/brokerName | |
| buyToBaseFxRate | Optional | decimal | in_buy_to_base_fx_rate | F | TRADESDBO | PENDING_TRADES | BUY_TO_BASE_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/buyToBaseFxRate | |
| cancelEventId | Optional | string | in_cancel_event_id | S | TRADESDBO | PENDING_TRADES | CANCEL_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/cancelEventId | |
| capExpFeesFlag | Optional | normalizedString | in_cap_exp_fees_flag | S | TRADESDBO | PENDING_TRADES | CAP_EXP_FEES_FLAG | VARCHAR2(2) | EagleML/warehouseTransaction/warehousePendingTrade/capExpFeesFlag | |
| cashCategory | Optional | string | 62 | in_cash_category | S | TRADESDBO | PENDING_TRADES | CASH_CATEGORY | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/cashCategory |
| cashEventType | Optional | string | 53 | in_cash_event_type | S | TRADESDBO | PENDING_TRADES | CASH_EVENT_TYPE | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/cashEventType |
| clearingBrokerCode | Optional | string | 1237 | in_clearing_broker_code | S | TRADESDBO | PENDING_TRADES | CLEARING_BROKER_CODE | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/clearingBrokerCode |
| clearingBrokerName | Optional | string | in_clearing_broker_name | S | TRADESDBO | PENDING_TRADES | CLEARING_BROKER_NAME | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/clearingBrokerName | |
| comments | Optional | string | 12075 | in_comments | S | TRADESDBO | PENDING_TRADES | COMMENTS | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/comments |
| commissionAmountLocal | Optional | decimal | in_commission_amount_local | F | TRADESDBO | PENDING_TRADES | COMMISSION_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/commissionAmountLocal | |
| conversionPremium | Optional | decimal | 5727 | in_conversion_premium | F | TRADESDBO | PENDING_TRADES | CONVERSION_PREMIUM | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/conversionPremium |
| costBasisCoverLotFlag | Optional | normalizedString | 2819 | in_cost_basis_cover_lot_flag | S | TRADESDBO | PENDING_TRADES | COST_BASIS_COVER_LOT_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/costBasisCoverLotFlag |
| costBasisType | Optional | normalizedString | 24 | in_cost_basis_type | S | TRADESDBO | PENDING_TRADES | COST_BASIS_TYPE | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/costBasisType |
| coveredLotOverrideFlag | Optional | normalizedString | 2820 | in_covered_lot_override_flag | S | TRADESDBO | PENDING_TRADES | COVERED_LOT_OVERRIDE_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/coveredLotOverrideFlag |
| custodyBankAccountNumber | Optional | string | 1660 | in_custody_bank_acct_num | S | TRADESDBO | PENDING_TRADES | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/warehouseTransaction/warehousePendingTrade/custodyBankAccountNumber |
| custodyBankCode | Optional | string | in_custody_bank_code | S | TRADESDBO | PENDING_TRADES | CUSTODY_BANK_CODE | CHAR(20) | EagleML/warehouseTransaction/warehousePendingTrade/custodyBankCode | |
| custodyBankDesc | Optional | string | in_custody_bank_desc | S | TRADESDBO | PENDING_TRADES | CUSTODY_BANK_DESC | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/custodyBankDesc | |
| custodyBankSubAccount | Optional | string | 1661 | in_custody_bank_sub_acct | S | TRADESDBO | PENDING_TRADES | CUSTODY_BANK_SUB_ACCT | VARCHAR2(10) | EagleML/warehouseTransaction/warehousePendingTrade/custodyBankSubAccount |
| deferredIncReceivB | Optional | decimal | 11572 | in_deferred_inc_receiv_b | F | TRADESDBO | PENDING_TRADES | DEFERRED_INC_RECEIV_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/deferredIncReceivB |
| deferredIncReceivL | Optional | decimal | 11571 | in_deferred_inc_receiv_l | F | TRADESDBO | PENDING_TRADES | DEFERRED_INC_RECEIV_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/deferredIncReceivL |
| eventId | Optional | string | 25 | in_event_id | S | TRADESDBO | PENDING_TRADES | EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/eventId |
| eventIdSwitch | Optional | normalizedString | 8087 | in_event_id_switch | S | TRADESDBO | PENDING_TRADES | EVENT_ID_SWITCH | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/eventIdSwitch |
| eventSubPriority | Optional | integer | 2862 | in_event_sub_priority | F | TRADESDBO | PENDING_TRADES | EVENT_SUB_PRIORITY | NUMBER(38,0) | EagleML/warehouseTransaction/warehousePendingTrade/eventSubPriority |
| eventType | Optional | string | 55 | in_event_type | S | TRADESDBO | PENDING_TRADES | EVENT_TYPE | VARCHAR2(55) | EagleML/warehouseTransaction/warehousePendingTrade/eventType |
| exchangeCode | Optional | string | 9036 | in_exchange_code | S | TRADESDBO | PENDING_TRADES | EXCHANGE_CODE | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/exchangeCode |
| exchangeFeeLocal | Optional | decimal | in_exchange_fee_local | F | TRADESDBO | PENDING_TRADES | EXCHANGE_FEE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/exchangeFeeLocal | |
| exportBatchId | Optional | string | in_export_batch_id | S | TRADESDBO | PENDING_TRADES | EXPORT_BATCH_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/exportBatchId | |
| factor | Optional | decimal | 91 | in_factor | F | TRADESDBO | PENDING_TRADES | FACTOR | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/factor |
| factorDate | Optional | date | 105 | in_factor_date | S | TRADESDBO | PENDING_TRADES | FACTOR_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/factorDate |
| fairMarketValueBase | Optional | decimal | 2429 | in_fair_market_value_base | F | TRADESDBO | PENDING_TRADES | FAIR_MARKET_VALUE_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValueBase |
| fairMarketValueFlag | Optional | normalizedString | 2427 | in_fair_market_value_flag | S | TRADESDBO | PENDING_TRADES | FAIR_MARKET_VALUE_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValueFlag |
| fairMarketValueLocal | Optional | decimal | 2428 | in_fair_market_value_local | F | TRADESDBO | PENDING_TRADES | FAIR_MARKET_VALUE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValueLocal |
| fairMarketValuePrice | Optional | decimal | 2452 | in_fair_market_value_price | F | TRADESDBO | PENDING_TRADES | FAIR_MARKET_VALUE_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/fairMarketValuePrice |
| fromAutoSettleInd | Optional | normalizedString | 383 | in_from_auto_settle_ind | S | TRADESDBO | PENDING_TRADES | FROM_AUTO_SETTLE_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/fromAutoSettleInd |
| fromCashEventType | Optional | string | 378 | in_from_cash_event_type | S | TRADESDBO | PENDING_TRADES | FROM_CASH_EVENT_TYPE | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/fromCashEventType |
| fromEntityId | Optional | string | in_from_entity_id | S | TRADESDBO | PENDING_TRADES | FROM_ENTITY_ID | CHAR(8) | EagleML/warehouseTransaction/warehousePendingTrade/fromEntityId | |
| fromLongShortIndicator | Optional | normalizedString | 355 | in_from_long_short_indicator | S | TRADESDBO | PENDING_TRADES | FROM_LONG_SHORT_INDICATOR | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/fromLongShortIndicator |
| fromNetAmountLocal | Optional | decimal | in_from_net_amount_local | F | TRADESDBO | PENDING_TRADES | FROM_NET_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/fromNetAmountLocal | |
| fromQuantity | Optional | decimal | in_from_quantity | F | TRADESDBO | PENDING_TRADES | FROM_QUANTITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/fromQuantity | |
| fromSecurityAlias | Optional | integer | in_from_security_alias | F | TRADESDBO | PENDING_TRADES | FROM_SECURITY_ALIAS | NUMBER(38,0) | EagleML/warehouseTransaction/warehousePendingTrade/fromSecurityAlias | |
| fromWashSaleEligibleIndicator | Optional | normalizedString | 384 | in_from_wash_sale_elgbl_ind | S | TRADESDBO | PENDING_TRADES | FROM_WASH_SALE_ELGBL_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/fromWashSaleEligibleIndicator |
| holdingPeriodDate | Optional | date | 3899 | in_holding_period_date | S | TRADESDBO | PENDING_TRADES | HOLDING_PERIOD_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/holdingPeriodDate |
| ilbCloseIndexRatio | Optional | decimal | 4540 | in_ilb_close_index_ratio | F | TRADESDBO | PENDING_TRADES | ILB_CLOSE_INDEX_RATIO | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/ilbCloseIndexRatio |
| ilbConvertedIncB | Optional | decimal | 11516 | in_ilb_converted_inc_b | F | TRADESDBO | PENDING_TRADES | ILB_CONVERTED_INC_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/ilbConvertedIncB |
| ilbConvertedIncL | Optional | decimal | 11508 | in_ilb_converted_inc_l | F | TRADESDBO | PENDING_TRADES | ILB_CONVERTED_INC_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/ilbConvertedIncL |
| ilbIndexRatio | Optional | decimal | 4483 | in_ilb_index_ratio | F | TRADESDBO | PENDING_TRADES | ILB_INDEX_RATIO | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/ilbIndexRatio |
| ilbOrigAcquireIndex | Optional | decimal | 11509 | in_ilb_orig_acq_index | F | TRADESDBO | PENDING_TRADES | ILB_ORIG_ACQ_INDEX | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/ilbOrigAcquireIndex |
| impliedCommission | Optional | normalizedString | 78 | in_implied_commission | S | TRADESDBO | PENDING_TRADES | IMPLIED_COMMISSION | VARCHAR2(3) | EagleML/warehouseTransaction/warehousePendingTrade/impliedCommission |
| ledgerEffectiveDate | Optional | date | 3739 | in_ledger_effective_date | S | TRADESDBO | PENDING_TRADES | LEDGER_EFFECTIVE_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/ledgerEffectiveDate |
| letterOfAutorization | Optional | normalizedString | in_letter_of_autorization | S | TRADESDBO | PENDING_TRADES | LETTER_OF_AUTORIZATION | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/letterOfAutorization | |
| linkEventId | Optional | string | 28 | in_link_event_id | S | TRADESDBO | PENDING_TRADES | LINK_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/linkEventId |
| localToBaseFxRate | Optional | decimal | in_local_to_base_fx_rate | F | TRADESDBO | PENDING_TRADES | LOCAL_TO_BASE_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/localToBaseFxRate | |
| longShortIndicator | Optional | normalizedString | 15 | in_long_short_indicator | S | TRADESDBO | PENDING_TRADES | LONG_SHORT_INDICATOR | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/longShortIndicator |
| lotSelectionMethod | Optional | string | 27 | in_lot_selection_method | S | TRADESDBO | PENDING_TRADES | LOT_SELECTION_METHOD | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/lotSelectionMethod |
| monthlyAccountDate | Optional | date | 5022 | in_monthly_acct_date | S | TRADESDBO | PENDING_TRADES | MONTHLY_ACCT_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/monthlyAccountDate |
| mttype | Optional | string | 3822 | in_mttype | S | TRADESDBO | PENDING_TRADES | MTTYPE | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/mttype |
| navId | Optional | integer | 3196 | in_nav_id | F | TRADESDBO | PENDING_TRADES | NAV_ID | NUMBER(38,0) | EagleML/warehouseTransaction/warehousePendingTrade/navId |
| netAmountBase | Optional | decimal | 478 | in_net_amount_base | F | TRADESDBO | PENDING_TRADES | NET_AMOUNT_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/netAmountBase |
| netAmountLocal | Optional | decimal | 50 | in_net_amount_local | F | TRADESDBO | PENDING_TRADES | NET_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/netAmountLocal |
| oidYield | Optional | decimal | 39 | in_oid_yield | F | TRADESDBO | PENDING_TRADES | OID_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/oidYield |
| optionSettlementMethod | Optional | string | in_option_settlement_method | S | TRADESDBO | PENDING_TRADES | OPTION_SETTLEMENT_METHOD | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/optionSettlementMethod | |
| orderNumber | Optional | string | 1092 | in_order_number | S | TRADESDBO | PENDING_TRADES | ORDER_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/orderNumber |
| origAcquireCostBase | Optional | decimal | 5872 | in_orig_acq_cost_base | F | TRADESDBO | PENDING_TRADES | ORIG_ACQ_COST_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/origAcquireCostBase |
| origAcquireCostLocal | Optional | decimal | in_orig_acq_cost_local | F | TRADESDBO | PENDING_TRADES | ORIG_ACQ_COST_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/origAcquireCostLocal | |
| origAcquireDate | Optional | date | in_orig_acq_date | S | TRADESDBO | PENDING_TRADES | ORIG_ACQ_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/origAcquireDate | |
| originalEventId | Optional | string | 457 | in_original_event_id | S | TRADESDBO | PENDING_TRADES | ORIGINAL_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/originalEventId |
| originalFaceValue | Optional | decimal | in_original_face_value | F | TRADESDBO | PENDING_TRADES | ORIGINAL_FACE_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/originalFaceValue | |
| originalUpdateSource | Optional | string | 4488 | in_original_update_source | S | TRADESDBO | PENDING_TRADES | ORIGINAL_UPDATE_SOURCE | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/originalUpdateSource |
| origSettlementDate | Optional | date | 9264 | in_orig_settlement_date | S | TRADESDBO | PENDING_TRADES | ORIG_SETTLEMENT_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/origSettlementDate |
| origWashsaleDisallowanceB | Optional | decimal | 3848 | in_orig_ws_disallowance_b | F | TRADESDBO | PENDING_TRADES | ORIG_WS_DISALLOWANCE_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/origWashsaleDisallowanceB |
| origWashsaleDisallowanceL | Optional | decimal | 3847 | in_orig_ws_disallowance_l | F | TRADESDBO | PENDING_TRADES | ORIG_WS_DISALLOWANCE_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/origWashsaleDisallowanceL |
| otherFeeLocal | Optional | decimal | 3752 | in_other_fee_local | F | TRADESDBO | PENDING_TRADES | OTHER_FEE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/otherFeeLocal |
| ownershipTransferDate | Optional | date | 2426 | in_ownership_transfer_date | S | TRADESDBO | PENDING_TRADES | OWNERSHIP_TRANSFER_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/ownershipTransferDate |
| performancePrice | Optional | decimal | 4598 | in_performance_price | F | TRADESDBO | PENDING_TRADES | PERFORMANCE_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/performancePrice |
| postDate | Optional | date | 118 | in_post_date | S | TRADESDBO | PENDING_TRADES | POST_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/postDate |
| price | Optional | decimal | 10452 | in_price | F | TRADESDBO | PENDING_TRADES | PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehousePendingTrade/price |
| quantity | Optional | decimal | in_quantity | F | TRADESDBO | PENDING_TRADES | QUANTITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/quantity | |
| quantityWashSaleEligible | Optional | decimal | in_qty_wash_sale_eligible | F | TRADESDBO | PENDING_TRADES | QTY_WASH_SALE_ELIGIBLE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/quantityWashSaleEligible | |
| reasonCode1 | Optional | string | 3884 | in_reason_code1 | S | TRADESDBO | PENDING_TRADES | REASON_CODE1 | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/reasonCode1 |
| reasonCode2 | Optional | string | 3885 | in_reason_code2 | S | TRADESDBO | PENDING_TRADES | REASON_CODE2 | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/reasonCode2 |
| reasonCode3 | Optional | string | 3886 | in_reason_code3 | S | TRADESDBO | PENDING_TRADES | REASON_CODE3 | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/reasonCode3 |
| reasonCode4 | Optional | string | 3887 | in_reason_code4 | S | TRADESDBO | PENDING_TRADES | REASON_CODE4 | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/reasonCode4 |
| reasonCode5 | Optional | string | 3888 | in_reason_code5 | S | TRADESDBO | PENDING_TRADES | REASON_CODE5 | VARCHAR2(20) | EagleML/warehouseTransaction/warehousePendingTrade/reasonCode5 |
| reclaimAmountBase | Optional | decimal | 851 | in_reclaim_amount_base | F | TRADESDBO | PENDING_TRADES | RECLAIM_AMOUNT_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/reclaimAmountBase |
| reclaimAmountLocal | Optional | decimal | 852 | in_reclaim_amount_local | F | TRADESDBO | PENDING_TRADES | RECLAIM_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/reclaimAmountLocal |
| recordPayAccount1 | Optional | string | 2276 | in_recd_pay_acct1 | S | TRADESDBO | PENDING_TRADES | RECD_PAY_ACCT1 | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/recordPayAccount1 |
| recordPayAccount2 | Optional | string | 2277 | in_recd_pay_acct2 | S | TRADESDBO | PENDING_TRADES | RECD_PAY_ACCT2 | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/recordPayAccount2 |
| recordPayEventType | Optional | string | 1826 | in_recd_pay_event_type | S | TRADESDBO | PENDING_TRADES | RECD_PAY_EVENT_TYPE | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/recordPayEventType |
| recordPayPostingPlanType | Optional | string | 1831 | in_recd_pay_posting_plan_typ | S | TRADESDBO | PENDING_TRADES | RECD_PAY_POSTING_PLAN_TYP | VARCHAR2(50) | EagleML/warehouseTransaction/warehousePendingTrade/recordPayPostingPlanType |
| retroIndicator | Optional | normalizedString | 11018 | in_retro_ind | S | TRADESDBO | PENDING_TRADES | RETRO_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/retroIndicator |
| sellToBaseFxRate | Optional | decimal | in_sell_to_base_fx_rate | F | TRADESDBO | PENDING_TRADES | SELL_TO_BASE_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/sellToBaseFxRate | |
| sellToBuyFxRate | Optional | decimal | in_sell_to_buy_fx_rate | F | TRADESDBO | PENDING_TRADES | SELL_TO_BUY_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/sellToBuyFxRate | |
| settlementAmountSettle | Optional | decimal | in_settlement_amount_settle | F | TRADESDBO | PENDING_TRADES | SETTLEMENT_AMOUNT_SETTLE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/settlementAmountSettle | |
| settlementCurrency | Optional | normalizedString | 63 | in_settlement_currency | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_CURRENCY | VARCHAR2(3) | EagleML/warehouseTransaction/warehousePendingTrade/settlementCurrency |
| settlementDate | Optional | date | in_settlement_date | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/settlementDate | |
| settlementInstructions1 | Optional | string | 1897 | in_settlement_instructions1 | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_INSTRUCTIONS1 | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions1 |
| settlementInstructions2 | Optional | string | 1898 | in_settlement_instructions2 | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_INSTRUCTIONS2 | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions2 |
| settlementInstructions3 | Optional | string | 1899 | in_settlement_instructions3 | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_INSTRUCTIONS3 | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions3 |
| settlementInstructions4 | Optional | string | 1900 | in_settlement_instructions4 | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_INSTRUCTIONS4 | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/settlementInstructions4 |
| settlementLocation | Optional | string | 43 | in_settlement_location | S | TRADESDBO | PENDING_TRADES | SETTLEMENT_LOCATION | VARCHAR2(12) | EagleML/warehouseTransaction/warehousePendingTrade/settlementLocation |
| settleToBaseFxRate | Optional | decimal | in_settle_to_base_fx_rate | F | TRADESDBO | PENDING_TRADES | SETTLE_TO_BASE_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/settleToBaseFxRate | |
| stampDutyTaxLocal | Optional | decimal | 51 | in_stamp_duty_tax_local | F | TRADESDBO | PENDING_TRADES | STAMP_DUTY_TAX_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/stampDutyTaxLocal |
| targetEventId | Optional | string | 26 | in_target_event_id | S | TRADESDBO | PENDING_TRADES | TARGET_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/targetEventId |
| targetOrigEventId | Optional | string | 5032 | in_target_orig_event_id | S | TRADESDBO | PENDING_TRADES | TARGET_ORIG_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/targetOrigEventId |
| targetPurchaseDate | Optional | date | 914 | in_target_purchase_date | S | TRADESDBO | PENDING_TRADES | TARGET_PURCHASE_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/targetPurchaseDate |
| targetPurchasePrice | Optional | decimal | 915 | in_target_purchase_price | F | TRADESDBO | PENDING_TRADES | TARGET_PURCHASE_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/targetPurchasePrice |
| targetTradeTicketNumber | Optional | string | 762 | in_target_trd_ticket_number | S | TRADESDBO | PENDING_TRADES | TARGET_TRD_TICKET_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/targetTradeTicketNumber |
| taxAmountLocal | Optional | decimal | 1733 | in_tax_amount_local | F | TRADESDBO | PENDING_TRADES | TAX_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/taxAmountLocal |
| taxExpenseBase | Optional | decimal | 854 | in_tax_expense_base | F | TRADESDBO | PENDING_TRADES | TAX_EXPENSE_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/taxExpenseBase |
| taxExpenseLocal | Optional | decimal | 853 | in_tax_expense_local | F | TRADESDBO | PENDING_TRADES | TAX_EXPENSE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/taxExpenseLocal |
| taxReclaimBase | Optional | decimal | in_tax_reclaim_base | F | TRADESDBO | PENDING_TRADES | TAX_RECLAIM_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/taxReclaimBase | |
| taxReclaimLocal | Optional | decimal | in_tax_reclaim_local | F | TRADESDBO | PENDING_TRADES | TAX_RECLAIM_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/taxReclaimLocal | |
| tbaCashflow | Optional | normalizedString | 9406 | in_tba_cashflow | S | TRADESDBO | PENDING_TRADES | TBA_CASHFLOW | VARCHAR2(3) | EagleML/warehouseTransaction/warehousePendingTrade/tbaCashflow |
| tbaIndicator | Optional | normalizedString | in_tba_indicator | S | TRADESDBO | PENDING_TRADES | TBA_INDICATOR | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/tbaIndicator | |
| tbaTradeId | Optional | string | in_tba_trade_id | S | TRADESDBO | PENDING_TRADES | TBA_TRADE_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/tbaTradeId | |
| termLoanExpenseL | Optional | decimal | 846 | in_term_loan_expense_l | F | TRADESDBO | PENDING_TRADES | TERM_LOAN_EXPENSE_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/termLoanExpenseL |
| termLoanFeeIncomeL | Optional | decimal | 844 | in_term_loan_fee_income_l | F | TRADESDBO | PENDING_TRADES | TERM_LOAN_FEE_INCOME_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/termLoanFeeIncomeL |
| toAccountBasis | Optional | string | in_to_acct_basis | S | TRADESDBO | PENDING_TRADES | TO_ACCT_BASIS | VARCHAR2(5) | EagleML/warehouseTransaction/warehousePendingTrade/toAccountBasis | |
| toAutoSettleInd | Optional | normalizedString | 333 | in_to_auto_settle_ind | S | TRADESDBO | PENDING_TRADES | TO_AUTO_SETTLE_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/toAutoSettleInd |
| toBaseCurrency | Optional | normalizedString | in_to_base_currency | S | TRADESDBO | PENDING_TRADES | TO_BASE_CURRENCY | VARCHAR2(3) | EagleML/warehouseTransaction/warehousePendingTrade/toBaseCurrency | |
| toCashEventType | Optional | string | 328 | in_to_cash_event_type | S | TRADESDBO | PENDING_TRADES | TO_CASH_EVENT_TYPE | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/toCashEventType |
| toCommissionAmountLocal | Optional | decimal | in_to_commission_amt_local | F | TRADESDBO | PENDING_TRADES | TO_COMMISSION_AMT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/toCommissionAmountLocal | |
| toCostMethod | Optional | normalizedString | 315 | in_to_cost_method | S | TRADESDBO | PENDING_TRADES | TO_COST_METHOD | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/toCostMethod |
| toEntityId | Optional | string | 11814 | in_to_entity_id | S | TRADESDBO | PENDING_TRADES | TO_ENTITY_ID | CHAR(8) | EagleML/warehouseTransaction/warehousePendingTrade/toEntityId |
| toExchangeFeeLocal | Optional | decimal | in_to_exchange_fee_local | F | TRADESDBO | PENDING_TRADES | TO_EXCHANGE_FEE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/toExchangeFeeLocal | |
| toLocalToBaseFxRate | Optional | decimal | in_to_local_to_base_fx_rate | F | TRADESDBO | PENDING_TRADES | TO_LOCAL_TO_BASE_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/toLocalToBaseFxRate | |
| toLongShortIndicator | Optional | normalizedString | 305 | in_to_long_short_indicator | S | TRADESDBO | PENDING_TRADES | TO_LONG_SHORT_INDICATOR | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/toLongShortIndicator |
| toLotSelectionMethod | Optional | normalizedString | 3277 | in_to_lot_selection_method | S | TRADESDBO | PENDING_TRADES | TO_LOT_SELECTION_METHOD | VARCHAR2(8) | EagleML/warehouseTransaction/warehousePendingTrade/toLotSelectionMethod |
| toNetAmountLocal | Optional | decimal | in_to_net_amount_local | F | TRADESDBO | PENDING_TRADES | TO_NET_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/toNetAmountLocal | |
| toQuantity | Optional | decimal | in_to_quantity | F | TRADESDBO | PENDING_TRADES | TO_QUANTITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/toQuantity | |
| toSecurityAlias | Optional | integer | in_to_security_alias | F | TRADESDBO | PENDING_TRADES | TO_SECURITY_ALIAS | NUMBER(38,0) | EagleML/warehouseTransaction/warehousePendingTrade/toSecurityAlias | |
| toSettlementCurrency | Optional | normalizedString | 8375 | in_to_settlement_currency | S | TRADESDBO | PENDING_TRADES | TO_SETTLEMENT_CURRENCY | VARCHAR2(3) | EagleML/warehouseTransaction/warehousePendingTrade/toSettlementCurrency |
| toSettleToBaseFxRate | Optional | decimal | in_to_settle_to_base_fx_rate | F | TRADESDBO | PENDING_TRADES | TO_SETTLE_TO_BASE_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/toSettleToBaseFxRate | |
| toTargetEventId | Optional | string | 345 | in_to_target_event_id | S | TRADESDBO | PENDING_TRADES | TO_TARGET_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/toTargetEventId |
| toWashSaleEligibleIndicator | Optional | normalizedString | 334 | in_to_wash_sale_elgbl_ind | S | TRADESDBO | PENDING_TRADES | TO_WASH_SALE_ELGBL_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/toWashSaleEligibleIndicator |
| tradedInterestBase | Optional | decimal | 475 | in_traded_interest_base | F | TRADESDBO | PENDING_TRADES | TRADED_INTEREST_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/tradedInterestBase |
| tradedInterestLocal | Optional | decimal | 49 | in_traded_interest_local | F | TRADESDBO | PENDING_TRADES | TRADED_INTEREST_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/tradedInterestLocal |
| tradeStatus | Optional | string | 3720 | in_trade_status | S | TRADESDBO | PENDING_TRADES | TRADE_STATUS | VARCHAR2(15) | EagleML/warehouseTransaction/warehousePendingTrade/tradeStatus |
| tradeTicketNumber | Optional | string | 761 | in_trade_ticket_number | S | TRADESDBO | PENDING_TRADES | TRADE_TICKET_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/tradeTicketNumber |
| tradeYield | Optional | decimal | 9430 | in_trade_yield | F | TRADESDBO | PENDING_TRADES | TRADE_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/tradeYield |
| transactionNotes | Optional | string | in_transaction_notes | S | TRADESDBO | PENDING_TRADES | TRANSACTION_NOTES | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/transactionNotes | |
| washsaleCloseQuantity | Optional | decimal | 3865 | in_ws_close_quantity | F | TRADESDBO | PENDING_TRADES | WASHSALE_CLOSE_QUANTITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleCloseQuantity |
| washsaleClsTradeDate | Optional | date | 3863 | in_ws_cls_trade_date | S | TRADESDBO | PENDING_TRADES | WASHSALE_CLS_TRADE_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleClsTradeDate |
| washsaleClsTradeTicketNumber | Optional | string | 3861 | in_ws_cls_trd_tckt_number | S | TRADESDBO | PENDING_TRADES | WS_CLS_TRD_TCKT_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleClsTradeTicketNumber |
| washsaleDisallowanceCurrentB | Optional | decimal | 3850 | in_ws_disallowance_current_b | F | TRADESDBO | PENDING_TRADES | WS_DISALLOWANCE_CURRENT_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceCurrentB |
| washsaleDisallowanceCurrentL | Optional | decimal | 3849 | in_ws_disallowance_current_l | F | TRADESDBO | PENDING_TRADES | WS_DISALLOWANCE_CURRENT_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceCurrentL |
| washsaleDisallowanceTerm | Optional | normalizedString | 3851 | in_ws_disallowance_term | S | TRADESDBO | PENDING_TRADES | WS_DISALLOWANCE_TERM | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceTerm |
| washsaleDisallowanceType | Optional | string | 3866 | in_ws_disallowance_type | S | TRADESDBO | PENDING_TRADES | WS_DISALLOWANCE_TYPE | VARCHAR2(10) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleDisallowanceType |
| washSaleEligibleIndicator | Optional | normalizedString | 59 | in_wash_sale_elgb_indi | S | TRADESDBO | PENDING_TRADES | WASH_SALE_ELGBL_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehousePendingTrade/washSaleEligibleIndicator |
| washsaleOpenHoldingDate | Optional | date | 3988 | in_ws_open_holding_date | S | TRADESDBO | PENDING_TRADES | WS_OPEN_HOLDING_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleOpenHoldingDate |
| washsaleOrigAcquireDate | Optional | date | 3864 | in_ws_orig_acq_date | S | TRADESDBO | PENDING_TRADES | WASHSALE_ORIG_ACQ_DATE | DATE(7) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleOrigAcquireDate |
| washsaleOrigOpenEventId | Optional | string | 3862 | in_ws_orig_open_evt_id | S | TRADESDBO | PENDING_TRADES | WASHSALE_ORIG_OPEN_EVT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehousePendingTrade/washsaleOrigOpenEventId |
| userChar1 | Optional | string | 1887 | in_user_char1 | S | TRADESDBO | PENDING_TRADES | USER_CHAR1 | VARCHAR2(30) | EagleML/warehouseTransaction/warehousePendingTrade/userChar1 |
| userChar2 | Optional | string | 1888 | in_user_char2 | S | TRADESDBO | PENDING_TRADES | USER_CHAR2 | VARCHAR2(30) | EagleML/warehouseTransaction/warehousePendingTrade/userChar2 |
| userChar3 | Optional | string | 1889 | in_user_char3 | S | TRADESDBO | PENDING_TRADES | USER_CHAR3 | VARCHAR2(30) | EagleML/warehouseTransaction/warehousePendingTrade/userChar3 |
| userFloat1 | Optional | decimal | in_user_float1 | F | TRADESDBO | PENDING_TRADES | USER_FLOAT1 | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/userFloat1 | |
| userFloat2 | Optional | decimal | in_user_float2 | F | TRADESDBO | PENDING_TRADES | USER_FLOAT2 | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/userFloat2 | |
| userFloat3 | Optional | decimal | 1326 | in_user_float3 | F | TRADESDBO | PENDING_TRADES | USER_FLOAT3 | NUMBER(38,12) | EagleML/warehouseTransaction/warehousePendingTrade/userFloat3 |
| pendingTradeId | Required | integer | 3696 | in_pending_trade_id | F | TRADESDBO | PENDING_TRADES | PENDING_TRADE_ID | NUMBER(38,0) | EagleML/warehouseTransaction/warehousePendingTrade/pendingTradeId |
General
Content
Integrations