...
...
...
...
...
...
| 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 | LongShortIndicatorEnum | 15 | in_long_short_ind | S | HOLDINGDBO | LOT_LEVEL_POSITION | LONG_SHORT_IND | CHAR(4) | EagleML/warehouseTransaction/warehouseOpenLot/longShortIndicator | ||||||
EagleML/warehouseTransaction/warehouseOpenLot/ | ||||||||||||||||
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 | ProcedureFlagTypeEnum | 1078 | in_procedure_mode | S | not stored in DB | EagleML/warehouseTransaction/warehouseOpenLot/procedureMode | |||||||||
| Optional | ProcedureFlagTypeEnum | 1076 | in_mode_flag | S | not stored in DB | EagleML/warehouseTransaction/warehouseOpenLot/procedureFlag | |||||||||
EagleML/warehouseTransaction/warehouseOpenLot/ | ||||||||||||||||
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 | 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 | decimal | not stored in DB | 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 | |||||||
netcashflwsNxtPmtDate2 | date | 1402 | in_netcashflws_nxt_pmt | S | HOLDINGDBO | LOT_LEVEL_POSITION | NETCASHFLWS_NXT_PMT | DATE | EagleML/warehouseTransaction/warehouseOpenLot/netcashflwsNxtPmtDate2 | |||||||
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 | decimal | 5589 | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_GAAP_COST_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledGaapCostValue | |||||||||
settledLocalGaapCostValue | decimal | 5590 | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_LOCAL_GAAP_COST_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledLocalGaapCostValue | |||||||||
settledLocalMarketValue | decimal | 5591 | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_LOCAL_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledLocalMarketValue | |||||||||
settledMarketValue | decimal | 5592 | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLED_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settledMarketValue | |||||||||
settlementDatePosition | decimal | 5593 | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLEMENT_DATE_POSITION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePosition | |||||||||
settlementDatePositionLocal | decimal | 5594 | HOLDINGDBO | LOT_LEVEL_POSITION | SETTLEMENT_DATE_POSITION_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionLocal | |||||||||
settlementDatePositionCost | decimal | 5595 | 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 | decimal | 5596 | HOLDINGDBO | LOT_LEVEL_POSITION | STAR_QUANTITY | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/starQuantity | |||||||||
starMarketValueLocal | decimal | 5597 | HOLDINGDBO | LOT_LEVEL_POSITION | STAR_MARKET_VALUE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/starMarketValueLocal | |||||||||
starMarketValue | decimal | 5598 | HOLDINGDBO | LOT_LEVEL_POSITION | STAR_MARKET_VALUE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/starMarketValue | |||||||||
processingIlbLtdLocal | decimal | 5599 | HOLDINGDBO | LOT_LEVEL_POSITION | PROCESSING_ILB_LTD_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdLocal | |||||||||
processingIlbLtdBase | decimal | 5600 | HOLDINGDBO | LOT_LEVEL_POSITION | PROCESSING_ILB_LTD_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/processingIlbLtdBase | |||||||||
incomeBalanceLocal | decimal | 5601 | HOLDINGDBO | POSITION_COST_LOT | INCOME_BALANCE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/incomeBalanceLocal | |||||||||
incomeBalance | decimal | 5602 | HOLDINGDBO | POSITION_COST_LOT | INCOME_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/incomeBalance | |||||||||
principalBalanceLocal | decimal | 5603 | HOLDINGDBO | POSITION_COST_LOT | PRINCIPAL_BALANCE_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/principalBalanceLocal | |||||||||
principalBalance | decimal | 5604 | HOLDINGDBO | POSITION_COST_LOT | PRINCIPAL_BALANCE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/principalBalance | |||||||||
orderNumber | string | 5611 | HOLDINGDBO | LOT_LEVEL_POSITION | ORDER_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseOpenLot/orderNumber | |||||||||
priceMethod | normalizedString | 5613 | HOLDINGDBO | LOT_LEVEL_POSITION | PRICE_METHOD | VARCHAR2(4) | EagleML/warehouseTransaction/warehouseOpenLot/priceMethod | |||||||||
regulatoryIntent | normalizedString | 5614 | HOLDINGDBO | LOT_LEVEL_POSITION | REGULATORY_INTENT | VARCHAR2(3) | EagleML/warehouseTransaction/warehouseOpenLot/regulatoryIntent | |||||||||
holdingTerm | normalizedString | 5629 | 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 | ||||||||||
calcMasterTransactionId | Extract only | string | CALC_MASTER_TRANSACTION_ID - concatenated value | EagleML/warehouseTransaction/warehouseOpenLot/calcMasterTransactionId | ||||||||||||
bookCostLocal | decimal | 17039 | in_book_cost_l | HOLDINGDBO | POSITION_COST_LOT | BOOK_COST_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseOpenLot/bookCostLocal | ||||||||
bookCostBase | decimal | 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 | 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 | EagleML/warehouseTransaction/warehouseOpenLot/realEstateUDF/ | |||||||||||||||
extendedRatingsModel | EagleML/warehouseTransaction/warehouseOpenLot/extendedRatingsModel/ | |||||||||||||||
extendedPortValuationModel | EagleML/warehouseTransaction/warehouseOpenLot/extendedPortValuationModel/ | |||||||||||||||
washSaleOpenLot | 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/ | ||||||||||||||