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