| Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|---|
| objectType |
| ObjectTypeEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/objectType |
| objectId |
| ObjectId |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/objectId |
| objectDescription |
| FeedTypeEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/objectDescription |
| updateTimestamp | Required | dateTime |
|
| SECURITYDBO | PRICE_EXCHANGE | UPDATE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/updateTimestamp |
| customElements | Not recommended | CustomElements |
| reserved for customization | EagleML/referenceTransaction/exchangePrice/customElements/ |
| sourceName |
| string | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| EagleML/referenceTransaction/exchangePrice/sourceName |
| updateSource |
| string | 944 | in_upd_src | SECURITYDBO | PRICE_EXCHANGE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/updateSource |
| effectiveDate | Required | date | 1109 | in_eff_dt | SECURITYDBO | PRICE_EXCHANGE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/effectiveDate |
| languageId |
| integer |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/languageId |
| tagNochangecase |
| string |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/tagNochangecase |
| preserveNull |
| string |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/preserveNull |
| noLoadValidationFlag |
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/noLoadValidationFlag |
| accountingValidationFlag |
| YesNoOptionEnum |
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/accountingValidationFlag |
| Asset Identifiers Model | EagleML/referenceTransaction/exchangePrice/ |
| priceExchangeCode |
| string | 9036 |
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/priceExchangeCode |
| archiveFlag |
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/archiveFlag |
| excludePriceDemandFlag |
| YesNoOptionEnum | 1256 |
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/excludePriceDemandFlag |
| exceptionProcessingSwitch |
| YesNoOptionEnum | 989 |
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/exceptionProcessingSwitch |
| valuePositionsAtCostSwitch |
| YesNoOptionEnum | 990 |
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/valuePositionsAtCostSwitch |
| closingPrice |
| decimal | 481 | in_price | SECURITYDBO | PRICE_EXCHANGE | PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/closingPrice |
| oidYield |
| decimal | 39 | in_yld | SECURITYDBO | PRICE_EXCHANGE | YIELD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/oidYield |
| yieldType |
| string | 1113 | in_yld_type | SECURITYDBO | PRICE_EXCHANGE | YIELD_TYPE_CODE | CHAR(8) | EagleML/referenceTransaction/exchangePrice/yieldType |
| priceTypeCode |
| string | 1843 | in_price_type_code | SECURITYDBO | PRICE_EXCHANGE | PRICE_TYPE_CODE | VARCHAR2(15) | EagleML/referenceTransaction/exchangePrice/priceTypeCode |
| priceFlag |
| string | 7042 (1844) | in_price_flag | SECURITYDBO | PRICE_EXCHANGE | PRICING_FLAG | CHAR(2) | EagleML/referenceTransaction/exchangePrice/priceFlag |
| lastTradedPrice |
| decimal | 7724 (1845) | in_px_last | SECURITYDBO | PRICE_EXCHANGE | PX_LAST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lastTradedPrice |
| bidPrice |
| decimal | 7722 (1846) | in_px_bid | SECURITYDBO | PRICE_EXCHANGE | PX_BID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/bidPrice |
| askPrice |
| decimal | 7721 (1847) | in_px_ask | SECURITYDBO | PRICE_EXCHANGE | PX_ASK | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/askPrice |
| highPrice |
| decimal | 1848 | in_px_high | SECURITYDBO | PRICE_EXCHANGE | PX_HIGH | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/highPrice |
| lowPrice |
| decimal | 1849 | in_px_low | SECURITYDBO | PRICE_EXCHANGE | PX_LOW | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lowPrice |
| midPrice |
| decimal | 7725 (1850) | in_px_mid | SECURITYDBO | PRICE_EXCHANGE | PX_MID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/midPrice |
| priceVolume |
| decimal | 1851 | in_px_volume | SECURITYDBO | PRICE_EXCHANGE | PX_VOLUME | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/priceVolume |
| priceLevel |
| integer | 12007 | in_price_level | SECURITYDBO | PRICE_EXCHANGE | PRICE_LEVEL | NUMBER(38,0) | EagleML/referenceTransaction/exchangePrice/priceLevel |
| priceCondition |
| string | 4849 | in_price_condition | SECURITYDBO | PRICE_EXCHANGE | PRICE_CONDITION | VARCHAR2(20) | EagleML/referenceTransaction/exchangePrice/priceCondition |
| originalPrice |
| decimal | 893 | in_original_price | SECURITYDBO | PRICE_EXCHANGE | ORIGINAL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/originalPrice |
| units |
| decimal | 40 | in_units | SECURITYDBO | PRICE_EXCHANGE | UNITS | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/units |
| referencePrice |
| decimal | 1852 | in_px_reference | SECURITYDBO | PRICE_EXCHANGE | PX_REFERENCE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/referencePrice |
| priceSource |
| string | 513 | in_src | SECURITYDBO | PRICE_EXCHANGE | PX_SOURCE | CHAR(8) | EagleML/referenceTransaction/exchangePrice/priceSource |
| priceTolerance |
| decimal | 45 |
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/priceTolerance |
| calculatedMean |
| decimal | 11847 | in_calculated_mean | SECURITYDBO | PRICE_EXCHANGE | CALCULATED_MEAN | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/calculatedMean |
| fairValueFactor |
| decimal | 10813 | in_fair_value_factor | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/fairValueFactor |
| dirtyPrice |
| decimal | 2895 | in_px_dirty | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/dirtyPrice |
| cleanPriceInclOption |
| decimal |
|
| not stored in DB |
| EagleML/referenceTransaction/exchangePrice/cleanPriceInclOption |
| nominalDirtyPrice |
| decimal | 2896 | in_px_nominal_dirty | SECURITYDBO | PRICE_EXCHANGE | PX_NOMINAL_DIRTY | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/nominalDirtyPrice |
| cleanInclOptionPrice |
| decimal | 2897 | in_px_clean_incl_option | SECURITYDBO | PRICE_EXCHANGE | PX_CLEAN_INCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/cleanInclOptionPrice |
| dirtyInclOptionPrice |
| decimal | 2898 | in_px_dirty_incl_option | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY_INCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/dirtyInclOptionPrice |
| cleanExclOptionPrice |
| decimal | 2899 | in_px_clean_excl_option | SECURITYDBO | PRICE_EXCHANGE | PX_CLEAN_EXCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/cleanExclOptionPrice |
| dirtyExclOptionPrice |
| decimal | 2900 | in_px_dirty_excl_option | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY_EXCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/dirtyExclOptionPrice |
| callOptionPrice |
| decimal | 2901 | in_px_call_option | SECURITYDBO | PRICE_EXCHANGE | PX_CALL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/callOptionPrice |
| putOptionPrice |
| decimal | 8548 | in_px_put_option | SECURITYDBO | PRICE_EXCHANGE | PX_PUT_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/putOptionPrice |
| fairValuePrice |
| decimal | 2902 | in_fair_value_price | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_PRICE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/fairValuePrice |
| fairValueInclAccrued |
| decimal | 2903 | in_fair_value_incl_accrued | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_INCL_ACCRUED | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/fairValueInclAccrued |
| averagePrice |
| decimal | 5595 | in_px_average | SECURITYDBO | PRICE_EXCHANGE | PX_AVERAGE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/averagePrice |
| fixingPrice |
| decimal | 5596 | in_px_fixing | SECURITYDBO | PRICE_EXCHANGE | PX_FIXING | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/fixingPrice |
| grossAskPrice |
| decimal | 5597 | in_px_gross_ask | SECURITYDBO | PRICE_EXCHANGE | PX_GROSS_ASK | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/grossAskPrice |
| grossBidPrice |
| decimal | 5598 | in_px_gross_bid | SECURITYDBO | PRICE_EXCHANGE | PX_GROSS_BID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/grossBidPrice |
| grossMidPrice |
| decimal | 5599 | in_px_gross_mid | SECURITYDBO | PRICE_EXCHANGE | PX_GROSS_MID | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/grossMidPrice |
| histClosePrice |
| decimal | 5600 | in_px_hist_close | SECURITYDBO | PRICE_EXCHANGE | PX_HIST_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/histClosePrice |
| midClosePrice |
| decimal | 5602 | in_px_mid_close | SECURITYDBO | PRICE_EXCHANGE | PX_MID_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/midClosePrice |
| meanPrice |
| decimal | 10427 | in_px_mean | SECURITYDBO | PRICE_EXCHANGE | PX_MEAN | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/meanPrice |
| nominalPrice |
| decimal | 5603 | in_px_nominal | SECURITYDBO | PRICE_EXCHANGE | PX_NOMINAL | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/nominalPrice |
| officialClosePrice |
| decimal | 5604 | in_px_official_close | SECURITYDBO | PRICE_EXCHANGE | PX_OFFICIAL_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/officialClosePrice |
| openPrice |
| decimal | 7726 (5605) | in_px_open | SECURITYDBO | PRICE_EXCHANGE | PX_OPEN | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/openPrice |
| sarulePrice |
| decimal | 5606 | in_px_sarule | SECURITYDBO | PRICE_EXCHANGE | PX_SARULE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/sarulePrice |
| vwapClosePrice |
| decimal | 5607 | in_px_vwap_close | SECURITYDBO | PRICE_EXCHANGE | PX_VWAP_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/vwapClosePrice |
| reinvestDate |
| date | 5608 | in_reinvest_date | SECURITYDBO | PRICE_EXCHANGE | REINVEST_DATE | DATE | EagleML/referenceTransaction/exchangePrice/reinvestDate |
| shsUsedForEarningsComp |
| decimal | 5609 | in_shs_used_for_earnings_comp | SECURITYDBO | PRICE_EXCHANGE | SHS_USED_FOR_EARNINGS_COMP | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/shsUsedForEarningsComp |
| shsUsedForOwnershipComp |
| decimal | 5610 | in_shs_used_for_ownership_comp | SECURITYDBO | PRICE_EXCHANGE | SHS_USED_FOR_OWNERSHIP_COMP | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/shsUsedForOwnershipComp |
| status |
| string | 5614 | in_status | SECURITYDBO | PRICE_EXCHANGE | STATUS | VARCHAR2(25) | EagleML/referenceTransaction/exchangePrice/status |
| stcgDist |
| decimal | 5615 | in_stcg_dist | SECURITYDBO | PRICE_EXCHANGE | STCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/stcgDist |
| subsidyRatio |
| decimal | 5616 | in_subsidy_ratio | SECURITYDBO | PRICE_EXCHANGE | SUBSIDY_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/subsidyRatio |
| totalDist |
| decimal | 5617 | in_total_dist | SECURITYDBO | PRICE_EXCHANGE | TOTAL_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/totalDist |
| askAdrPrice |
| decimal | 10424 | in_px_ask_adr | SECURITYDBO | PRICE_EXCHANGE | PX_ASK_ADR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/askAdrPrice |
| bidAdrPrice |
| decimal | 10425 | in_px_bid_adr | SECURITYDBO | PRICE_EXCHANGE | PX_BID_ADR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/bidAdrPrice |
| lastAdrPrice |
| decimal | 10426 | in_px_last_adr | SECURITYDBO | PRICE_EXCHANGE | PX_LAST_ADR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lastAdrPrice |
| priceLastUpdateDate |
| date | 5601 | in_px_last_update_date | SECURITYDBO | PRICE_EXCHANGE | PX_LAST_UPDATE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/priceLastUpdateDate |
| basis |
| decimal | 5581 | in_basis | SECURITYDBO | PRICE_EXCHANGE | BASIS | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/basis |
| bestRuleName |
| string | 5582 | in_best_rule_name | SECURITYDBO | PRICE_EXCHANGE | BEST_RULE_NAME | VARCHAR2(15) | EagleML/referenceTransaction/exchangePrice/bestRuleName |
| expenseRatio |
| decimal | 5583 | in_expense_ratio | SECURITYDBO | PRICE_EXCHANGE | EXPENSE_RATIO | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/expenseRatio |
| incomeDist |
| decimal | 5584 | in_income_dist | SECURITYDBO | PRICE_EXCHANGE | INCOME_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/incomeDist |
| lastUpdateDate |
| date | 7652 (5585) | in_last_update_date | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_DATE | DATE | EagleML/referenceTransaction/exchangePrice/lastUpdateDate |
| lastUpdatePrice |
| decimal | 5586 | in_last_update_price | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/lastUpdatePrice |
| lastUpdateSource |
| string | 5587 | in_last_update_source | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_SOURCE | VARCHAR2(20) | EagleML/referenceTransaction/exchangePrice/lastUpdateSource |
| lastUpdateTime |
| string | 5588 | in_last_update_time | SECURITYDBO | PRICE_EXCHANGE | LAST_UPDATE_TIME | CHAR(8) | EagleML/referenceTransaction/exchangePrice/lastUpdateTime |
| ltcgDist |
| decimal | 5589 | in_ltcg_dist | SECURITYDBO | PRICE_EXCHANGE | LTCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/ltcgDist |
| mtcgDist |
| decimal | 5590 | in_mtcg_dist | SECURITYDBO | PRICE_EXCHANGE | MTCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/mtcgDist |
| naicPrice |
| decimal | 5591 | in_naic_price | SECURITYDBO | PRICE_EXCHANGE | NAIC_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/naicPrice |
| navCurrent |
| decimal | 5592 | in_nav_current | SECURITYDBO | PRICE_EXCHANGE | NAV_CURRENT | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/navCurrent |
| navReinvest |
| decimal | 5593 | in_nav_reinvest | SECURITYDBO | PRICE_EXCHANGE | NAV_REINVEST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/navReinvest |
| otherDist |
| decimal | 5594 | in_other_dist | SECURITYDBO | PRICE_EXCHANGE | OTHER_DIST | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/otherDist |
| stkdivFlag |
| string | 10428 | in_stkdiv_flag | SECURITYDBO | PRICE_EXCHANGE | STKDIV_FLAG | VARCHAR2(8) | EagleML/referenceTransaction/exchangePrice/stkdivFlag |
| stkspltFlag |
| string | 10429 | in_stksplt_flag | SECURITYDBO | PRICE_EXCHANGE | STKSPLT_FLAG | VARCHAR2(8) | EagleML/referenceTransaction/exchangePrice/stkspltFlag |
| preFvPrice |
| decimal | 2502 | in_pre_fv_price | SECURITYDBO | PRICE_EXCHANGE | PRE_FV_PRICE | NUMBER(38,12) | EagleML/referenceTransaction/exchangePrice/preFvPrice |
| marketDate |
| date | 2410 | in_market_date | SECURITYDBO | PRICE_EXCHANGE | MARKET_DATE | DATE | EagleML/referenceTransaction/exchangePrice/marketDate |
| userDate1 |
| date | 5618 | in_user_date1 | SECURITYDBO | PRICE_EXCHANGE | USER_DATE1 | DATE | EagleML/referenceTransaction/exchangePrice/userDate1 |
| userDate2 |
| date | 5619 | in_user_date2 | SECURITYDBO | PRICE_EXCHANGE | USER_DATE2 | DATE | EagleML/referenceTransaction/exchangePrice/userDate2 |
| userDate3 |
| date | 5620 | in_user_date3 | SECURITYDBO | PRICE_EXCHANGE | USER_DATE3 | DATE | EagleML/referenceTransaction/exchangePrice/userDate3 |
| userFee1 |
| decimal | 5621 | in_user_fee1 | SECURITYDBO | PRICE_EXCHANGE | USER_FEE1 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userFee1 |
| userFee2 |
| decimal | 5622 | in_user_fee2 | SECURITYDBO | PRICE_EXCHANGE | USER_FEE2 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userFee2 |
| userFee3 |
| decimal | 5623 | in_user_fee3 | SECURITYDBO | PRICE_EXCHANGE | USER_FEE3 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userFee3 |
| userNav1 |
| decimal | 5624 | in_user_nav1 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV1 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav1 |
| userNav2 |
| decimal | 5625 | in_user_nav2 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV2 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav2 |
| userNav3 |
| decimal | 5626 | in_user_nav3 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV3 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav3 |
| userNav4 |
| decimal | 5627 | in_user_nav4 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV4 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav4 |
| userNav5 |
| decimal | 5628 | in_user_nav5 | SECURITYDBO | PRICE_EXCHANGE | USER_NAV5 | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/userNav5 |
| sourceDetail |
| string | 5669 (2503) | in_source_detail | SECURITYDBO | PRICE_EXCHANGE | SOURCE_DETAIL | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/sourceDetail |
| sourceFieldName |
| string | 5611 | in_source_field_name | SECURITYDBO | PRICE_EXCHANGE | SOURCE_FIELD_NAME | CHAR(30) | EagleML/referenceTransaction/exchangePrice/sourceFieldName |
| sourceLevel |
| decimal | 5612 | in_source_level | SECURITYDBO | PRICE_EXCHANGE | SOURCE_LEVEL | NUMBER | EagleML/referenceTransaction/exchangePrice/sourceLevel |
| sourceSrcIntfcName |
| string | 5613 | in_source_src_intfc_name | SECURITYDBO | PRICE_EXCHANGE | SOURCE_SRC_INTFC_NAME | CHAR(15) | EagleML/referenceTransaction/exchangePrice/sourceSrcIntfcName |
| sourceSrcIntfcInst |
| integer | 4855 | in_source_src_intfc_inst | SECURITYDBO | PRICE_EXCHANGE | SOURCE_SRC_INTFC_INST | NUMBER | EagleML/referenceTransaction/exchangePrice/sourceSrcIntfcInst |
| priceCurrency |
| string | 1111 | in_price_currency | SECURITYDBO | PRICE_EXCHANGE | PRICE_CURRENCY | CHAR(8) | EagleML/referenceTransaction/exchangePrice/priceCurrency |
| percentChange1m |
| decimal | 18434 | in_percent_change_1m | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_1M | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange1m |
| percentChange3m |
| decimal | 18435 | in_percent_change_3m | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_3M | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange3m |
| percentChange6m |
| decimal | 18436 | in_percent_change_6m | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_6M | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange6m |
| percentChange1yr |
| decimal | 18437 | in_percent_change_1yr | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_1YR | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChange1yr |
| percentChangeWtd |
| decimal | 18438 | in_percent_change_wtd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_WTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeWtd |
| percentChangeMtd |
| decimal | 18439 | in_percent_change_mtd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_MTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeMtd |
| percentChangeQtd |
| decimal | 18440 | in_percent_change_qtd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_QTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeQtd |
| percentChangeYtd |
| decimal | 18441 | in_percent_change_ytd | SECURITYDBO | PRICE_EXCHANGE | PERCENT_CHANGE_YTD | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/percentChangeYtd |
| pxDirtyClean |
| string | 18442 | in_px_dirty_clean | SECURITYDBO | PRICE_EXCHANGE | PX_DIRTY_CLEAN | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/pxDirtyClean |
| pxSettle |
| decimal | 18443 | in_px_settle | SECURITYDBO | PRICE_EXCHANGE | PX_SETTLE | NUMBER(28,12) | EagleML/referenceTransaction/exchangePrice/pxSettle |
| pxSettleLastDate |
| date | 18444 | in_px_settle_last_date | SECURITYDBO | PRICE_EXCHANGE | PX_SETTLE_LAST_DATE | DATE | EagleML/referenceTransaction/exchangePrice/pxSettleLastDate |
| quotedSpec |
| string | 18445 | in_quoted_spec | SECURITYDBO | PRICE_EXCHANGE | QUOTED_SPEC | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/quotedSpec |
| settlementType |
| string | 18446 | in_settlement_type | SECURITYDBO | PRICE_EXCHANGE | SETTLEMENT_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/exchangePrice/settlementType |