Warehouse Open Lot Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Alexey Chunikhin
Some elements are available only for certain versions of the environment - these are denoted like this: (supported in v17).
To include the Wash Sale Open Lot you need IncludeWashSales task parameter set to Y in your RTR for extract.
sourceLongShortInd and longShortIndicator are mapped into the same tag15 in_long_short_ind. If both nodes are not null in the incoming message, the value of longShortIndicator has a higher priority.
procedureMode and procedureFlag specify type of action (INSERT, UPDATE, DELETE).
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|---|---|---|---|---|---|---|---|---|---|---|
objectType |
| 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/ | ||||||||