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