Versions Compared

Old Version 22

changes.mady.by.user Alexey Chunikhin

Saved on

compared with

New Version Current

changes.mady.by.user Kinga Huszno

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

Note
Info
title

  • 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.

  • Anchor
    sourceLongShortInd_and_longShortInd
    sourceLongShortInd_and_longShortInd
    sourceLongShortInd and longShortIndicator are mapped into the same tag15 in_long_short_ind. If both nodes are not null in the incoming message, the value of longShortIndicator has a higher priority.

  • Anchor
    procedureMode_and_procedureFlag_note
    procedureMode_and_procedureFlag_note
    procedureMode and procedureFlag specify type of action (INSERT, UPDATE, DELETE).

Element

Optional/Required

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

XPath

objectType

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

Anchor
longShortIndicator
longShortIndicator
longShortIndicator

Optional
(see Note)

LongShortIndicatorEnum

15

in_long_short_ind

S

HOLDINGDBO

LOT_LEVEL_POSITION

LONG_SHORT_IND

CHAR(4)

EagleML/warehouseTransaction/warehouseOpenLot/longShortIndicator

Entity Common Id Model

EagleML/warehouseTransaction/warehouseOpenLot/

Entity Properties Model (extract only)

EagleML/warehouseTransaction/warehouseOpenLot/

accountingBasis

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

Anchor
procedureMode
procedureMode
procedureMode

Optional
(see Note)

ProcedureFlagTypeEnum

1078

in_procedure_mode

S

not stored in DB

EagleML/warehouseTransaction/warehouseOpenLot/procedureMode

Anchor
procedureFlag
procedureFlag
procedureFlag

Optional
(see Note)

ProcedureFlagTypeEnum

1076

in_mode_flag

S

not stored in DB

EagleML/warehouseTransaction/warehouseOpenLot/procedureFlag

Asset Identifiers Model

EagleML/warehouseTransaction/warehouseOpenLot/

Extended Asset Properties Model (extract only)

EagleML/warehouseTransaction/warehouseOpenLot/

baseCurrency

CurrencyCode

86

in_base_currency

S

HOLDINGDBO

LOT_LEVEL_POSITION

CURRENCY

CHAR(3)

EagleML/warehouseTransaction/warehouseOpenLot/baseCurrency

srcIntfcInst

decimal

1168

not stored in DB

EagleML/warehouseTransaction/warehouseOpenLot/srcIntfcInst

transactionType

string

2283

in_trans_type

S

HOLDINGDBO

LOT_LEVEL_POSITION

TRANS_TYPE

VARCHAR2(55)

EagleML/warehouseTransaction/warehouseOpenLot/transactionType

rollupFlag

YesNoOptionEnum

not stored in DB

EagleML/warehouseTransaction/warehouseOpenLot/rollupFlag

urglSecurityBase

decimal

491

in_unrealized_sec_gl

N

HOLDINGDBO

LOT_LEVEL_POSITION

UNREALIZED_SEC_GL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/urglSecurityBase

urglCurrencyBase

decimal

493

in_unrealized_curr_gl

N

HOLDINGDBO

LOT_LEVEL_POSITION

UNREALIZED_CURR_GL

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseOpenLot/urglCurrencyBase

updateDate

date

1106

in_update_date

S

HOLDINGDBO

LOT_LEVEL_POSITION

UPDATE_DATE

DATE

EagleML/warehouseTransaction/warehouseOpenLot/updateDate

closeOpenEventId

TransactionId

181

not stored in DB

EagleML/warehouseTransaction/warehouseOpenLot/closeOpenEventId

closeEventId

TransactionId

182

not stored in DB

EagleML/warehouseTransaction/warehouseOpenLot/closeEventId

closeIndexWeight

decimal

4483

in_indx_weight

N

HOLDINGDBO

LOT_LEVEL_POSITION

INDX_WEIGHT

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseOpenLot/closeIndexWeight

closeTipsIncomeLtdLocal

decimal

4440

in_tip_ltd_income_local

N

HOLDINGDBO

LOT_LEVEL_POSITION

TIP_LTD_INCOME_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdLocal

closeTipsIncomeLtdBase

decimal

4445

in_tip_ltd_income

N

HOLDINGDBO

LOT_LEVEL_POSITION

TIP_LTD_INCOME

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/closeTipsIncomeLtdBase

marketValueLocal

decimal

487

in_local_market_value

N

HOLDINGDBO

LOT_LEVEL_POSITION

LOCAL_MARKET_VALUE

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseOpenLot/marketValueLocal

marketValueBase

decimal

488

in_market_value

N

HOLDINGDBO

LOT_LEVEL_POSITION

MARKET_VALUE

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseOpenLot/marketValueBase

marketValueIncomeLocal

decimal

9424

in_market_value_income_local

N

HOLDINGDBO

LOT_LEVEL_POSITION

MARKET_VALUE_INCOME_LOCAL

NUMBER(28,12)

EagleML/warehouseTransaction/warehouseOpenLot/marketValueIncomeLocal

notionalMarketValueBase

decimal

10794

in_notional_market_value

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_MARKET_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueBase

notionalUnrealizedGlBase

decimal

10796

in_notional_unrealized_gl

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_UNREALIZED_GL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlBase

notionalCostLocal

decimal

10791

in_notional_cost_local

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_COST_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalCostLocal

notionalCostBase

decimal

10792

in_notional_cost

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_COST

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalCostBase

notionalMarketValueLocal

decimal

10793

in_notional_market_value_local

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_MARKET_VALUE_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalMarketValueLocal

notionalUnrealizedGlLocal

decimal

10795

in_notional_local_unrealiz_gl

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_LOCAL_UNREALIZED_GL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedGlLocal

notionalUnrealizedCurrGl

decimal

10797

in_notional_unrealized_curr_gl

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_UNREALIZED_CURR_GL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedCurrGl

notionalUnrealizedSecGl

decimal

10798

in_notional_unrealized_sec_gl

N

HOLDINGDBO

LOT_LEVEL_POSITION

NOTIONAL_UNREALIZED_SEC_GL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/notionalUnrealizedSecGl

Anchor
sourceLongShortInd
sourceLongShortInd
sourceLongShortInd

Optional
(see Note)

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
(supported in v17)

decimal

5589

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLED_GAAP_COST_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/settledGaapCostValue

settledLocalGaapCostValue
(supported in v17)

decimal

5590

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLED_LOCAL_GAAP_COST_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/settledLocalGaapCostValue

settledLocalMarketValue
(supported in v17)

decimal

5591

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLED_LOCAL_MARKET_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/settledLocalMarketValue

settledMarketValue
(supported in v17)

decimal

5592

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLED_MARKET_VALUE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/settledMarketValue

settlementDatePosition
(supported in v17)

decimal

5593

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLEMENT_DATE_POSITION

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePosition

settlementDatePositionLocal
(supported in v17)

decimal

5594

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLEMENT_DATE_POSITION_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/settlementDatePositionLocal

settlementDatePositionCost
(supported in v17)

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
(supported in v17)

decimal

5596

HOLDINGDBO

LOT_LEVEL_POSITION

STAR_QUANTITY

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/starQuantity

starMarketValueLocal
(supported in v17)

decimal

5597

HOLDINGDBO

LOT_LEVEL_POSITION

STAR_MARKET_VALUE_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/starMarketValueLocal

starMarketValue
(supported in v17)

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
(see more details)

string

CALC_MASTER_TRANSACTION_ID - concatenated value
ACCT_BASIS#ENTITY_ID#SECURITY_ALIAS#LONG_SHORT_IND#ORIG_LOT_NUMBER

EagleML/warehouseTransaction/warehouseOpenLot/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
(supported in ORA, EagleML v17 or higher)

decimal

1606

in_sleeve_id

HOLDINGDBO

LOT_LEVEL_POSITION

SLEEVE_ID

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/sleeveId

settledOriginalFace

originalAcquisitionNotionalCostBase

Extract only

decimal

11310

in_orig_acq_cost_notional_base

HOLDINGDBO

POSITION_COST_LOT

ORIG_

LEVEL

ACQ_

POSITIONSETTLE

NOTIONAL_

ORIG_FACE

COST_B

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/

settledOriginalFacepriceDatedate482

originalAcquisitionNotionalCostBase

originalAcquisitionNotionalCostLocal

Extract only

decimal

in_orig_acq_cost_notional_local

HOLDINGDBO

POSITION_COST_

DETAILPRICE_DATE

LOT

ORIG_ACQ_NOTIONAL_COST_L

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/originalAcquisitionNotionalCostLocal

settledOriginalFace

Extract only

decimal

11310

HOLDINGDBO

LOT_LEVEL_POSITION

SETTLE_ORIG_FACE

EagleML/warehouseTransaction/warehouseOpenLot/settledOriginalFace

priceDate

date

482

HOLDINGDBO

POSITION_DETAIL

PRICE_DATE

EagleML/warehouseTransaction/warehouseOpenLot/priceDate

custodianPrincipalBalanceBase

Extract only

decimal

18578

HOLDINGDBO

LOT_LEVEL_POSITION

CUST_PRINCIPAL_BALANCE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/custodianPrincipalBalanceBase

custodianPrincipalBalanceLocal

Extract only

decimal

18579

HOLDINGDBO

LOT_LEVEL_POSITION

CUST_PRINCIPAL_BALANCE_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/custodianPrincipalBalanceLocal

custodianPrincipalBalanceLocal

Extract only

decimal

18580

HOLDINGDBO

LOT_LEVEL_POSITION

CUST_INCOME_BALANCE

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/custodianIncomeBalanceBase

custodianIncomeBalanceLocal

Extract only

decimal

18581

HOLDINGDBO

LOT_LEVEL_POSITION

CUST_INCOME_BALANCE_LOCAL

NUMBER(38,12)

EagleML/warehouseTransaction/warehouseOpenLot/custodianIncomeBalanceLocal

srcSysC

Extract only

string

98

HOLDINGDBO

LOT_LEVEL_POSITION

SRC_SYS_C

VARCHAR2(25)

EagleML/warehouseTransaction/warehouseOpenLot/srcSysC

custodianBankCode

Extract only

string

1240

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP

CUSTODY_BANK_CODE

CHAR(20)

EagleML/warehouseTransaction/warehouseOpenLot/custodianBankCode

custodyBankAccount

Extract only

string

1660

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP

CUSTODY_BANK_ACCT_NUM

VARCHAR2(30)

EagleML/warehouseTransaction/warehouseOpenLot/custodyBankAccount

custodyBankSubaccount

Extract only

string

1661

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP

CUSTODY_BANK_SUB_ACCT

VARCHAR2(30)

EagleML/warehouseTransaction/warehouseOpenLot/custodyBankSubaccount

realEstateUDF

Real Estate UDF Model (see extra data map table)

EagleML/warehouseTransaction/warehouseOpenLot/realEstateUDF/

extendedRatingsModel

Extended Ratings Model (see extra data map table)

EagleML/warehouseTransaction/warehouseOpenLot/extendedRatingsModel/

extendedPortValuationModel

Extended Port Valuation Model (see extra data map table)

EagleML/warehouseTransaction/warehouseOpenLot/extendedPortValuationModel/

washSaleOpenLot

Wash Sale Open Lot Model (see extra data map table)

EagleML/warehouseTransaction/warehouseOpenLot/washSaleOpenLot/

lotIncome

Lot Income Model (see extra data map table) - please note that this table is available only if you use EDS interface/Ontology

EagleML/warehouseTransaction/warehouseOpenLot/lotIncome/

costUDF

Cost UDF Model (see extra data map table) - please note that this table is available only if you use EDS interface/Ontology

EagleML/warehouseTransaction/warehouseOpenLot/costUDF/