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 |