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
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_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 | 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 |
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 |
REINVEST_ |
DATE | DATE | EagleML/referenceTransaction/issuePrice/ |
reinvestDate |
shsUsedForEarningsComp | Optional |
decimal |
5609 | in_ |
shs_used_for_earnings_comp | I | SECURITYDBO | PRICE |
PX_SOURCE
SHS_USED_FOR_EARNINGS_COMP | NUMBER(28,12) | EagleML/referenceTransaction/issuePrice/ |
shsUsedForEarningsComp |
shsUsedForOwnershipComp | Optional | decimal |
not stored in DB
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 |
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
not stored in DB
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 |
SHS_USED_FOR_EARNINGS_COMP
USER_DATE2 | DATE | EagleML/referenceTransaction/issuePrice/ |
userDate2 |
userDate3 | Optional |
date |
5620 | in_ |
user_date3 | S | SECURITYDBO | PRICE |
SHS_USED_FOR_OWNERSHIP_COMP
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 |
PX_LAST_UPDATE_DATE
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 |
SOURCE_ |
LEVEL | NUMBER |
EagleML/referenceTransaction/issuePrice/ |
sourceLevel |
sourceSrcIntfcName | Optional |
string |
5613 | in_ |
source_src_intfc_name | S | SECURITYDBO | PRICE |
INCOME_DIST
SOURCE_SRC_INTFC_NAME | CHAR(15) | EagleML/referenceTransaction/issuePrice/ |
sourceSrcIntfcName |
sourceSrcIntfcInst | Optional |
integer |
4855 | in_source_ |
src_ |
intfc_ |
inst |
I | SECURITYDBO | PRICE |
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 |
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 |
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 |
USER_NAV3
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 |
5628
in_user_nav5
I
4590 | S | SECURITYDBO |
SWAPS |
PAY_RECEIVE_ |
IND |
VARCHAR2( |
10) | EagleML/referenceTransaction/ |
sourceDetail
Optional
string
2503
in_source_detail
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) |
EagleML/referenceTransaction/issuePrice/sourceDetail
../notionalAmount | |
price | Optional |
decimal |
7680 | in_pay_ |
leg_price_ |
or_ |
mv |
I | SECURITYDBO | PRICE |
SOURCE_FIELD_NAME
CHAR(30)
EagleML/referenceTransaction/issuePrice/sourceFieldName
PAY_LEG_PRICE_OR_MV | NUMBER(38,12) | ../price |
marketValue | Optional | decimal |
7680 | in_ |
pay_leg_price_or_mv | I | SECURITYDBO | PRICE |
SOURCE_LEVEL
NUMBER
EagleML/referenceTransaction/issuePrice/sourceLevel
sourceSrcIntfcName
Optional
string
5613
in_source_src_intfc_name
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) |
EagleML/referenceTransaction/issuePrice/sourceSrcIntfcName
../notionalAmount | |
price | Optional |
decimal |
7681 | in_ |
rec_leg_ |
price_ |
or_ |
mv | I | SECURITYDBO | PRICE |
REC_LEG_ |
PRICE_ |
OR_ |
MV | NUMBER(38,12) |
EagleML/referenceTransaction/issuePrice/sourceSrcIntfcInst
../price | |
marketValue | Optional |
decimal |
7681 | in |
_rec_leg_price_or_mv | I | SECURITYDBO | PRICE | REC_LEG_PRICE_ |
OR_MV |
NUMBER( |
38,12) |
../marketValue |