...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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_ |
px_ |
dirty |
I | SECURITYDBO | PRICE |
PX_ |
DIRTY |
NUMBER( |
38,12) | EagleML/referenceTransaction/issuePrice/ |
priceTypeCode
Optional
normalizedString
1843
in_price_type_code
S
SECURITYDBO
PRICE
PRICE_TYPE_CODE
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( |
EagleML/referenceTransaction/issuePrice/priceSource
priceTolerance
Optional
decimal
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 |
PX_DIRTY_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 |
FAIR_VALUE_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 |
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/ |
basis
Optional
decimal
5581
in_basis
I
SECURITYDBO
PRICE
BASIS
NUMBER(28,12)
EagleML/referenceTransaction/issuePrice/basis
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 |
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 |
SOURCE_ |
LEVEL | NUMBER | EagleML/referenceTransaction/issuePrice/ |
sourceLevel |
sourceSrcIntfcName | Optional | string |
5613 | in_source_src_ |
intfc_ |
name | S | SECURITYDBO | PRICE |
STKSPLT_FLAG
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 |
USER_NAV5
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 |
SOURCE_SRC_INTFC_NAME
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 |
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 |