Warehouse Pending Trade Data Map
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
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 |
EagleML/warehouseTransaction/warehousePendingTrade/ | ||||||||||
Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehousePendingTrade/ | |||||||||
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 |
cashAccountName | Optional | string | 11696 | in_cash_acct_name | S | TRADESDBO | PENDING_TRADES | CASH_ACCT_NAME | Â | EagleML/warehouseTransaction/warehousePendingTrade/cashAccountName |
cashAccountNumber | Optional | string | 11697 | in_cash_acct | S | TRADESDBO | PENDING_TRADES | CASH_ACCT | Â | EagleML/warehouseTransaction/warehousePendingTrade/cashAccountNumber |
cashAccountAlias | Optional | integer | 11698 | in_cash_acct_alias | F | TRADESDBO | PENDING_TRADES | CASH_ACCT_ALIAS | Â | EagleML/warehouseTransaction/warehousePendingTrade/cashAccountAlias |
performanceEffectiveDate | Optional | date | 12392 | in_perf_eff_date | S | TRADESDBO | PENDING_TRADES | PERFORMANCE_EFF_DATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/performanceEffectiveDate |
estarFinEventInstance | Optional | integer | 4256 | in_estar_fin_evt_inst | F | TRADESDBO | PENDING_TRADES | ESTAR_FIN_EVT_INST | Â | EagleML/warehouseTransaction/warehousePendingTrade/estarFinEventInstance |
targetMttype | Optional | string | 5523 | in_target_mttype | S | TRADESDBO | PENDING_TRADES | TARGET_MTTYPE | Â | EagleML/warehouseTransaction/warehousePendingTrade/targetMttype |
consolidatedFlag | Optional | string | 12874 | in_consolidated_flag | S | TRADESDBO | PENDING_TRADES | CONSOLIDATED_FLAG | Â | EagleML/warehouseTransaction/warehousePendingTrade/consolidatedFlag |
pendingCancelReleaseStrategy | Optional | string | 16621 | in_pendcxl_release_strategy | S | TRADESDBO | PENDING_TRADES | PENDCXL_RELEASE_STRATEGY | Â | EagleML/warehouseTransaction/warehousePendingTrade/pendingCancelReleaseStrategy |
duplicateToPendingFlag | Optional | YesNoOptionEnum | 16622 | in_duplicate_to_pend_flag | S | TRADESDBO | PENDING_TRADES | DUPLICATE_TO_PEND_FLAG | Â | EagleML/warehouseTransaction/warehousePendingTrade/duplicateToPendingFlag |
cpSwapRatio | Optional | decimal | 61 | in_cp_swap_ratio | F | TRADESDBO | PENDING_TRADES | CP_SWAP_RATIO | Â | EagleML/warehouseTransaction/warehousePendingTrade/cpSwapRatio |
srcSysC | Optional | string | 98 | in_src_sys_c | S | TRADESDBO | PENDING_TRADES | SRC_SYS_C | Â | EagleML/warehouseTransaction/warehousePendingTrade/srcSysC |
lastCloseAdjustmentDate | Optional | date | 139 | in_last_cls_adj_date | S | TRADESDBO | PENDING_TRADES | LAST_CLS_ADJ_DATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/lastCloseAdjustmentDate |
toFmvPrice | Optional | decimal | 319 | in_to_fmv_price | F | TRADESDBO | PENDING_TRADES | TO_FMV_PRICE | Â | EagleML/warehouseTransaction/warehousePendingTrade/toFmvPrice |
percentageParFlag | Optional | string | 739 | in_percentage_par_flag | S | TRADESDBO | PENDING_TRADES | PERCENTAGE_PAR_FLAG | Â | EagleML/warehouseTransaction/warehousePendingTrade/percentageParFlag |
ptIssuerId | Optional | string | 1144 | in_issuer_id | S | TRADESDBO | PENDING_TRADES | ISSUER_ID | Â | EagleML/warehouseTransaction/warehousePendingTrade/ptIssuerId |
firstPeriodCouponRate | Optional | decimal | 1360 | in_first_period_coupon_rate | F | TRADESDBO | PENDING_TRADES | FIRST_PERIOD_COUPON_RATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/firstPeriodCouponRate |
accrualConventionOffsetOverride | Optional | string | 1604 | in_accr_conv_offset_override | S | TRADESDBO | PENDING_TRADES | ACCR_CONV_OFFSET_OVERRIDE | Â | EagleML/warehouseTransaction/warehousePendingTrade/accrualConventionOffsetOverride |
marketValueFlag | Optional | string | 1872 | in_market_val_flag | S | TRADESDBO | PENDING_TRADES | MARKET_VAL_FLAG | Â | EagleML/warehouseTransaction/warehousePendingTrade/marketValueFlag |
cpSubPriority | Optional | integer | 3961 | in_cp_sub_priority | F | TRADESDBO | PENDING_TRADES | CP_SUB_PRIORITY | Â | EagleML/warehouseTransaction/warehousePendingTrade/cpSubPriority |
swapFeeSettlement | Optional | decimal | 4404 | in_swap_fee_s | F | TRADESDBO | PENDING_TRADES | SWAP_FEE_S | Â | EagleML/warehouseTransaction/warehousePendingTrade/swapFeeSettlement |
lotDatedDate | Optional | date | 4411 | in_lot_dated_dt | S | TRADESDBO | PENDING_TRADES | LOT_DATED_DT | Â | EagleML/warehouseTransaction/warehousePendingTrade/lotDatedDate |
ptPayReceiveIndicator | Optional | string | 4590 | in_pay_receive_ind | S | TRADESDBO | PENDING_TRADES | PAY_RECEIVE_IND | Â | EagleML/warehouseTransaction/warehousePendingTrade/ptPayReceiveIndicator |
marketLotIndicator | Optional | string | 5012 | in_market_lot_indicator | S | TRADESDBO | PENDING_TRADES | MARKET_LOT_INDICATOR | Â | EagleML/warehouseTransaction/warehousePendingTrade/marketLotIndicator |
payingLegForwardUnits | Optional | decimal | 8317 | in_paying_leg_fwd_units | F | TRADESDBO | PENDING_TRADES | PAYING_LEG_FWD_UNITS | Â | EagleML/warehouseTransaction/warehousePendingTrade/payingLegForwardUnits |
receivingLegForwardUnits | Optional | decimal | 8318 | in_receiving_leg_fwd_units | F | TRADESDBO | PENDING_TRADES | RECEIVING_LEG_FWD_UNITS | Â | EagleML/warehouseTransaction/warehousePendingTrade/receivingLegForwardUnits |
initialExchangeOfPrincipal | Optional | string | 8554 | in_init_exchg_prin | S | TRADESDBO | PENDING_TRADES | INIT_EXCHG_PRIN | Â | EagleML/warehouseTransaction/warehousePendingTrade/initialExchangeOfPrincipal |
finalExchangeOfPrincipal | Optional | string | 8555 | in_final_exchg_prin | S | TRADESDBO | PENDING_TRADES | FINAL_EXCHG_PRIN | Â | EagleML/warehouseTransaction/warehousePendingTrade/finalExchangeOfPrincipal |
regulatoryIntent | Optional | normalizedString | 8915 | in_regulatory_intent | S | TRADESDBO | PENDING_TRADES | REGULATORY_INTENT | Â | EagleML/warehouseTransaction/warehousePendingTrade/regulatoryIntent |
holdingTerm | Optional | normalizedString | 9091 | in_holding_term | S | TRADESDBO | PENDING_TRADES | HOLDING_TERM | Â | EagleML/warehouseTransaction/warehousePendingTrade/holdingTerm |
feeSettlementDate | Optional | date | 9357 | in_fee_settlement_date | S | TRADESDBO | PENDING_TRADES | FEE_SETTLEMENT_DATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/feeSettlementDate |
commissionSettlementDate | Optional | date | 11579 | in_comm_settlement_date | S | TRADESDBO | PENDING_TRADES | COMM_SETTLEMENT_DATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/commissionSettlementDate |
commissionSettleSeparate | Optional | string | 12860 | in_comm_settle_separate | S | TRADESDBO | PENDING_TRADES | COMM_SETTLE_SEPARATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/commissionSettleSeparate |
toBrokerCode | Optional | string | 12881 | in_to_broker_code | S | TRADESDBO | PENDING_TRADES | TO_BROKER_CODE | Â | EagleML/warehouseTransaction/warehousePendingTrade/toBrokerCode |
toBroker | Optional | string | 12882 | in_to_broker | S | TRADESDBO | PENDING_TRADES | TO_BROKER | Â | EagleML/warehouseTransaction/warehousePendingTrade/toBroker |
toTradeTicketNumber | Optional | string | 12883 | in_to_trade_ticket_number | S | TRADESDBO | PENDING_TRADES | TO_TRADE_TICKET_NUMBER | Â | EagleML/warehouseTransaction/warehousePendingTrade/toTradeTicketNumber |
toUserDefinedFloat1 | Optional | decimal | 12884 | in_to_user_defined_float1 | F | TRADESDBO | PENDING_TRADES | TO_USER_DEFINED_FLOAT1 | Â | EagleML/warehouseTransaction/warehousePendingTrade/toUserDefinedFloat1 |
toUserDefinedFloat2 | Optional | decimal | 12885 | in_to_user_defined_float2 | F | TRADESDBO | PENDING_TRADES | TO_USER_DEFINED_FLOAT2 | Â | EagleML/warehouseTransaction/warehousePendingTrade/toUserDefinedFloat2 |
toUserDefinedFloat3 | Optional | decimal | 12886 | in_to_user_defined_float3 | F | TRADESDBO | PENDING_TRADES | TO_USER_DEFINED_FLOAT3 | Â | EagleML/warehouseTransaction/warehousePendingTrade/toUserDefinedFloat3 |
prorataNclossFlag | Optional | YesNoOptionEnum | 16157 | in_prorata_ncloss_flag | S | TRADESDBO | PENDING_TRADES | PRORATA_NCLOSS_FLAG | Â | EagleML/warehouseTransaction/warehousePendingTrade/prorataNclossFlag |
ptReviewRequired | Optional | string | 17022 | in_pt_review_required | S | TRADESDBO | PENDING_TRADES | PT_REVIEW_REQUIRED | Â | EagleML/warehouseTransaction/warehousePendingTrade/ptReviewRequired |
ptRuleInstance | Optional | integer | 17027 | in_pt_rule_instance | F | TRADESDBO | PENDING_TRADES | PT_RULE_INSTANCE | Â | EagleML/warehouseTransaction/warehousePendingTrade/ptRuleInstance |
bypassEarningsReplay | Optional | string | 11793 | in_bypass_earnings_replay | S | TRADESDBO | PENDING_TRADES | BYPASS_EARNINGS_REPLAY | Â | EagleML/warehouseTransaction/warehousePendingTrade/bypassEarningsReplay |
fprInstance | Optional | integer | 3251 | in_fpr_instance | F | TRADESDBO | PENDING_TRADES | FPR_INSTANCE | Â | EagleML/warehouseTransaction/warehousePendingTrade/fprInstance |
bookCostLocal | Optional | decimal | 17039 | in_book_cost_l | F | TRADESDBO | PENDING_TRADES | BOOK_COST_L | Â | EagleML/warehouseTransaction/warehousePendingTrade/bookCostLocal |
bookCostBase | Optional | decimal | 17038 | in_book_cost_b | F | TRADESDBO | PENDING_TRADES | BOOK_COST_B | Â | EagleML/warehouseTransaction/warehousePendingTrade/bookCostBase |
sleeveId | Optional | string | 1606 | in_sleeve_id | S | TRADESDBO | PENDING_TRADES | SLEEVE_ID | Â | EagleML/warehouseTransaction/warehousePendingTrade/sleeveId |
longShortSubC | Optional | string | 20 | in_lng_sht_sub_c | S | TRADESDBO | PENDING_TRADES | LNG_SHT_SUB_C | Â | EagleML/warehouseTransaction/warehousePendingTrade/longShortSubC |
eventSequence | Optional | integer | 126 | in_event_sequence | F | TRADESDBO | PENDING_TRADES | EVENT_SEQUENCE | Â | EagleML/warehouseTransaction/warehousePendingTrade/eventSequence |
taxableIndicator | Optional | string | 3960 | in_taxable_ind | S | TRADESDBO | PENDING_TRADES | TAXABLE_IND | Â | EagleML/warehouseTransaction/warehousePendingTrade/taxableIndicator |
ind988 | Optional | string | 5815 | in_ind_988 | S | TRADESDBO | PENDING_TRADES | IND_988 | Â | EagleML/warehouseTransaction/warehousePendingTrade/ind988 |
clientEventType | Optional | string | 17294 | in_client_event_type | S | TRADESDBO | PENDING_TRADES | CLIENT_EVENT_TYPE | Â | EagleML/warehouseTransaction/warehousePendingTrade/clientEventType |
toEventId | Optional | string | 312 | in_to_event_id | S | TRADESDBO | PENDING_TRADES | TO_EVENT_ID | Â | EagleML/warehouseTransaction/warehousePendingTrade/toEventId |
linkedIndicator | Optional | integer | 412 | in_linked_ind | F | TRADESDBO | PENDING_TRADES | LINKED_IND | Â | EagleML/warehouseTransaction/warehousePendingTrade/linkedIndicator |
tradeDate | Optional | date | 35 | in_trade_date | S | TRADESDBO | PENDING_TRADES | ORIG_ACQ_DATE | Â | EagleML/warehouseTransaction/warehousePendingTrade/tradeDate |
premiumAllocatedLocal | Optional | decimal | 203 | in_premium_alloc_l | F | TRADESDBO | PENDING_TRADES | PREMIUM_ALLOC_L | Â | EagleML/warehouseTransaction/warehousePendingTrade/premiumAllocatedLocal |
premiumAllocatedBase | Optional | decimal | 204 | in_premium_alloc_b | F | TRADESDBO | PENDING_TRADES | PREMIUM_ALLOC_B | Â | EagleML/warehouseTransaction/warehousePendingTrade/premiumAllocatedBase |
Â