...
...
| Anchor |
|---|
| sourceLongShortInd_and_longShortInd |
|---|
| sourceLongShortInd_and_longShortInd |
|---|
|
sourceLongShortInd and longShortIndicator are mapped into the same tag15 in_long_short_ind. If both nodes are not null in the incoming message, the value of longShortIndicator has a higher priority.| Anchor |
|---|
| procedureMode_and_procedureFlag_note |
|---|
| procedureMode_and_procedureFlag_note |
|---|
|
procedureMode and procedureFlag specify type of action (INSERT, UPDATE, DELETE)
|
| Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|---|
| objectType |
Optional |
| ObjectTypeEnum |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/objectType |
| objectId |
Optional |
| ObjectId |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/objectId |
| objectDescription |
Optional |
| FeedTypeEnum |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/objectDescription |
| updateTimestamp |
Optional |
| dateTime |
|
|
| HOLDINGDBO | LOT_LEVEL_POSITION | UPDATE_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/updateTimestamp |
| customElements | Not recommended | CustomElements - Complex Type |
|
|
| reserved for customizations |
| EagleML/warehouseTransaction/warehouseOpenLot/customElements |
| sourceName |
Optional |
| string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/warehouseTransaction/warehouseOpenLot/sourceName |
| updateSource |
Optional |
| string | 944 | in_update_source | S | HOLDINGDBO | LOT_LEVEL_POSITION | UPDATE_SOURCE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/updateSource |
| batchCollectErrorsFlag |
Optional |
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/batchCollectErrorsFlag |
| singleRowCommitFlag |
Optional |
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/singleRowCommitFlag |
| linkEventId |
Optional |
| TransactionId | 28 | in_link_event_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | LINK_EVENT_ID | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseOpenLot/linkEventId |
| localCurrency |
Optional |
| CurrencyCode | 85 | in_local_currency | S | HOLDINGDBO | LOT_LEVEL_POSITION | LOCAL_CURRENCY | CHAR(3) | EagleML/warehouseTransaction/warehouseOpenLot/localCurrency |
| effectiveDate |
Optional |
| date | 221 | in_effective_date | S | HOLDINGDBO | POSITION_COST_LOT | EFFECTIVE_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/effectiveDate |
| maturityDate |
Optional| Required | date |
|
|
| not stored in DB - needed for resolution logics |
| EagleML/warehouseTransaction/warehouseOpenLot/maturityDate |
| Anchor |
|---|
| longShortIndicator |
|---|
| longShortIndicator |
|---|
|
longShortIndicator | Optional
(see |
more details| Note) | LongShortIndicatorEnum | 15 | in_long_short_ind | S | HOLDINGDBO | LOT_LEVEL_POSITION | LONG_SHORT_IND | CHAR(4) | EagleML/warehouseTransaction/warehouseOpenLot/longShortIndicator |
| Entity Common Id Model | EagleML/warehouseTransaction/warehouseOpenLot/ |
| Entity Properties Model (extract only) | EagleML/warehouseTransaction/warehouseOpenLot/ |
| accountingBasis |
Optional |
| string | 21 | IN_ACCOUNT | S | HOLDINGDBO | POSITION | ACCT_BASIS | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseOpenLot/accountingBasis |
| entityIDLookupSwitch |
Optional |
| LookupSwitchEnum | 989 |
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/entityIDLookupSwitch |
| entityNameLookupSwitch |
Optional |
| LookupSwitchEnum | 990 |
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/entityNameLookupSwitch |
| securityQueryFlag |
Optional |
| YesNoOptionEnum | 1256 |
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/securityQueryFlag |
| sourceLookupSwitch |
Optional |
| LookupSwitchEnum |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/sourceLookupSwitch |
| Anchor |
|---|
| procedureMode |
|---|
| procedureMode |
|---|
|
procedureMode | Optional
(see |
more details| Note) | ProcedureFlagTypeEnum | 1078 | in_procedure_mode | S | not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/procedureMode |
| Anchor |
|---|
| procedureFlag |
|---|
| procedureFlag |
|---|
|
procedureFlag | Optional
(see |
more detailsOptional |
| CurrencyCode | 86 | in_base_currency | S | HOLDINGDBO | LOT_LEVEL_POSITION | CURRENCY | CHAR(3) | EagleML/warehouseTransaction/warehouseOpenLot/baseCurrency |
| srcIntfcInst |
Optional |
| decimal | 1168 |
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/srcIntfcInst |
| transactionType |
Optional |
| string | 2283 | in_trans_type | S | HOLDINGDBO | LOT_LEVEL_POSITION | TRANS_TYPE | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseOpenLot/transactionType |
| rollupFlag |
Optional |
| YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/rollupFlag |
| urglSecurityBase |
Optional |
| decimal | 491 | in_unrealized_sec_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | UNREALIZED_SEC_GL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/urglSecurityBase |
| urglCurrencyBase |
Optional |
| decimal | 493 | in_unrealized_curr_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | UNREALIZED_CURR_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/urglCurrencyBase |
| updateDate |
Optional |
| date | 1106 | in_update_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | UPDATE_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/updateDate |
| closeOpenEventId |
Optional |
| TransactionId | 181 |
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/closeOpenEventId |
| closeEventId |
Optional |
| TransactionId | 182 |
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/closeEventId |
| closeIndexWeight |
Optional |
| decimal | 4483 | in_indx_weight | N | HOLDINGDBO | LOT_LEVEL_POSITION | INDX_WEIGHT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeIndexWeight |
| closeTipsIncomeLtdLocal |
Optional |
| decimal | 4440 | in_tip_ltd_income_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | TIP_LTD_INCOME_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdLocal |
| closeTipsIncomeLtdBase |
Optional |
| decimal | 4445 | in_tip_ltd_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | TIP_LTD_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdBase |
| marketValueLocal |
Optional |
| decimal | 487 | in_local_market_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | LOCAL_MARKET_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/marketValueLocal |
| marketValueBase |
Optional |
| decimal | 488 | in_market_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | MARKET_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/marketValueBase |
| marketValueIncomeLocal |
Optional |
| decimal | 9424 | in_market_value_income_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | MARKET_VALUE_INCOME_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncomeLocal |
| notionalMarketValueBase |
Optional |
| decimal | 10794 | in_notional_market_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueBase |
| notionalUnrealizedGlBase |
Optional |
| decimal | 10796 | in_notional_unrealized_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_UNREALIZED_GL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlBase |
| notionalCostLocal |
Optional |
| decimal | 10791 | in_notional_cost_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_COST_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalCostLocal |
| notionalCostBase |
Optional |
| decimal | 10792 | in_notional_cost | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_COST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalCostBase |
| notionalMarketValueLocal |
Optional |
| decimal | 10793 | in_notional_market_value_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_MARKET_VALUE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueLocal |
| notionalUnrealizedGlLocal |
Optional |
| decimal | 10795 | in_notional_local_unrealiz_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_LOCAL_UNREALIZED_GL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlLocal |
| notionalUnrealizedCurrGl |
Optional |
| decimal | 10797 | in_notional_unrealized_curr_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_UNREALIZED_CURR_GL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedCurrGl |
| notionalUnrealizedSecGl |
Optional |
| decimal | 10798 | in_notional_unrealized_sec_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | NOTIONAL_UNREALIZED_SEC_GL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedSecGl |
| Anchor |
|---|
| sourceLongShortInd |
|---|
| sourceLongShortInd |
|---|
|
sourceLongShortInd | Optional
(see |
more details| Note) | string | 15 | in_long_short_ind | S | HOLDINGDBO | LOT_LEVEL_POSITION | LONG_SHORT_IND | CHAR(4) | EagleML/warehouseTransaction/warehouseOpenLot/sourceLongShortInd |
| settledQuantity |
Optional |
| decimal | 274 | in_settle_quantity | N | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLE_QUANTITY | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledQuantity |
| settleLocation |
Optional |
| string | 43 | in_settlement_location | S | HOLDINGDBO | POSITION_COST_LOT | SETTLEMENT_LOCATION | CHAR(12) | EagleML/warehouseTransaction/warehouseOpenLot/settleLocation |
| accountingDate |
Optional |
| date | 36 | in_accounting_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | ACCOUNTING_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/accountingDate |
| amortizedLtdBase |
Optional |
| decimal | 595 | in_amortization_ltd_base | N | HOLDINGDBO | LOT_LEVEL_POSITION | AMORTIZATION_LTD_BASE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/amortizedLtdBase |
| amortizedLtdLocal |
Optional |
| decimal | 580 | in_amortization_ltd_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | AMORTIZATION_LTD_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/amortizedLtdLocal |
| amortizedPtdBase |
Optional |
| decimal | 598 | in_amort_ptd_base | N | HOLDINGDBO | POSITION_COST_LOT | AMORT_PTD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/amortizedPtdBase |
| amortizedPtdLocal |
Optional |
| decimal | 583 | in_amort_ptd_local | N | HOLDINGDBO | POSITION_COST_LOT | AMORT_PTD_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/amortizedPtdLocal |
| closeAmortizedLocal |
Optional |
| decimal | 521 | in_cls_amort_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | CLS_AMORT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeAmortizedLocal |
| closeAmortizedBase |
Optional |
| decimal | 522 | in_cls_amort_base | N | HOLDINGDBO | LOT_LEVEL_POSITION | CLS_AMORT_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeAmortizedBase |
| amortizedCostBase |
Optional |
| decimal | 2694 | in_amortized_cost | N | HOLDINGDBO | LOT_LEVEL_POSITION | AMORTIZED_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/amortizedCostBase |
| accruedInterestType |
Optional |
| string | 3715 | in_accrued_interest_type | S | HOLDINGDBO | LOT_LEVEL_POSITION | ACCRUED_INTEREST_TYPE | VARCHAR2(3) | EagleML/warehouseTransaction/warehouseOpenLot/accruedInterestType |
| accruedLtdBase |
Optional |
| decimal | 585 | in_accr_ltd_base | N | HOLDINGDBO | POSITION_COST_LOT | ACCR_LTD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/accruedLtdBase |
| accruedLtdLocal |
Optional |
| decimal | 462 | in_accr_ltd_local | N | HOLDINGDBO | POSITION_COST_LOT | ACCR_LTD_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/accruedLtdLocal |
| accruedIncomeLocal |
Optional |
| decimal | 718 | in_accrued_income_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | ACCRUED_INCOME_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/accruedIncomeLocal |
| accruedIncome |
Optional |
| decimal | 726 | in_accrued_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | ACCRUED_INCOME | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/accruedIncome |
| acquisitionCode |
Optional |
| string | 13044 | in_acquisition_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | ACQUISITION_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/acquisitionCode |
| currBuiltInGlSecurity |
Optional |
| decimal | 9761 | in_curr_builtin_gl_sec | N | HOLDINGDBO | LOT_LEVEL_POSITION | CURR_BUILTIN_GL_SEC | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlSecurity |
| currBuiltInGlCurrency |
Optional |
| decimal | 10917 | in_curr_builtin_gl_currency | N | HOLDINGDBO | LOT_LEVEL_POSITION | CURR_BUILTIN_GL_CURRENCY | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlCurrency |
| currBuiltInGlDeferred |
Optional |
| decimal | 10918 | in_curr_builtin_gl_deferred | N | HOLDINGDBO | LOT_LEVEL_POSITION | CURR_BUILTIN_GL_DEFERRED | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlDeferred |
| currBuiltInGlOid |
Optional |
| decimal | 10919 | in_curr_builtin_gl_oid | N | HOLDINGDBO | LOT_LEVEL_POSITION | CURR_BUILTIN_GL_OID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlOid |
| currBuiltInGlMktDisc |
Optional |
| decimal | 10920 | in_curr_builtin_gl_mkt_disc | N | HOLDINGDBO | LOT_LEVEL_POSITION | CURR_BUILTIN_GL_MKT_DISC | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/currBuiltInGlMktDisc |
| currFxRate |
Optional |
| decimal | 484 | in_curr_fx_rate | N | HOLDINGDBO | LOT_LEVEL_POSITION | CURR_FX_RATE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/currFxRate |
| departmentAcquisitionDate |
Optional |
| date | 7560 | in_department_acquisition_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | DEPARTMENT_ACQUISITION_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/departmentAcquisitionDate |
| expenses |
Optional |
| decimal | 48 | in_expenses | N | HOLDINGDBO | LOT_LEVEL_POSITION | EXPENSES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/expenses |
| exchangeRate |
Optional |
| decimal | 87 | in_exchange_rate | N | HOLDINGDBO | LOT_LEVEL_POSITION | EXCHANGE_RATE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/exchangeRate |
| executionBroker |
Optional |
| string | 10987 | in_execution_broker | S | HOLDINGDBO | LOT_LEVEL_POSITION | EXECUTION_BROKER | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseOpenLot/executionBroker |
| federalTaxCostUnknown |
Optional |
| string | 1545 | in_federal_tax_cost_unknown | S | HOLDINGDBO | LOT_LEVEL_POSITION | FEDERAL_TAX_COST_UNKNOWN | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/federalTaxCostUnknown |
| gaapPremDisInd |
Optional |
| string | 13048 | in_gaap_prem_disc_ind | S | HOLDINGDBO | POSITION_COST_LOT | GAAP_PREM_DISC_IND | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/gaapPremDisInd |
| gaapSettle |
Optional |
| date | 13992 | in_gaap_settle | S | HOLDINGDBO | POSITION_COST_LOT | GAAP_SETTLE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/gaapSettle |
| gaapTrade |
Optional |
| date | 13991 | in_gaap_trade | S | HOLDINGDBO | POSITION_COST_LOT | GAAP_TRADE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/gaapTrade |
| gaapTradeDate |
Optional |
| date | 9669 | in_gaap_trade_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | GAAP_TRADE_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/gaapTradeDate |
| idCost |
Optional |
| decimal | 247 | in_id_cost | N | HOLDINGDBO | LOT_LEVEL_POSITION | ID_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/idCost |
| incomeDue |
Optional |
| decimal | 114 | in_income_due | N | HOLDINGDBO | LOT_LEVEL_POSITION | INCOME_DUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/incomeDue |
| intPurchased |
Optional |
| decimal | 49 | in_int_purchased | N | HOLDINGDBO | LOT_LEVEL_POSITION | INT_PURCHASED | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/intPurchased |
| lastUpdateSrcDate |
Optional |
| date | 1775 | in_last_update_src_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | LAST_UPDATE_SRC_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/lastUpdateSrcDate |
| leg1NxtPmtAmt |
Optional |
| decimal | 1398 | in_leg1_nxt_pmt_amt | N | HOLDINGDBO | LOT_LEVEL_POSITION | LEG1_NXT_PMT_AMT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/leg1NxtPmtAmt |
| leg1NxtPmtDate |
Optional |
| date | 1397 | in_leg1_nxt_pmt_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | LEG1_NXT_PMT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/leg1NxtPmtDate |
| leg2NxtPmtAmt |
Optional |
| decimal | 1400 | in_leg2_nxt_pmt_amt | N | HOLDINGDBO | LOT_LEVEL_POSITION | LEG2_NXT_PMT_AMT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/leg2NxtPmtAmt |
| leg2NxtPmtDate |
Optional |
| date | 1399 | in_leg2_nxt_pmt_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | LEG2_NXT_PMT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/leg2NxtPmtDate |
| lastSaleSettle |
Optional |
| date | 13998 | in_last_sale_settle | S | HOLDINGDBO | POSITION_COST_LOT | LAST_SALE_SETTLE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/lastSaleSettle |
| locationCode |
Optional |
| string | 13039 | in_location_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | LOCATION_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/locationCode |
| lastSaleTrade |
Optional |
| date | 13997 | in_last_sale_trade | S | HOLDINGDBO | POSITION_COST_LOT | LAST_SALE_TRADE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/lastSaleTrade |
| managedFl |
Optional |
| string | 13038 | in_managed_fl | S | HOLDINGDBO | LOT_LEVEL_POSITION | MANAGED_FL | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/managedFl |
| marketValueIncome |
Optional |
| decimal | 9426 | in_market_value_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | MARKET_VALUE_INCOME | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncome |
| netcashflwsNxtPmt |
Optional |
| decimal |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmt |
| netcashflwsNxtPmtDate |
| date |
1402| 1373 | in_netcashflws_nxt_pmt_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | NETCASHFLWS_NXT_PMT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/ |
netcashflwsNxtPmtOptional| netcashflwsNxtPmtDate2 |
| date |
1373| 1402 | in_netcashflws_nxt_pmt |
_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | NETCASHFLWS_NXT_PMT |
_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/ |
netcashflwsNxtPmtDate| netcashflwsNxtPmtDate2 |
| otherCharges |
Optional |
| decimal | 51 | in_other_charges | N | HOLDINGDBO | POSITION_COST_LOT | OTHER_CHARGES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/otherCharges |
| originalAcquisitionCostBase |
Optional |
| decimal | 3746 | in_orig_acq_cost_base | N | HOLDINGDBO | POSITION_COST_LOT | ORIG_ACQ_COST_BASE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionCostBase |
| originalAcquisitionCostLocal |
Optional |
| decimal | 3747 | in_orig_acq_cost_local | N | HOLDINGDBO | POSITION_COST_LOT | ORIG_ACQ_COST_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionCostLocal |
| originalBuiltInGlMktDisc |
Optional |
| decimal | 10915 | in_orig_builtin_gl_mkt_disc | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_BUILTIN_GL_MKT_DISC | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlMktDisc |
| originalBuiltInGlCurrency |
Optional |
| decimal | 10912 | in_orig_builtin_gl_currency | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_BUILTIN_GL_CURRENCY | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlCurrency |
| originalBuiltInGlDeferred |
Optional |
| decimal | 10913 | in_orig_builtin_gl_deferred | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_BUILTIN_GL_DEFERRED | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlDeferred |
| originalBuiltInGlOid |
Optional |
| decimal | 10914 | in_orig_builtin_gl_oid | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_BUILTIN_GL_OID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlOid |
| originalBuiltInGlSecurity |
Optional |
| decimal | 9762 | in_orig_builtin_gl_sec | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_BUILTIN_GL_SEC | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalBuiltInGlSecurity |
| originalTradePrice |
Optional |
| decimal | 10906 | in_orig_trade_price | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_TRADE_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalTradePrice |
| originalSourceCode |
Optional |
| string | 9143 | in_original_source_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIGINAL_SOURCE_CODE | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseOpenLot/originalSourceCode |
| originalAcquisitionDate |
Optional |
| date | 216 | in_orig_acq_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_ACQ_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionDate |
| originalFace |
Optional |
| decimal | 41 | in_orig_face | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_FACE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalFace |
| origLotNumber |
Optional |
| string | 151 | in_orig_lot_number | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_LOT_NUMBER | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseOpenLot/origLotNumber |
| origOpenSettleDate |
Optional |
| date | 154 | in_orig_open_settle_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_OPEN_SETTLE_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/origOpenSettleDate |
| origEventId |
Optional |
| string | 457 | in_orig_event_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_EVENT_ID | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseOpenLot/origEventId |
| performanceFlow |
Optional |
| string | 4597 | in_performance_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | PERFORMANCE_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/performanceFlow |
| performancePrice |
Optional |
| decimal | 4598 | in_performance_price | N | HOLDINGDBO | LOT_LEVEL_POSITION | PERFORMANCE_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/performancePrice |
| performanceFlag |
Optional |
| YesNoOptionEnum | 9985 | in_perform_flag | S | HOLDINGDBO | POSITION | PERFORM_FLAG | CHAR(2) | EagleML/warehouseTransaction/warehouseOpenLot/performanceFlag |
| price |
Optional |
| decimal | 481 | in_price | N | HOLDINGDBO | LOT_LEVEL_POSITION | PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/price |
| smInactiveFlag |
Optional |
| YesNoOptionEnum | 11043 | in_sm_inactive_flag | S | not stored in DB - needed for resolution logics |
| EagleML/warehouseTransaction/warehouseOpenLot/smInactiveFlag |
| purchaseQuantity |
Optional |
| decimal | 159 | in_purchase_quantity | N | HOLDINGDBO | LOT_LEVEL_POSITION | PURCHASE_QUANTITY | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/purchaseQuantity |
| purYld |
Optional |
| decimal | 75 | in_pur_yld | N | HOLDINGDBO | LOT_LEVEL_POSITION | PUR_YLD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/purYld |
| pledgeFlag |
Optional |
| YesNoOptionEnum | 13046 | in_pledge_flag | S | HOLDINGDBO | LOT_LEVEL_POSITION | PLEDGE_FLAG | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/pledgeFlag |
| prYrAccrIncome |
Optional |
| decimal | 5801 | in_pr_yr_accr_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | PR_YR_ACCR_INCOME | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/prYrAccrIncome |
| purchAccruedInterestAmt |
Optional |
| decimal | 10736 | in_purch_accrued_interest_amt | N | HOLDINGDBO | LOT_LEVEL_POSITION | PURCH_ACCRUED_INTEREST_AMT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/purchAccruedInterestAmt |
| reason |
Optional |
| string | 56 | in_reason_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | REASON_CODE | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseOpenLot/reason |
| recParOrShares |
Optional |
| decimal | 122 | in_rec_par_or_shares | N | HOLDINGDBO | LOT_LEVEL_POSITION | REC_PAR_OR_SHARES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/recParOrShares |
| registrationCode |
Optional |
| string | 13040 | in_registration_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | REGISTRATION_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/registrationCode |
| reinvestCode |
Optional | string
| string | 13045 | in_reinvest_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | REINVEST_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/reinvestCode |
| restrictionCode |
Optional | | string | 13041 | in_restriction_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | RESTRICTION_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/restrictionCode |
| statPremDiscInd |
Optional |
| string | 13049 | in_stat_prem_disc_ind | S | HOLDINGDBO | POSITION_COST_LOT | STAT_PREM_DISC_IND | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/statPremDiscInd |
| statSettle |
Optional |
| date | 13994 | in_stat_settle | S | HOLDINGDBO | POSITION_COST_LOT | STAT_SETTLE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/statSettle |
| statTrade |
Optional |
| date | 13993 | in_stat_trade | S | HOLDINGDBO | POSITION_COST_LOT | STAT_TRADE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/statTrade |
| stateAcquisitionDate |
Optional |
| date | 3863 | in_state_acquisition_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | STATE_ACQUISITION_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/stateAcquisitionDate |
| taxAcquisitionDate |
Optional |
| date | 3864 | in_tax_acquisition_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | TAX_ACQUISITION_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/taxAcquisitionDate |
| taxPremDiscInd |
Optional |
| string | 13050 | in_tax_prem_disc_ind | S | HOLDINGDBO | POSITION_COST_LOT | TAX_PREM_DISC_IND | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/taxPremDiscInd |
| taxSettle |
Optional |
| date | 13996 | in_tax_settle | S | HOLDINGDBO | POSITION_COST_LOT | TAX_SETTLE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/taxSettle |
| taxStatus |
Optional |
| string | 1143 | in_tax_status | S | HOLDINGDBO | LOT_LEVEL_POSITION | TAX_STATUS | CHAR(10) | EagleML/warehouseTransaction/warehouseOpenLot/taxStatus |
| taxTrade |
Optional |
| date | 13995 | in_tax_trade | S | HOLDINGDBO | POSITION_COST_LOT | TAX_TRADE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/taxTrade |
| termIndicator |
Optional |
| decimal | 8133 | in_term_indicator | S | HOLDINGDBO | LOT_LEVEL_POSITION | TERM_INDICATOR | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/termIndicator |
| intReceived |
Optional |
| decimal | 475 | in_int_received | N | HOLDINGDBO | LOT_LEVEL_POSITION | INT_RECEIVED | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/intReceived |
| income |
Optional |
| decimal | 588 | in_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | INCOME | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/income |
| votingAuthorityCode |
Optional |
| string | 13043 | in_voting_authority_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | VOTING_AUTHORITY_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/votingAuthorityCode |
| clientId |
Optional |
| string | 1632 | in_client_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | CLIENT_ID | VARCHAR2(20) | EagleML/warehouseTransaction/warehouseOpenLot/clientId |
| covFlag |
Optional |
| YesNoOptionEnum | 2819 | in_cov_flag | S | HOLDINGDBO | LOT_LEVEL_POSITION | COV_FLAG | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseOpenLot/covFlag |
| eventSubPriority |
Optional |
| integer | 2862 | in_event_sub_priority | N | HOLDINGDBO | LOT_LEVEL_POSITION | EVENT_SUB_PRIORITY | NUMBER(38) | EagleML/warehouseTransaction/warehouseOpenLot/eventSubPriority |
| factor |
Optional |
| decimal | 91 | in_factor | N | HOLDINGDBO | POSITION_COST_LOT | FACTOR | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/factor |
| ioIssuerAlias |
Optional |
| string | 1147 | in_io_issuer_alias | S | HOLDINGDBO | LOT_LEVEL_POSITION | IO_ISSUER_ALIAS | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseOpenLot/ioIssuerAlias |
| ioIssuerId |
Optional |
| string | 1144 | in_io_issuer_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | IO_ISSUER_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseOpenLot/ioIssuerId |
| origAcctDate |
Optional |
| date | 31 | in_orig_acct_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_ACCT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/origAcctDate |
| origMonthlyAcctDate |
Optional |
| date | 5022 | in_orig_monthly_acct_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | ORIG_MONTHLY_ACCT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/origMonthlyAcctDate |
| parOrShares |
Optional |
| decimal | 163 | in_par_or_shares | N | HOLDINGDBO | LOT_LEVEL_POSITION | PAR_OR_SHARES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/parOrShares |
| originalQuantity |
Optional |
| decimal |
|
|
| not stored in DB |
| EagleML/warehouseTransaction/warehouseOpenLot/originalQuantity |
| pendingTradeId |
Optional |
| integer | 3696 | in_pending_trade_id | N | HOLDINGDBO | LOT_LEVEL_POSITION | PENDING_TRADE_ID |
| EagleML/warehouseTransaction/warehouseOpenLot/pendingTradeId |
| qtyWashSaleEligible |
Optional |
| decimal | 405 | in_qty_wash_sale_eligible | N | HOLDINGDBO | LOT_LEVEL_POSITION | QTY_WASH_SALE_ELIGIBLE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/qtyWashSaleEligible |
| strategy |
Optional |
| string | 2514 | in_strategy_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | STRATEGY_ID | VARCHAR2(20) | EagleML/warehouseTransaction/warehouseOpenLot/strategy |
| tradeYield |
Optional |
| decimal | 9430 | in_trade_yield | N | HOLDINGDBO | LOT_LEVEL_POSITION | TRADE_YIELD | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/tradeYield |
| washSaleEligibleInd |
Optional |
| string | 59 | in_wash_sale_eligible_ind | S | HOLDINGDBO | LOT_LEVEL_POSITION | WASH_SALE_ELIGIBLE_INDICATOR | CHAR(2) | EagleML/warehouseTransaction/warehouseOpenLot/washSaleEligibleInd |
| aiaNetB |
Optional |
| decimal | 11275 | in_aia_net_b | N | HOLDINGDBO | POSITION_COST_LOT | AIA_NET_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/aiaNetB |
| aiaNetL |
Optional |
| decimal | 11149 | in_aia_net_l | N | HOLDINGDBO | POSITION_COST_LOT | AIA_NET_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/aiaNetL |
| buySellFlag |
Optional |
| normalizedString | 3702 | in_buy_sell_flag | S | HOLDINGDBO | POSITION_COST_LOT | BUY_SELL_FLAG | VARCHAR2(4) | EagleML/warehouseTransaction/warehouseOpenLot/buySellFlag |
| bookValue |
Optional |
| decimal | 4602 | in_book_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | BOOK_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/bookValue |
| bookValueLocal |
Optional |
| decimal | 4601 | in_book_value_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | BOOK_VALUE_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/bookValueLocal |
| cpNetB |
Optional |
| decimal | 11245 | in_cp_net_b | N | HOLDINGDBO | POSITION_COST_LOT | CP_NET_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/cpNetB |
| cpNetL |
Optional |
| decimal | 11119 | in_cp_net_l | N | HOLDINGDBO | POSITION_COST_LOT | CP_NET_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/cpNetL |
| creditLossB |
Optional |
| decimal | 2784 | in_credit_loss_b | N | HOLDINGDBO | POSITION_COST_LOT | CREDIT_LOSS_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/creditLossB |
| creditLossL |
Optional |
| decimal | 2783 | in_credit_loss_l | N | HOLDINGDBO | POSITION_COST_LOT | CREDIT_LOSS_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/creditLossL |
| costBasisType |
Optional |
| string | 24 | in_cost_basis_type | S | HOLDINGDBO | POSITION_COST_LOT | COST_BASIS_TYPE | VARCHAR2(2) | EagleML/warehouseTransaction/warehouseOpenLot/costBasisType |
| futureFeeNetB |
Optional |
| decimal | 116 | in_future_fee_net_b | N | HOLDINGDBO | POSITION_COST_LOT | FUTURE_FEE_NET_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/futureFeeNetB |
| futureFeeNetL |
Optional |
| decimal | 11365 | in_future_fee_net_l | N | HOLDINGDBO | POSITION_COST_LOT | FUTURE_FEE_NET_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/futureFeeNetL |
| impairmentLtdBase |
Optional |
| decimal | 2701 | in_impairment_ltd_base | N | HOLDINGDBO | POSITION_COST_LOT | IMPAIRMENT_LTD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/impairmentLtdBase |
| impairmentLtdLocal |
Optional |
| decimal | 2700 | in_impairment_ltd_local | N | HOLDINGDBO | POSITION_COST_LOT | IMPAIRMENT_LTD_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/impairmentLtdLocal |
| mbaNetB |
Optional |
| decimal | 11251 | in_mba_net_b | N | HOLDINGDBO | POSITION_COST_LOT | MBA_NET_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/mbaNetB |
| mbaNetL |
Optional |
| decimal | 11125 | in_mba_net_l | N | HOLDINGDBO | POSITION_COST_LOT | MBA_NET_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/mbaNetL |
| naiaNetB |
Optional |
| decimal | 11343 | in_naia_net_b | N | HOLDINGDBO | POSITION_COST_LOT | NAIA_NET_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/naiaNetB |
| naiaNetL |
Optional |
| decimal | 11342 | in_naia_net_l | N | HOLDINGDBO | POSITION_COST_LOT | NAIA_NET_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/naiaNetL |
| nonCreditLossB |
Optional |
| decimal | 2705 | in_non_credit_loss_b | N | HOLDINGDBO | POSITION_COST_LOT | NON_CREDIT_LOSS_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossB |
| nonCreditLossL |
Optional |
| decimal | 2704 | in_non_credit_loss_l | N | HOLDINGDBO | POSITION_COST_LOT | NON_CREDIT_LOSS_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossL |
| adjustedShares |
Optional |
| decimal | 4972 | in_adjusted_shares | N | HOLDINGDBO | LOT_LEVEL_POSITION | ADJUSTED_SHARES | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/adjustedShares |
| baseGaapMarketValue |
Optional |
| decimal | 9281 | in_base_gaap_market_value | N | HOLDINGDBO | POSITION_COST_LOT | BASE_GAAP_MARKET_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/baseGaapMarketValue |
| baseStatMarketValue |
Optional |
| decimal | 9290 | in_base_stat_market_value | N | HOLDINGDBO | POSITION_COST_LOT | BASE_STAT_MARKET_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/baseStatMarketValue |
| cashEquivalents |
Optional |
| decimal | 64 | in_cash_equivalents | N | HOLDINGDBO | LOT_LEVEL_POSITION | CASH_EQUIVALENTS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/cashEquivalents |
| cirBrkFees |
Optional |
| decimal | 255 | in_cir_brk_fees | N | HOLDINGDBO | LOT_LEVEL_POSITION | CIR_BRK_FEES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/cirBrkFees |
| closeOidIncome |
Optional |
| decimal | 5686 | in_cls_oid_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | CLS_OID_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeOidIncome |
| closeOidIncomeLocal |
Optional |
| decimal | 5685 | in_cls_oid_income_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | CLS_OID_INCOME_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeOidIncomeLocal |
| closeTipsIncomeLocal |
Optional |
| decimal | 4538 | in_cls_tips_income_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | CLS_TIPS_INCOME_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLocal |
| closeTipsIncome |
Optional | decimal
| decimal | 4539 | in_cls_tips_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | CLS_TIPS_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncome |
| deferredIncomeTotalPtdB |
Optional | | decimal | 7980 | in_deferred_income_total_ptd_b | N | HOLDINGDBO | POSITION_COST_LOT | DEFERRED_INCOME_TOTAL_PTD_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/deferredIncomeTotalPtdB |
| deferredIncomeTotalPtdL |
Optional |
| decimal | 7979 | in_deferred_income_total_ptd_l | N | HOLDINGDBO | POSITION_COST_LOT | DEFERRED_INCOME_TOTAL_PTD_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/deferredIncomeTotalPtdL |
| deltaAdjQty |
Optional |
| decimal | 4987 | in_delta_adj_qty | N | HOLDINGDBO | LOT_LEVEL_POSITION | DELTA_ADJ_QTY | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/deltaAdjQty |
| dlta |
Optional |
| decimal | 1090 | in_dlta | N | HOLDINGDBO | LOT_LEVEL_POSITION | DLTA | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/dlta |
| expoPrice |
Optional |
| decimal | 9164 | in_expo_price | N | HOLDINGDBO | LOT_LEVEL_POSITION | EXPO_PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/expoPrice |
| earnThruDate |
Optional |
| date | 4763 | in_earn_thru_date | N | HOLDINGDBO | LOT_LEVEL_POSITION | EARN_THRU_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/earnThruDate |
| execBrkFees |
Optional |
| decimal | 266 | in_exec_brk_fees | N | HOLDINGDBO | LOT_LEVEL_POSITION | EXEC_BRK_FEES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/execBrkFees |
| fedTaxCostValue |
Optional |
| decimal | 3878 | in_fed_tax_cost_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | FED_TAX_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/fedTaxCostValue |
| gaapUnitBookValue |
Optional |
| decimal | 3130 | in_gaap_unit_book_value | N | HOLDINGDBO | POSITION_COST_LOT | GAAP_UNIT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/gaapUnitBookValue |
| gaapUnitCost |
Optional |
| decimal | 125 | in_gaap_unit_cost | N | HOLDINGDBO | POSITION_COST_LOT | GAAP_UNIT_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/gaapUnitCost |
| gaapBookValue |
Optional |
| decimal | 9279 | in_gaap_book_value | N | HOLDINGDBO | POSITION_COST_LOT | GAAP_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/gaapBookValue |
| gaapCostValue |
Optional |
| decimal | 129 | in_gaap_cost_value | N | HOLDINGDBO | POSITION_COST_LOT | GAAP_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/gaapCostValue |
| hedgedCusip |
Optional |
| string | 606 | in_hedged_cusip | S | HOLDINGDBO | LOT_LEVEL_POSITION | HEDGED_CUSIP | VARCHAR2(12) | EagleML/warehouseTransaction/warehouseOpenLot/hedgedCusip |
| hedgeTrading |
Optional |
| string | 656 | in_hedge_trading | S | HOLDINGDBO | LOT_LEVEL_POSITION | HEDGE_TRADING | VARCHAR2(10) | EagleML/warehouseTransaction/warehouseOpenLot/hedgeTrading |
| interestEarned |
Optional |
| decimal | 465 | in_interest_earned | N | HOLDINGDBO | LOT_LEVEL_POSITION | INTEREST_EARNED | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/interestEarned |
| lastSettlementDate |
Optional |
| date | 1223 | in_last_settlement_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | LAST_SETTLEMENT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/lastSettlementDate |
| localGaapCostValue |
Optional |
| decimal | 128 | in_local_gaap_cost_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_GAAP_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localGaapCostValue |
| localGaapUnitCost |
Optional |
| decimal | 124 | in_local_gaap_unit_cost | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_GAAP_UNIT_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localGaapUnitCost |
| localGaapBookValue |
Optional |
| decimal | 9280 | in_local_gaap_book_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_GAAP_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localGaapBookValue |
| localGaapUnitBookValue |
Optional |
| decimal | 9309 | in_local_gaap_unit_book_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_GAAP_UNIT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localGaapUnitBookValue |
| localGaapMarketValue |
Optional |
| decimal | 9314 | in_local_gaap_market_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_GAAP_MARKET_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localGaapMarketValue |
| localTaxUnitBookValue |
Optional |
| decimal | 46 | in_local_tax_unit_book_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_TAX_UNIT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localTaxUnitBookValue |
| localStatUnitCost |
Optional |
| decimal | 161 | in_local_stat_unit_cost | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_STAT_UNIT_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localStatUnitCost |
| localStatBookValue |
Optional |
| decimal | 9292 | in_local_stat_book_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_STAT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localStatBookValue |
| localStatCostValue |
Optional |
| decimal | 9641 | in_local_stat_cost_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_STAT_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localStatCostValue |
| localStatMarketValue |
Optional |
| decimal | 9318 | in_local_stat_market_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_STAT_MARKET_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localStatMarketValue |
| localStatUnitBookValue |
Optional |
| decimal | 9293 | in_local_stat_unit_book_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_STAT_UNIT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localStatUnitBookValue |
| localTaxBookValue |
Optional |
| decimal | 2744 | in_local_tax_book_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_TAX_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localTaxBookValue |
| localTaxCostValue |
Optional |
| decimal | 3879 | in_local_tax_cost_value | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_TAX_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localTaxCostValue |
| localTaxUnitCost |
Optional |
| decimal | 3874 | in_local_tax_unit_cost | N | HOLDINGDBO | POSITION_COST_LOT | LOCAL_TAX_UNIT_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/localTaxUnitCost |
| nonCreditLossAmortLtdB |
Optional |
| decimal | 2835 | in_non_credit_loss_amort_ltd_b | N | HOLDINGDBO | POSITION_COST_LOT | NON_CREDIT_LOSS_AMORT_LTD_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossAmortLtdB |
| nonCreditLossAmortLtdL |
Optional |
| decimal | 2834 | in_non_credit_loss_amort_ltd_l | N | HOLDINGDBO | POSITION_COST_LOT | NON_CREDIT_LOSS_AMORT_LTD_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/nonCreditLossAmortLtdL |
| oidPtdBase |
Optional |
| decimal | 593 | in_oid_ptd_base | N | HOLDINGDBO | POSITION_COST_LOT | OID_PTD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/oidPtdBase |
| oidPtdLocal |
Optional |
| decimal | 578 | in_oid_ptd_local | N | HOLDINGDBO | POSITION_COST_LOT | OID_PTD_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/oidPtdLocal |
| oidLtdIncomeLocal |
Optional |
| decimal | 575 | in_oid_ltd_income_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | OID_LTD_INCOME_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/oidLtdIncomeLocal |
| oidLtdIncomeBase |
Optional |
| decimal | 590 | in_oid_ltd_income | N | HOLDINGDBO | LOT_LEVEL_POSITION | OID_LTD_INCOME | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/oidLtdIncomeBase |
| openMktPrice |
Optional |
| decimal | 160 | in_open_mkt_price | N | HOLDINGDBO | LOT_LEVEL_POSITION | OPEN_MKT_PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/openMktPrice |
| origAccrPtdBase |
Optional |
| decimal | 9630 | in_orig_accr_ptd_base | N | HOLDINGDBO | POSITION_COST_LOT | ORIG_ACCR_PTD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/origAccrPtdBase |
| origSoldInterestBase |
Optional |
| decimal | 9631 | in_orig_sold_interest_base | N | HOLDINGDBO | POSITION_COST_LOT | ORIG_SOLD_INTEREST_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/origSoldInterestBase |
| origTradedInterestBase |
Optional |
| decimal | 9632 | in_orig_traded_interest_base | N | HOLDINGDBO | POSITION_COST_LOT | ORIG_TRADED_INTEREST_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/origTradedInterestBase |
| originalCostAmount |
Optional |
| decimal | 162 | in_original_cost_amount | N | HOLDINGDBO | LOT_LEVEL_POSITION | ORIGINAL_COST_AMOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalCostAmount |
| payEpAccrued |
Optional |
| decimal | 2881 | in_pay_ep_accrued | N | HOLDINGDBO | LOT_LEVEL_POSITION | PAY_EP_ACCRUED | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/payEpAccrued |
| payRecInd |
Optional |
| string | 4590 | in_pay_rec_ind | S | HOLDINGDBO | POSITION_COST_LOT | PAY_REC_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseOpenLot/payRecInd |
| posnFullyEarned |
Optional |
| string | 8383 | in_posn_fully_earned | S | HOLDINGDBO | POSITION_COST_LOT | POSN_FULLY_EARNED | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseOpenLot/posnFullyEarned |
| purchasePrincipalBase |
Optional |
| decimal | 256 | in_purchase_principal_base | N | HOLDINGDBO | LOT_LEVEL_POSITION | PURCHASE_PRINCIPAL_BASE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/purchasePrincipalBase |
| purchasePrincipalLocal |
Optional |
| decimal | 254 | in_purchase_principal_local | N | HOLDINGDBO | LOT_LEVEL_POSITION | PURCHASE_PRINCIPAL_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/purchasePrincipalLocal |
| pv01total |
Optional |
| decimal | 5839 | in_pv01total | N | HOLDINGDBO | LOT_LEVEL_POSITION | PV01TOTAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/pv01total |
| preTaxAdjYld |
Optional |
| decimal | 5767 | in_pre_tax_adj_yld | N | HOLDINGDBO | LOT_LEVEL_POSITION | PRE_TAX_ADJ_YLD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/preTaxAdjYld |
| recEpAccrued |
Optional |
| decimal | 2880 | in_rec_ep_accrued | N | HOLDINGDBO | LOT_LEVEL_POSITION | REC_EP_ACCRUED | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/recEpAccrued |
| statCostValue |
Optional |
| decimal | 166 | in_stat_cost_value | N | HOLDINGDBO | POSITION_COST_LOT | STAT_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/statCostValue |
| soldInterestBase |
Optional |
| decimal | 8953 | in_interest_sold_base | N | HOLDINGDBO | LOT_LEVEL_POSITION | INTEREST_SOLD_BASE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/soldInterestBase |
| scrubFlag |
Optional |
| YesNoOptionEnum | 4569 | in_scrub_flag | S | HOLDINGDBO | LOT_LEVEL_POSITION | SCRUB_FLAG | CHAR(2) | EagleML/warehouseTransaction/warehouseOpenLot/scrubFlag |
| sourceInternalAssetId |
Optional |
| string | 13047 | in_source_internal_asset_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | SOURCE_INTERNAL_ASSET_ID | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseOpenLot/sourceInternalAssetId |
| statBookValue |
Optional |
| decimal | 9289 | in_stat_book_value | N | HOLDINGDBO | POSITION_COST_LOT | STAT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/statBookValue |
| statUnitBookValue |
Optional |
| decimal | 9308 | in_stat_unit_book_value | N | HOLDINGDBO | POSITION_COST_LOT | STAT_UNIT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/statUnitBookValue |
| soldInterestLocal |
Optional |
| decimal | 8952 | in_interest_sold | N | HOLDINGDBO | LOT_LEVEL_POSITION | INTEREST_SOLD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/soldInterestLocal |
| statUnitCost |
Optional |
| decimal | 9291 | in_stat_unit_cost | N | HOLDINGDBO | POSITION_COST_LOT | STAT_UNIT_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/statUnitCost |
| stateCostValue |
Optional | string
| decimal | 11985 | in_state_cost_value | N | HOLDINGDBO | LOT_LEVEL_POSITION | STATE_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/stateCostValue |
| swapAccrMethod |
Optional | | string | 1184 | in_swap_accr_method | S | HOLDINGDBO | POSITION_COST_LOT | SWAP_ACCR_METHOD | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseOpenLot/swapAccrMethod |
| totalUnrealizedGainLossLocal |
Optional |
| decimal | 489 | in_local_unrealized_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | LOCAL_UNREALIZED_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/totalUnrealizedGainLossLocal |
| totalUnrealizedGainLossBase |
Optional |
| decimal | 492 | in_base_unrealized_gl | N | HOLDINGDBO | LOT_LEVEL_POSITION | BASE_UNREALIZED_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/totalUnrealizedGainLossBase |
| tipsPtdBase |
Optional |
| decimal | 4447 | in_tips_ptd_base | N | HOLDINGDBO | POSITION_COST_LOT | TIPS_PTD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/tipsPtdBase |
| tipsPtdLocal |
Optional |
| decimal | 4442 | in_tips_ptd_local | N | HOLDINGDBO | POSITION_COST_LOT | TIPS_PTD_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/tipsPtdLocal |
| taxBookValue |
Optional |
| decimal | 3881 | in_tax_book_value | N | HOLDINGDBO | POSITION_COST_LOT | TAX_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/taxBookValue |
| taxCostValue |
Optional |
| decimal | 2726 | in_tax_cost_value | N | HOLDINGDBO | POSITION_COST_LOT | TAX_COST_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/taxCostValue |
| taxUnitBookValue |
Optional |
| decimal | 2727 | in_tax_unit_book_value | N | HOLDINGDBO | POSITION_COST_LOT | TAX_UNIT_BOOK_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/taxUnitBookValue |
| taxUnitCost |
Optional |
| decimal | 9311 | in_tax_unit_cost | N | HOLDINGDBO | POSITION_COST_LOT | TAX_UNIT_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/taxUnitCost |
| tradeFxRate |
Optional |
| decimal | 79,751 | in_trade_fx_rate | N | HOLDINGDBO | LOT_LEVEL_POSITION | TRADE_FX_RATE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/tradeFxRate |
| undPrice |
Optional |
| decimal | 9163 | in_und_price | N | HOLDINGDBO | LOT_LEVEL_POSITION | UND_PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/undPrice |
| uniqueAssetFlag |
Optional |
| YesNoOptionEnum | 13042 | in_unique_asset_flag | S | HOLDINGDBO | LOT_LEVEL_POSITION | UNIQUE_ASSET_FLAG | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/uniqueAssetFlag |
| bankAlias |
Optional |
| integer | 1864,16 | in_bank_alias | N | HOLDINGDBO | POSITION_COST_LOT | BANK_ALIAS | NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/bankAlias |
| batchEventId |
Optional |
| string | 701 | in_batch_event_id | S | HOLDINGDBO | LOT_LEVEL_POSITION | BATCH_EVENT_ID | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseOpenLot/batchEventId |
| brokerCode |
Optional |
| string | 88 | in_broker_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | BROKER_CODE | VARCHAR2(12) | EagleML/warehouseTransaction/warehouseOpenLot/brokerCode |
| clearingBrokerCode |
Optional |
| string | 1237 | in_clearing_broker_code | S | HOLDINGDBO | LOT_LEVEL_POSITION | CLEARING_BROKER_CODE | CHAR(12) | EagleML/warehouseTransaction/warehouseOpenLot/clearingBrokerCode |
| commissionAmount |
Optional |
| decimal | 47 | in_commission | N | HOLDINGDBO | LOT_LEVEL_POSITION | COMMISSION | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/commissionAmount |
| lotNumber |
Optional |
| string | 1790 | in_lot_number | S | HOLDINGDBO | LOT_LEVEL_POSITION | LOT_NUMBER | CHAR(10) | EagleML/warehouseTransaction/warehouseOpenLot/lotNumber |
| masterTicketNumber |
Optional |
| string | 761 | in_master_ticket_number | S | HOLDINGDBO | LOT_LEVEL_POSITION | MASTER_TICKET_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseOpenLot/masterTicketNumber |
| monthEndAccountingDate |
Optional |
| date | 4733 | in_monthly_accounting_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | MONTHLY_ACCOUNTING_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/monthEndAccountingDate |
| secFee |
Optional |
| decimal | 3752 | in_sec_fees | N | HOLDINGDBO | POSITION_COST_LOT | SEC_FEES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/secFee |
| settlementDate |
Optional |
| date | 37 | in_settlement_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLEMENT_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/settlementDate |
| tradeDate |
Optional |
| date | 35 | in_trade_date | S | HOLDINGDBO | LOT_LEVEL_POSITION | TRADE_DATE | DATE | EagleML/warehouseTransaction/warehouseOpenLot/tradeDate |
| transactionCode |
Optional |
| string | 3821 | in_trans_code | S | HOLDINGDBO | POSITION_COST_LOT | TRANS_CODE | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseOpenLot/transactionCode |
| userChar1 |
Optional |
| string | 1887 | in_user_char1 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_CHAR1 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseOpenLot/userChar1 |
| userChar2 |
Optional |
| string | 1888 | in_user_char2 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_CHAR2 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseOpenLot/userChar2 |
| userChar3 |
Optional |
| string | 1889 | in_user_char3 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_CHAR3 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseOpenLot/userChar3 |
| userDefinedFloat1 |
Optional |
| decimal | 1890 | in_user_float1 | N | HOLDINGDBO | LOT_LEVEL_POSITION | USER_FLOAT1 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat1 |
| userDefinedFloat2 |
Optional |
| decimal | 1891 | in_user_float2 | N | HOLDINGDBO | LOT_LEVEL_POSITION | USER_FLOAT2 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat2 |
| userDefinedFloat3 |
Optional |
| decimal | 1892 | in_user_float3 | N | HOLDINGDBO | LOT_LEVEL_POSITION | USER_FLOAT3 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseOpenLot/userDefinedFloat3 |
| pclUserDate1 |
Optional |
| date | 32 | in_pcl_user_date1 | S | HOLDINGDBO | POSITION_COST_LOT | PCL_USER_DATE1 | DATE | EagleML/warehouseTransaction/warehouseOpenLot/pclUserDate1 |
| pclUserDate2 |
Optional |
| date | 30 | in_pcl_user_date2 | S | HOLDINGDBO | POSITION_COST_LOT | PCL_USER_DATE2 | DATE | EagleML/warehouseTransaction/warehouseOpenLot/pclUserDate2 |
| pclUserDate3 |
Optional |
| date | 164 | in_pcl_user_date3 | S | HOLDINGDBO | POSITION_COST_LOT | PCL_USER_DATE3 | DATE | EagleML/warehouseTransaction/warehouseOpenLot/pclUserDate3 |
| userGroup1 |
Optional |
| string | 63 | in_user_group1 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP1 | CHAR(10) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup1 |
| userGroup2 |
Optional |
| string | 17,1891 | in_user_group2 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP2 | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup2 |
| userGroup3 |
Optional |
| string | 1461 | in_user_group3 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP3 | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup3 |
| userGroup4 |
Optional |
| string | 1472 | in_user_group4 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP4 | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup4 |
| userGroup5 |
Optional |
| string | 1473 | in_user_group5 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP5 | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup5 |
| userGroup6 |
Optional |
| string | 768 | in_user_group6 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP6 | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup6 |
| userGroup7 |
Optional |
| string | 1462 | in_user_group7 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP7 | CHAR(8) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup7 |
| userGroup8 |
Optional |
| string | 9989 | in_user_group8 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP8 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup8 |
| userGroup9 |
Optional |
| string | 9990 | in_user_group9 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP9 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup9 |
| userGroup10 |
Optional |
| string | 9991 | in_user_group10 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP10 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup10 |
| userGroup11 |
Optional |
| string | 9992 | in_user_group11 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP11 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup11 |
| userGroup12 |
Optional |
| string | 9993 | in_user_group12 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP12 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup12 |
| userGroup13 |
Optional |
| string | 9994 | in_user_group13 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP13 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup13 |
| userGroup14 |
Optional |
| string | 9995 | in_user_group14 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP14 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup14 |
| userGroup15 |
Optional |
| string | 9996 | in_user_group15 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP15 | VARCHAR2(35) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup15 |
| userGroup16 |
Optional |
| string | 9997 | in_user_group16 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP16 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup16 |
| userGroup17 |
Optional |
| string | 9998 | in_user_group17 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP17 | VARCHAR2(15) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup17 |
| userGroup18 |
Optional |
| string | 9999 | in_user_group18 | S | HOLDINGDBO | LOT_LEVEL_POSITION | USER_GROUP18 | VARCHAR2(35) | EagleML/warehouseTransaction/warehouseOpenLot/userGroup18 |
settledGaapCostValue
(supported in |
2017R1Optionaldecimal| 5589 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_GAAP_COST_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledGaapCostValue |
settledLocalGaapCostValue
(supported in |
2017R1Optionaldecimal| 5590 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_LOCAL_GAAP_COST_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledLocalGaapCostValue |
settledLocalMarketValue
(supported in |
2017R1Optionaldecimal| 5591 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_LOCAL_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledLocalMarketValue |
settledMarketValue
(supported in |
2017R1Optionaldecimal| 5592 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledMarketValue |
settlementDatePosition
(supported in |
2017R1Optionaldecimal| 5593 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLEMENT_DATE_POSITION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePosition |
settlementDatePositionLocal
(supported in |
2017R1Optionaldecimal| 5594 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLEMENT_DATE_POSITION_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionLocal |
settlementDatePositionCost
(supported in |
2017R1Optionaldecimal| 5595 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLEMENT_DATE_POSITION_COST | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionCost |
| lotLevelPositionId |
Optional |
| integer |
|
|
| HOLDINGDBO | LOT_LEVEL_POSITION | LOT_LEVEL_POSITION | NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/lotLevelPositionId |
| lotLevelCostPositionId |
Optional |
| integer |
|
|
| HOLDINGDBO | POSITION_COST_LOT | POSITION_LOT_ID | NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/lotLevelCostPositionId |
starQuantity
(supported in |
2017R1Optionaldecimal| 5596 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | STAR_QUANTITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/starQuantity |
starMarketValueLocal
(supported in |
2017R1Optionaldecimal| 5597 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | STAR_MARKET_VALUE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/starMarketValueLocal |
starMarketValue
(supported in |
2017R1Optionaldecimal| 5598 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | STAR_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/starMarketValue |
| processingIlbLtdLocal |
Optionaldecimal| 5599 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | PROCESSING_ILB_LTD_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdLocal |
| processingIlbLtdBase |
Optionaldecimal| 5600 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | PROCESSING_ILB_LTD_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdBase |
| incomeBalanceLocal |
Optionaldecimal| 5601 |
|
| HOLDINGDBO | POSITION_COST_LOT | INCOME_BALANCE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/incomeBalanceLocal |
| incomeBalance |
Optionaldecimal| 5602 |
|
| HOLDINGDBO | POSITION_COST_LOT | INCOME_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/incomeBalance |
| principalBalanceLocal |
Optionaldecimal| 5603 |
|
| HOLDINGDBO | POSITION_COST_LOT | PRINCIPAL_BALANCE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/principalBalanceLocal |
| principalBalance |
Optionaldecimal| 5604 |
|
| HOLDINGDBO | POSITION_COST_LOT | PRINCIPAL_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/principalBalance |
| orderNumber |
Optionalstring| 5611 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | ORDER_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseOpenLot/orderNumber |
| priceMethod |
OptionalnormalizedString| 5613 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | PRICE_METHOD | VARCHAR2(4) | EagleML/warehouseTransaction/warehouseOpenLot/priceMethod |
| regulatoryIntent |
OptionalnormalizedString| 5614 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | REGULATORY_INTENT | VARCHAR2(3) | EagleML/warehouseTransaction/warehouseOpenLot/regulatoryIntent |
| holdingTerm |
OptionalnormalizedString| 5629 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | HOLDING_TERM | VARCHAR2(2) | EagleML/warehouseTransaction/warehouseOpenLot/holdingTerm |
| positionId |
Optional |
| integer |
|
|
| HOLDINGDBO | LOT_LEVEL_POSITION | POSITION_ID | NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/positionId |
| positionDetailId | Extract only | integer |
|
|
| HOLDINGDBO | POSITION_DETAIL | POSITION_DETAIL_ID | NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/positionDetailId |
| shareParValue |
EagleML/warehouseTransaction/warehouseOpenLot/shareParValue | realEstateUDF | Real Estate UDF Model (see extra data map table) | Extract only | decimal |
|
|
| HOLDINGDBO | POSITION_DETAIL | SHARE_PAR_VALUE |
| EagleML/warehouseTransaction/warehouseOpenLot/ |
realEstateUDF/extendedRatingsModel | Extended Ratings Model (see extra data map table)| shareParValue |
| accrualRate | Extract only | decimal |
|
|
| ESTAR | ESTAR_INCOME_ACTIVITY | COUPON |
| EagleML/warehouseTransaction/warehouseOpenLot/ |
extendedRatingsModel/extendedPortValuationModel | Extended Port Valuation Model (see extra data map table) | | accrualRate |
| calcMasterTransactionId | Extract only
(see more details) | string |
|
|
| CALC_MASTER_TRANSACTION_ID - concatenated value
ACCT_BASIS#ENTITY_ID#SECURITY_ALIAS#LONG_SHORT_IND#ORIG_LOT_NUMBER | EagleML/warehouseTransaction/warehouseOpenLot/ |
extendedPortValuationModel/washSaleOpenLot | Wash Sale Open Lot Model (see extra data map table| calcMasterTransactionId |
| bookCostLocal |
| decimal | 17039 | in_book_cost_l |
| HOLDINGDBO | POSITION_COST_LOT | BOOK_COST_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/ |
washSaleOpenLot/...
...
...
| 17038 | in_book_cost_b |
| HOLDINGDBO | POSITION_COST_LOT | BOOK_COST_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/bookCostBase |
| bookPriceLocal | Extract only | decimal | 17478 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | BOOK_PRICE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/bookPriceLocal |
| bookPriceBase | Extract only | decimal | 17477 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | BOOK_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/bookPriceBase |
sleeveId
(supported in ORA, EagleML v17 or higher)
|
| decimal | 1606 | in_sleeve_id |
| HOLDINGDBO | LOT_LEVEL_POSITION | SLEEVE_ID | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/sleeveId |
| originalAcquisitionNotionalCostBase | Extract only | decimal |
| in_orig_acq_cost_notional_base |
| HOLDINGDBO | POSITION_COST_LOT | ORIG_ACQ_NOTIONAL_COST_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionNotionalCostBase |
| originalAcquisitionNotionalCostLocal | Extract only | decimal |
| in_orig_acq_cost_notional_local |
| HOLDINGDBO | POSITION_COST_LOT | ORIG_ACQ_NOTIONAL_COST_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionNotionalCostLocal |
| settledOriginalFace | Extract only | decimal | 11310 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SETTLE_ORIG_FACE |
| EagleML/warehouseTransaction/warehouseOpenLot/settledOriginalFace |
| priceDate |
| date | 482 |
|
| HOLDINGDBO | POSITION_DETAIL | PRICE_DATE |
| EagleML/warehouseTransaction/warehouseOpenLot/priceDate |
| custodianPrincipalBalanceBase | Extract only | decimal | 18578 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | CUST_PRINCIPAL_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/custodianPrincipalBalanceBase |
| custodianPrincipalBalanceLocal | Extract only | decimal | 18579 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | CUST_PRINCIPAL_BALANCE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/custodianPrincipalBalanceLocal |
| custodianPrincipalBalanceLocal | Extract only | decimal | 18580 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | CUST_INCOME_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/custodianIncomeBalanceBase |
custodianIncomeBalanceLocal | Extract only | decimal | 18581 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | CUST_INCOME_BALANCE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/custodianIncomeBalanceLocal |
| srcSysC | Extract only | string | 98 |
|
| HOLDINGDBO | LOT_LEVEL_POSITION | SRC_SYS_C | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseOpenLot/srcSysC |
| custodianBankCode | Extract only | string | 1240 |
|
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/warehouseTransaction/warehouseOpenLot/custodianBankCode |
| custodyBankAccount | Extract only | string | 1660 |
|
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseOpenLot/custodyBankAccount |
| custodyBankSubaccount | Extract only | string | 1661 |
|
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_SUB_ACCT | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseOpenLot/custodyBankSubaccount |
| realEstateUDF | Real Estate UDF Model (see extra data map table) | EagleML/warehouseTransaction/warehouseOpenLot/realEstateUDF/ |
| extendedRatingsModel | Extended Ratings Model (see extra data map table) | EagleML/warehouseTransaction/warehouseOpenLot/extendedRatingsModel/ |
| extendedPortValuationModel | Extended Port Valuation Model (see extra data map table) | EagleML/warehouseTransaction/warehouseOpenLot/extendedPortValuationModel/ |
| washSaleOpenLot | Wash Sale Open Lot Model (see extra data map table) | EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/ |
| lotIncome | Lot Income Model (see extra data map table) - please note that this table is available only if you use EDS interface/Ontology | EagleML/warehouseTransaction/warehouseOpenLot/lotIncome/ |
| costUDF | Cost UDF Model (see extra data map table) - please note that this table is available only if you use EDS interface/Ontology | EagleML/warehouseTransaction/warehouseOpenLot/costUDF/ |
