Element
Optional/Required
Value Type
Star Tag
SP Parameter
SP Type
Eagle DB
DB Table
DB Field
DB Field Type
XPath
objectType
Optional
ObjectTypeEnum
not stored in DB
EagleML/referenceTransaction/issuePrice/objectType
objectId
Optional
ObjectId
not stored in DB
EagleML/referenceTransaction/issuePrice/objectId
objectDescription
Optional
FeedTypeEnum
not stored in DB
EagleML/referenceTransaction/issuePrice/objectDescription
updateTimestamp
Optional
dateTime
SECURITYDBO
PRICE
UPDATE_DATE
DATE
EagleML/referenceTransaction/issuePrice/updateTimestamp
customElements
Not recommended
CustomElements
CustomElements reserved for customizations
EagleML/referenceTransaction/issuePrice/customElements
sourceName
Optional
string
1102
in_short_desc
S
PACE_MASTERDBO
INTERFACES
SHORT_DESC
CHAR(15)
EagleML/referenceTransaction/issuePrice/sourceName
updateSource
Optional
string
944
in_upd_src
S
SECURITYDBO
PRICE
UPDATE_SOURCE
VARCHAR2(255)
EagleML/referenceTransaction/issuePrice/updateSource
effectiveDate
Optional
date
1109
in_eff_dt
S
SECURITYDBO
PRICE
EFFECTIVE_DATE
DATE
EagleML/referenceTransaction/issuePrice/effectiveDate
languageId
Optional
integer
not stored in DB
EagleML/referenceTransaction/issuePrice/languageId
tagNochangecase
Optional
string
not stored in DB
EagleML/referenceTransaction/issuePrice/tagNochangecase
preserveNull
Optional
string
not stored in DB
EagleML/referenceTransaction/issuePrice/preserveNull
noLoadValidationFlag
Optional
YesNoOptionEnum
not stored in DB
EagleML/referenceTransaction/issuePrice/noLoadValidationFlag
accountingValidationFlag
Optional
YesNoOptionEnum
not stored in DB
EagleML/referenceTransaction/issuePrice/accountingValidationFlag
EagleML/referenceTransaction/issuePrice/
exceptionProcessingSwitch
Optional
YesNoOptionEnum
not stored in DB
EagleML/referenceTransaction/issuePrice/exceptionProcessingSwitch
valuePositionsAtCostSwitch
Optional
YesNoOptionEnum
not stored in DB
EagleML/referenceTransaction/issuePrice/valuePositionsAtCostSwitch
closingPrice
Optional
decimal
481
in_price
I
SECURITYDBO
PRICE
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath |
|---|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/issuePrice/objectType | ||||||
objectId | Optional | ObjectId | not stored in DB | EagleML/referenceTransaction/issuePrice/objectId | ||||||
objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/issuePrice/objectDescription | ||||||
updateTimestamp | Optional | dateTime | SECURITYDBO | PRICE | UPDATE_DATE | DATE | EagleML/referenceTransaction/issuePrice/updateTimestamp | |||
customElements | Not recommended | CustomElements | CustomElements reserved for customizations | EagleML/referenceTransaction/issuePrice/customElements | ||||||
sourceName | Optional | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/issuePrice/sourceName |
updateSource | Optional | string | 944 | in_upd_src | S | SECURITYDBO | PRICE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/issuePrice/updateSource |
effectiveDate | Optional | date | 1109 | in_eff_dt | S | SECURITYDBO | PRICE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issuePrice/effectiveDate |
languageId | Optional | integer | not stored in DB | EagleML/referenceTransaction/issuePrice/languageId | ||||||
tagNochangecase | Optional | string | not stored in DB | EagleML/referenceTransaction/issuePrice/tagNochangecase | ||||||
preserveNull | Optional | string | not stored in DB | EagleML/referenceTransaction/issuePrice/preserveNull | ||||||
noLoadValidationFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issuePrice/noLoadValidationFlag | ||||||
accountingValidationFlag | Optional | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issuePrice/accountingValidationFlag | ||||||
EagleML/referenceTransaction/issuePrice/ | ||||||||||
exceptionProcessingSwitch | Optional | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issuePrice/exceptionProcessingSwitch | ||||||
valuePositionsAtCostSwitch | Optional | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/issuePrice/valuePositionsAtCostSwitch | ||||||
closingPrice | Optional | decimal | 481 | in_price | I | SECURITYDBO | PRICE | PRICE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/closingPrice |
oidYield | Optional | decimal | 39 | in_yld | I | SECURITYDBO | PRICE | YIELD | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/oidYield |
yieldType | Optional | string | 1113 | in_yld_type | S | SECURITYDBO | PRICE | YIELD_TYPE_CODE | CHAR(8) | EagleML/referenceTransaction/issuePrice/yieldType |
priceTypeCode | Optional | normalizedString | 1843 | in_price_type_code | S | SECURITYDBO | PRICE | PRICE_TYPE_CODE | VARCHAR2(15) | EagleML/referenceTransaction/issuePrice/priceTypeCode |
priceFlag | Optional | string | 1844 | in_price_flag | S | SECURITYDBO | PRICE | PRICING_FLAG | CHAR(2) | EagleML/referenceTransaction/issuePrice/priceFlag |
lastTradedPrice | Optional | decimal | 1845 | in_px_last | I | SECURITYDBO | PRICE | PX_LAST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/lastTradedPrice |
bidPrice | Optional | decimal | 1846 | in_px_bid | I | SECURITYDBO | PRICE | PX_BID | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/bidPrice |
askPrice | Optional | decimal | 1847 | in_px_ask | I | SECURITYDBO | PRICE | PX_ASK | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/askPrice |
highPrice | Optional | decimal | 1848 | in_px_high | I | SECURITYDBO | PRICE | PX_HIGH | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/highPrice |
lowPrice | Optional | decimal | 1849 | in_px_low | I | SECURITYDBO | PRICE | PX_LOW | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/lowPrice |
midPrice | Optional | decimal | 1850 | in_px_mid | I | SECURITYDBO | PRICE | PX_MID | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/midPrice |
priceVolume | Optional | decimal | 1851 | in_px_volume | I | SECURITYDBO | PRICE | PX_VOLUME | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/priceVolume |
priceLevel | Optional | integer | 12007 | in_price_level | I | SECURITYDBO | PRICE | PRICE_LEVEL | NUMBER(38) | EagleML/referenceTransaction/issuePrice/priceLevel |
priceCondition | Optional | string | 4849 | in_price_condition | S | SECURITYDBO | PRICE | PRICE_CONDITION | VARCHAR2(20) | EagleML/referenceTransaction/issuePrice/priceCondition |
originalPrice | Optional | decimal | 893 | in_original_price | I | SECURITYDBO | PRICE | ORIGINAL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/originalPrice |
units | Optional | decimal | 40 | in_units | I | SECURITYDBO | PRICE | UNITS | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/units |
referencePrice | Optional | decimal | 1852 | in_px_reference | I | SECURITYDBO | PRICE | PX_REFERENCE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/referencePrice |
priceSource | Optional | string | 513 | in_src | S | SECURITYDBO | PRICE | PX_SOURCE | CHAR(8) | EagleML/referenceTransaction/issuePrice/priceSource |
priceTolerance | Optional | decimal | not stored in DB | EagleML/referenceTransaction/issuePrice/priceTolerance | ||||||
calculatedMean | Optional | decimal | 11847 | in_calculated_mean | I | SECURITYDBO | PRICE | CALCULATED_MEAN | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
calculatedMean |
fairValueFactor | Optional | decimal |
10813 | in_fair_value_ |
factor | I | SECURITYDBO | PRICE |
FAIR_VALUE_FACTOR | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
fairValueFactor |
dirtyPrice | Optional |
decimal |
2895 | in_ |
S
SECURITYDBO
PRICE
YIELD_TYPE_CODE
px_dirty | I | SECURITYDBO | PRICE | PX_DIRTY | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/dirtyPrice | ||||
cleanPriceInclOption | Optional | decimal | not stored in DB | EagleML/referenceTransaction/issuePrice/ | ||||||
cleanPriceInclOption |
nominalDirtyPrice | Optional |
decimal |
2896 | in_ |
px_ |
nominal_ |
dirty |
I | SECURITYDBO | PRICE |
PX_ |
NOMINAL_ |
DIRTY |
NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
nominalDirtyPrice |
cleanInclOptionPrice | Optional |
decimal |
2897 | in_px_clean_ |
incl_ |
option |
I | SECURITYDBO | PRICE |
PRICING_FLAG
PX_CLEAN_INCL_OPTION | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/ |
cleanInclOptionPrice |
dirtyInclOptionPrice | Optional | decimal |
2898 | in_px_dirty_incl_ |
option | I | SECURITYDBO | PRICE | PX_ |
DIRTY_INCL_OPTION | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
dirtyInclOptionPrice |
cleanExclOptionPrice | Optional | decimal |
2899 | in_px_clean_excl_ |
option | I | SECURITYDBO | PRICE | PX_CLEAN_EXCL_ |
OPTION | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
cleanExclOptionPrice |
dirtyExclOptionPrice | Optional | decimal |
2900 | in_px_dirty_excl_ |
option | I | SECURITYDBO | PRICE | PX_ |
DIRTY_EXCL_OPTION | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
dirtyExclOptionPrice |
callOptionPrice | Optional | decimal |
2901 | in_px_ |
call_option | I | SECURITYDBO | PRICE | PX_CALL_ |
OPTION | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
callOptionPrice |
putOptionPrice | Optional | decimal |
8548 | in_px_ |
put_option | I | SECURITYDBO | PRICE | PX_ |
PUT_OPTION (DB v13.1 or newer) | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
putOptionPrice |
fairValuePrice | Optional | decimal |
2902 | in_fair_ |
value_ |
price | I | SECURITYDBO | PRICE |
FAIR_VALUE_ |
PRICE | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
fairValuePrice |
fairValueInclAccrued | Optional | decimal |
2903 | in_ |
fair_value_incl_accrued | I | SECURITYDBO | PRICE |
FAIR_VALUE_INCL_ACCRUED | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
fairValueInclAccrued |
averagePrice | Optional |
decimal |
5595 | in_ |
px_ |
average | I | SECURITYDBO | PRICE |
PX_ |
AVERAGE | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
averagePrice |
fixingPrice | Optional |
decimal |
5596 | in_ |
px_ |
fixing |
I | SECURITYDBO | PRICE |
PX_ |
FIXING |
NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
fixingPrice |
grossAskPrice | Optional | decimal |
5597 | in_ |
px_gross_ |
ask | I | SECURITYDBO | PRICE |
PX_GROSS_ |
ASK | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
grossAskPrice |
grossBidPrice | Optional | decimal |
5598 | in_px_gross_ |
bid | I | SECURITYDBO | PRICE |
PX_GROSS_BID | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
grossBidPrice |
grossMidPrice | Optional | decimal |
5599 | in_px_gross_ |
mid | I | SECURITYDBO | PRICE | PX_ |
GROSS_MID | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
grossMidPrice |
histClosePrice | Optional |
decimal |
5600 | in_ |
px_hist_close | I | SECURITYDBO | PRICE | PX_ |
HIST_CLOSE |
NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
histClosePrice |
midClosePrice | Optional | decimal |
not stored in DB
EagleML/referenceTransaction/issuePrice/priceTolerance
calculatedMean
Optional
decimal
11847
5602 | in_px_mid_close | I | SECURITYDBO | PRICE |
PX_MID_ |
CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
midClosePrice |
meanPrice | Optional | decimal |
10427 | in_ |
px_ |
mean | I | SECURITYDBO | PRICE |
PX_ |
MEAN | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
meanPrice |
nominalPrice | Optional | decimal |
5603 | in_px_ |
nominal | I | SECURITYDBO | PRICE | PX_ |
NOMINAL | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
nominalPrice |
officialClosePrice | Optional | decimal | 5604 |
in_px_official_close | I | SECURITYDBO | PRICE | PX_OFFICIAL_CLOSE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
officialClosePrice |
openPrice | Optional | decimal |
5605 | in_px_ |
open | I | SECURITYDBO | PRICE | PX_ |
OPEN | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
openPrice |
sarulePrice | Optional | decimal |
5606 | in_px_ |
sarule | I | SECURITYDBO | PRICE | PX_ |
SARULE | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
sarulePrice |
vwapClosePrice | Optional | decimal |
5607 | in_px_ |
vwap_ |
close | I | SECURITYDBO | PRICE | PX_ |
VWAP_ |
CLOSE | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
vwapClosePrice |
reinvestDate | Optional |
date |
5608 | in_ |
reinvest_date | S | SECURITYDBO | PRICE |
PX_CLEAN_EXCL_OPTION
REINVEST_DATE | DATE | EagleML/referenceTransaction/issuePrice/ |
reinvestDate |
shsUsedForEarningsComp | Optional | decimal |
5609 | in_ |
shs_used_ |
for_ |
earnings_ |
comp | I | SECURITYDBO | PRICE |
SHS_USED_ |
FOR_ |
EARNINGS_ |
COMP | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
shsUsedForEarningsComp |
shsUsedForOwnershipComp | Optional | decimal |
5610 | in_ |
shs_used_for_ownership_comp | I | SECURITYDBO | PRICE |
SHS_USED_FOR_OWNERSHIP_COMP | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
shsUsedForOwnershipComp |
status | Optional |
string |
5614 | in_ |
status | S | SECURITYDBO | PRICE |
PX_PUT_OPTION (DB version 13.1 or newer)
STATUS | VARCHAR2(25) | EagleML/referenceTransaction/issuePrice/ |
status |
stcgDist | Optional | decimal |
5615 | in_ |
stcg_ |
dist | I | SECURITYDBO | PRICE |
STCG_ |
DIST | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
stcgDist |
subsidyRatio | Optional | decimal |
5616 | in_ |
subsidy_ratio | I | SECURITYDBO | PRICE |
SUBSIDY_RATIO | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
subsidyRatio |
totalDist | Optional | decimal |
5617 | in_ |
total_ |
dist | I | SECURITYDBO | PRICE |
TOTAL_ |
DIST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
totalDist |
askAdrPrice | Optional | decimal |
10424 | in_px_ |
ask_adr | I | SECURITYDBO | PRICE | PX_ |
ASK_ADR | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
askAdrPrice |
bidAdrPrice | Optional | decimal |
10425 | in_px_ |
bid_ |
adr | I | SECURITYDBO | PRICE | PX_ |
BID_ |
ADR | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
bidAdrPrice |
lastAdrPrice | Optional | decimal |
10426 | in_px_ |
last_ |
adr | I | SECURITYDBO | PRICE | PX_ |
LAST_ |
ADR | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
lastAdrPrice |
priceLastUpdateDate | Optional |
date |
5601 | in_px_ |
last_update_ |
date |
S | SECURITYDBO | PRICE | PX_LAST_ |
UPDATE_ |
DATE | DATE | EagleML/referenceTransaction/issuePrice/ |
priceLastUpdateDate |
basis | Optional | decimal |
5581 | in_ |
basis | I | SECURITYDBO | PRICE |
BASIS | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
basis |
bestRuleName | Optional |
string |
5582 | in_ |
best_ |
rule_ |
name |
S | SECURITYDBO | PRICE |
BEST_ |
RULE_ |
NAME |
VARCHAR2( |
15) | EagleML/referenceTransaction/issuePrice/ |
bestRuleName |
expenseRatio | Optional | decimal |
5583 | in_ |
expense_ |
ratio | I | SECURITYDBO | PRICE |
EXPENSE_ |
RATIO | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
expenseRatio |
incomeDist | Optional | decimal |
5584 | in_ |
income_ |
dist | I | SECURITYDBO | PRICE |
INCOME_ |
DIST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
incomeDist |
lastUpdateDate | Optional |
date |
5585 | in_ |
last_ |
update_ |
date |
S | SECURITYDBO | PRICE |
LAST_ |
UPDATE_ |
DATE | DATE | EagleML/referenceTransaction/issuePrice/ |
lastUpdateDate |
lastUpdatePrice | Optional | decimal |
5586 | in_last_ |
update_ |
price | I | SECURITYDBO | PRICE |
LAST_UPDATE_ |
PRICE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
lastUpdatePrice |
lastUpdateSource | Optional |
string |
5587 | in_last_ |
update_ |
source |
S | SECURITYDBO | PRICE |
LAST_UPDATE_ |
SOURCE |
VARCHAR2( |
20) | EagleML/referenceTransaction/issuePrice/ |
lastUpdateSource |
lastUpdateTime | Optional |
string |
5588 | in_ |
last_ |
update_ |
time |
S | SECURITYDBO | PRICE |
LAST_ |
UPDATE_ |
TIME |
CHAR( |
8) | EagleML/referenceTransaction/issuePrice/ |
lastUpdateTime |
ltcgDist | Optional |
decimal |
5589 | in_ |
ltcg_ |
dist |
I | SECURITYDBO | PRICE |
LTCG_ |
DIST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
ltcgDist |
mtcgDist | Optional | decimal |
5590 | in_ |
mtcg_dist | I | SECURITYDBO | PRICE |
MTCG_DIST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
mtcgDist |
naicPrice | Optional | decimal |
5591 | in_ |
naic_price | I | SECURITYDBO | PRICE |
NAIC_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
naicPrice |
navCurrent | Optional |
decimal |
5592 | in_ |
nav_current |
I | SECURITYDBO | PRICE |
NAV_CURRENT |
NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
navCurrent |
navReinvest | Optional | decimal |
5593 | in_ |
nav_ |
reinvest | I | SECURITYDBO | PRICE |
NAV_ |
REINVEST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
navReinvest |
otherDist | Optional | decimal |
5594 | in_ |
other_ |
dist | I | SECURITYDBO | PRICE |
OTHER_ |
DIST | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
otherDist |
stkdivFlag | Optional |
string |
10428 | in_ |
stkdiv_ |
flag |
S | SECURITYDBO | PRICE |
STKDIV_ |
FLAG |
VARCHAR2( |
8) | EagleML/referenceTransaction/issuePrice/ |
stkdivFlag |
stkspltFlag | Optional |
string |
10429 | in_ |
stksplt_ |
flag |
S | SECURITYDBO | PRICE |
STKSPLT_ |
FLAG |
VARCHAR2( |
8) | EagleML/referenceTransaction/issuePrice/ |
stkspltFlag |
preFvPrice | Optional | decimal |
2502 | in_ |
pre_ |
fv_ |
price | I | SECURITYDBO | PRICE |
PRE_ |
FV_ |
PRICE | NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
preFvPrice |
marketDate | Optional |
string |
2410 | in_ |
market_ |
date |
S | SECURITYDBO | PRICE |
MARKET_ |
DATE | DATE | EagleML/referenceTransaction/issuePrice/ |
marketDate |
userDate1 | Optional | date |
5618 | in_ |
user_date1 | S | SECURITYDBO | PRICE |
USER_DATE1 | DATE | EagleML/referenceTransaction/issuePrice/ |
userDate1 |
userDate2 | Optional |
date |
5619 | in_user_ |
date2 |
S | SECURITYDBO | PRICE |
BASIS
USER_DATE2 | DATE | EagleML/referenceTransaction/issuePrice/ |
userDate2 |
userDate3 | Optional |
date |
5620 | in |
_ |
user_ |
date3 | S | SECURITYDBO | PRICE |
USER_ |
DATE3 | DATE | EagleML/referenceTransaction/issuePrice/ |
userDate3 |
userFee1 | Optional | decimal |
5621 | in_ |
user_ |
fee1 | I | SECURITYDBO | PRICE |
USER_ |
FEE1 | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
userFee1 |
userFee2 | Optional | decimal |
5622 | in_ |
user_ |
fee2 | I | SECURITYDBO | PRICE |
USER_ |
FEE2 | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
userFee2 |
userFee3 | Optional |
decimal |
5623 | in_ |
user_ |
fee3 |
I | SECURITYDBO | PRICE |
USER_ |
FEE3 | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
userFee3 |
userNav1 | Optional | decimal |
5624 | in_ |
user_ |
nav1 | I | SECURITYDBO | PRICE |
USER_ |
NAV1 | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
userNav1 |
userNav2 | Optional |
decimal |
5625 | in_ |
user_ |
nav2 |
I | SECURITYDBO | PRICE |
USER_ |
NAV2 |
NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
userNav2 |
userNav3 | Optional |
decimal |
5626 | in_ |
user_ |
nav3 |
I | SECURITYDBO | PRICE |
USER_ |
NAV3 |
NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
userNav3 |
userNav4 | Optional | decimal |
5627 | in_ |
user_ |
nav4 | I | SECURITYDBO | PRICE |
USER_ |
NAV4 | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
userNav4 |
userNav5 | Optional | decimal |
5628 | in_ |
user_ |
nav5 | I | SECURITYDBO | PRICE |
USER_ |
NAV5 | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
userNav5 |
sourceDetail | Optional |
string |
2503 | in_ |
source_ |
detail |
S | SECURITYDBO | PRICE |
SOURCE_ |
DETAIL |
VARCHAR2( |
255) | EagleML/referenceTransaction/issuePrice/ |
sourceDetail |
sourceFieldName | Optional |
string |
5611 | in_source_ |
field_ |
name |
S | SECURITYDBO | PRICE |
SOURCE_FIELD_ |
NAME |
CHAR( |
30) | EagleML/referenceTransaction/issuePrice/ |
sourceFieldName |
sourceLevel | Optional | decimal |
5612 | in_ |
source_ |
level | I | SECURITYDBO | PRICE |
NAV_REINVEST
SOURCE_LEVEL | NUMBER | EagleML/referenceTransaction/issuePrice/ |
sourceLevel |
sourceSrcIntfcName | Optional |
string |
5613 | in_source_src_ |
intfc_ |
name |
S | SECURITYDBO | PRICE |
OTHER_DIST
SOURCE_SRC_INTFC_NAME | CHAR(15) | EagleML/referenceTransaction/issuePrice/ |
sourceSrcIntfcName |
sourceSrcIntfcInst | Optional |
integer |
4855 | in_source_ |
src_intfc_ |
inst |
I | SECURITYDBO | PRICE |
STKDIV_FLAG
SOURCE_SRC_INTFC_INST | NUMBER(38) | EagleML/referenceTransaction/issuePrice/ |
sourceSrcIntfcInst |
priceCurrency | Optional | string |
85 | in_ |
curr | S | SECURITYDBO | PRICE |
PRICE_ |
CURRENCY |
CHAR(8) | EagleML/referenceTransaction/issuePrice/ |
priceCurrency |
percentChange1m | Optional | decimal |
18434 | in_ |
percent_ |
change_ |
1m | I | SECURITYDBO | PRICE |
PERCENT_ |
CHANGE_ |
1M | NUMBER( |
28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChange1m |
percentChange3m | Optional |
decimal |
18435 | in_ |
percent_change_ |
3m |
I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
3M | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChange3m |
percentChange6m | Optional |
decimal |
18436 | in_percent_ |
change_ |
6m |
I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
6M | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChange6m |
percentChange1yr | Optional |
decimal |
18437 | in_ |
percent_change_ |
1yr |
I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
1YR | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChange1yr |
percentChangeWtd | Optional |
decimal |
18438 | in_ |
percent_change_ |
wtd |
I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
WTD | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChangeWtd |
percentChangeMtd | Optional | decimal |
18439 | in_ |
percent_change_ |
mtd | I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
MTD | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChangeMtd |
percentChangeQtd | Optional | decimal |
18440 | in_ |
percent_change_ |
qtd | I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
QTD | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChangeQtd |
percentChangeYtd | Optional | decimal |
18441 | in_percent_ |
change_ |
ytd | I | SECURITYDBO | PRICE |
PERCENT_CHANGE_ |
YTD | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
percentChangeYtd |
pxDirtyClean | Optional |
string |
18442 | in_px_ |
dirty_ |
clean |
S | SECURITYDBO | PRICE |
PX_DIRTY_ |
CLEAN |
VARCHAR2( |
255) | EagleML/referenceTransaction/issuePrice/ |
pxDirtyClean |
pxSettle | Optional | decimal |
18443 | in_ |
px_ |
settle | I | SECURITYDBO | PRICE |
PX_ |
SETTLE | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
pxSettle |
pxSettleLastDate | Optional |
date |
18444 | in_px_ |
settle_last_ |
date |
S | SECURITYDBO | PRICE |
USER_NAV3
PX_SETTLE_LAST_DATE | DATE | EagleML/referenceTransaction/issuePrice/ |
pxSettleLastDate |
quotedSpec | Optional |
string |
18445 | in_ |
quoted_ |
spec |
S | SECURITYDBO | PRICE |
QUOTED_ |
SPEC |
VARCHAR2( |
255) | EagleML/referenceTransaction/issuePrice/ |
quotedSpec |
settlementType | Optional |
string |
18446 | in_ |
settlement_ |
type |
S | SECURITYDBO | PRICE |
SETTLEMENT_ |
TYPE |
VARCHAR2( |
255) | EagleML/referenceTransaction/issuePrice/ |
settlementType |
confidenceInterval | Optional |
decimal |
10957 | in_ |
confidence_ |
interval |
I | SECURITYDBO | PRICE |
CONFIDENCE_ |
INTERVAL |
NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
confidenceInterval |
bloombergAskPriceScore | Optional |
decimal |
18348 | in_ |
ask_ |
score |
I | SECURITYDBO | PRICE |
ASK_ |
SCORE |
NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
bloombergAskPriceScore |
bloombergBidPriceScore | Optional | decimal |
18349 | in_ |
bid_ |
score | I | SECURITYDBO | PRICE |
BID_ |
SCORE | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/ |
bloombergBidPriceScore |
bloombergMidPriceScore | Optional |
decimal |
18350 | in_ |
mid_score | I | SECURITYDBO | PRICE |
SOURCE_SRC_INTFC_NAME
MID_SCORE | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/ |
bloombergMidPriceScore |
bloombergQuoteCode | Optional |
decimal |
10381 | in_ |
quote_type | I | SECURITYDBO | PRICE |
QUOTE_TYPE | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/ |
bloombergQuoteCode |
pricingEntityId | Optional | string |
7107 | in_ |
entity_id | S | SECURITYDBO | PRICE |
ENTITY_ |
ID | CHAR(8) | EagleML/referenceTransaction/issuePrice/ |
pricingEntityId |
priceConversionFxRate | Optional | decimal |
7682 | in_price_conversion_fx_rate | I | SECURITYDBO | PRICE |
PRICE_CONVERSION_ |
FX_RATE | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/ |
priceConversionFxRate |
priceConversionFxSource | Optional |
string | 7108 | in_price_conv_fx_source | S | SECURITYDBO | PRICE |
PRICE_CONV_ |
FX_SOURCE | VARCHAR2(15) | EagleML/referenceTransaction/issuePrice/ |
priceConversionFxSource |
pxYest | Optional | decimal | 7728 | in_px_yest | I | SECURITYDBO | PRICE |
PX_YEST | NUMBER(38,12) | EagleML/referenceTransaction/issuePrice/ |
pxYest |
payRecIndicator | Optional | string |
4590 |
S | SECURITYDBO |
SWAPS |
PAY_ |
RECEIVE_IND | VARCHAR2(10) | EagleML/referenceTransaction/issuePrice/ |
payRecIndicator |
payPriceLeg | EagleML/referenceTransaction/issuePrice/payPriceLeg | |||||||||
receivePriceLeg | EagleML/referenceTransaction/issuePrice/ | |||||||||
receivePriceLeg | ||||||||||||||||
| ||||||||||||||||
notionalAmount | Optional | decimal | 7683 | in_pay_leg_notional | I | SECURITYDBO | PRICE | |||||||||
PAY_ |
LEG_NOTIONAL | NUMBER(38,12) | ../notionalAmount | |||||
price | Optional | decimal | 7680 | in_pay_leg_price_or_mv | I | SECURITYDBO | PRICE |
PAY_LEG_PRICE_OR_MV | NUMBER(38,12) | ../price | |||||
marketValue | Optional | decimal | 7680 | in_pay_leg_price_or_mv | I | SECURITYDBO | PRICE |
PAY_LEG_PRICE_OR_MV | NUMBER(38,12) | ../marketValue | ||||||||
Receive Price Leg Model | ||||||||||
notionalAmount | Optional | decimal | 7684 | in_rec_leg_notional | I | SECURITYDBO | PRICE | |||
REC_LEG_NOTIONAL | NUMBER(38,12) | ../notionalAmount |
price | Optional |
decimal |
7681 | in_rec_leg_price_or_mv | I | SECURITYDBO | PRICE | REC_LEG_PRICE_OR_MV | NUMBER(38,12) | ../price | |||
marketValue | Optional | decimal | 7681 | in_rec_leg_price_or_mv | I | SECURITYDBO | PRICE | REC_LEG_PRICE_OR_MV | NUMBER(38,12) | ../marketValue |