Element
Required Inbound Acct Validation
Required Inbound Data Mgt
Value Type
Star Tag
SP Parameter
SP Type
Eagle DB
DB Table
DB Field
DB Field Type
Element | Optional/Required | Value Type | STAR Tag | Eagle DB | DB Table | DB Field | Data Type | XPath |
---|---|---|---|---|---|---|---|---|
objectType | Required | ObjectTypeEnum | - | not stored in DB | EagleML/referenceTransaction/ |
brokerRate/objectType | ||||||||
objectId | ObjectId | - | not stored in DB | EagleML/referenceTransaction/ |
brokerRate/objectId | ||||||||
objectDescription | FeedTypeEnum | - | not stored in DB | EagleML/referenceTransaction/ |
updateTimestamp
dateTime
not stored in DB
EagleML/referenceTransaction/issuePcPrice/updateTimestamp
customElements
Not recommended
CustomElements - reserved for customizations
EagleML/referenceTransaction/issuePcPrice/customElements
sourceName
Required
string
1102
PACE_MASTERDBO
INTERFACES
SHORT_DESC
EagleML/referenceTransaction/issuePcPrice/sourceName
updateSource
string
944
in_update_user
S
SECURITYDBO
PRICE_EXCHANGE
UPDATE_SOURCE
CHAR(255)
EagleML/referenceTransaction/issuePcPrice/updateSource
brokerRate/objectDescription | |||
effectiveDate | Required | date | 1109 |
S
SECURITYDBO |
BROKER_ |
RATES | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/ |
brokerRate/effectiveDate |
languageId
integer
not stored in DB
EagleML/referenceTransaction/issuePcPrice/languageId
tagNochangecase
string
not stored in DB
EagleML/referenceTransaction/issuePcPrice/tagNochangecase
preserveNull
string
not stored in DB
EagleML/referenceTransaction/issuePcPrice/preserveNull
noLoadValidationFlag
YesNoOptionEnum
not stored in DB
EagleML/referenceTransaction/issuePcPrice/noLoadValidationFlag
accountingValidationFlag
YesNoOptionEnum
not stored in DB
EagleML/referenceTransaction/issuePcPrice/accountingValidationFlag
EagleML/referenceTransaction/issuePcPrice/
priceExchangeCode
string
9036
not stored in DB
EagleML/referenceTransaction/issuePcPrice/priceExchangeCode
allowPastRate
YesNoOptionEnum
7001
not stored in DB
EagleML/referenceTransaction/issuePcPrice/allowPastRate
bloombergError
string
7740
not stored in DB
EagleML/referenceTransaction/issuePcPrice/bloombergError
excludePriceDemandFlag
YesNoOptionEnum
1256
not stored in DB, used for resolution logic
EagleML/referenceTransaction/issuePcPrice/excludePriceDemandFlag
sourceDescription
string
1103
not stored in DB
EagleML/referenceTransaction/issuePcPrice/sourceDescription
sourceComments
string
5669
not stored in DB
EagleML/referenceTransaction/issuePcPrice/sourceComments
priceCondition
string
4849
not stored in DB
EagleML/referenceTransaction/issuePcPrice/priceCondition
priceVolume
decimal
1851
not stored in DB
EagleML/referenceTransaction/issuePcPrice/priceVolume
newsIndicator
string
9452
not stored in DB, used for resolution logic
EagleML/referenceTransaction/issuePcPrice/newsIndicator
currencyLastCharacter
string
7060
not stored in DB
EagleML/referenceTransaction/issuePcPrice/currencyLastCharacter
askPriceFlag
YesNoOptionEnum
7040
not stored in DB
EagleML/referenceTransaction/issuePcPrice/askPriceFlag
bidPriceFlag
YesNoOptionEnum
7041
not stored in DB
EagleML/referenceTransaction/issuePcPrice/bidPriceFlag
priceFlag
YesNoOptionEnum
7042
not stored in DB
EagleML/referenceTransaction/issuePcPrice/priceFlag
lastPriceFlag
YesNoOptionEnum
7044
not stored in DB
EagleML/referenceTransaction/issuePcPrice/lastPriceFlag
midPriceFlag
YesNoOptionEnum
7045
not stored in DB
EagleML/referenceTransaction/issuePcPrice/midPriceFlag
pXQuoteLotSize
decimal
7960
not stored in DB, used for resolution logic
EagleML/referenceTransaction/issuePcPrice/pXQuoteLotSize
lastPrice
decimal
7724
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
PX_LAST
entityId | Required | string | 1163 | SECURITYDBO | BROKER_RATES | ENTITY_ID | CHAR(8) | EagleML/referenceTransaction/ |
brokerRate/ |
entityId |
entryType |
Required | string |
7015
not stored in DB
EagleML/referenceTransaction/issuePcPrice/lastPriceCondition
askPrice
decimal
7721
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
PX_ASK
1882 | SECURITYDBO | BROKER_RATES | ENTRY_TYPE | CHAR(4) | EagleML/referenceTransaction/ |
brokerRate/ |
bidPriceCondition
string
7017
not stored in DB
EagleML/referenceTransaction/issuePcPrice/bidPriceCondition
price
decimal
7723
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
PRICE
NUMBER(28,12)
EagleML/referenceTransaction/issuePcPrice/price
pricePriceCondition
string
7018
not stored in DB
EagleML/referenceTransaction/issuePcPrice/pricePriceCondition
midPrice
decimal
7725
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
PX_MID
entryType |
askPriceCondition
string
7016
not stored in DB
EagleML/referenceTransaction/issuePcPrice/askPriceCondition
bidPrice
decimal
7722
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
PX_BID
NUMBER(28,12)
EagleML/referenceTransaction/issuePcPrice/bidPrice
assetCurrency | Required | string | 363 | SECURITYDBO | BROKER_RATES | FROM_SEC_ALIAS | NUMBER | EagleML/referenceTransaction/ |
midPriceCondition
string
7019
not stored in DB
EagleML/referenceTransaction/issuePcPrice/midPriceCondition
originalPrice
Price
decimal
893
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
ORIGINAL_PRICE
NUMBER(28,12)
EagleML/referenceTransaction/issuePcPrice/originalPrice
originalPriceCondition
string
7021
in_price_condition
S
SECURITYDBO
PRICE_EXCHANGE
PRICE_CONDITION
VARCHAR2(20)
EagleML/referenceTransaction/issuePcPrice/originalPriceCondition
priceTypeCode
PriceTypeCodeEnum
1843
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
PRICE_TYPE_CODE
brokerRate/fromCurrency/assetCurrency | ||||||||
assetCurrency | Required | string | 313 | SECURITYDBO | BROKER_RATES | TO_SEC_ALIAS | NUMBER | EagleML/referenceTransaction/ |
priceTypeCodeCondition
string
7022
in_price_condition
S
SECURITYDBO
PRICE_EXCHANGE
PRICE_CONDITION
VARCHAR2(20)
EagleML/referenceTransaction/issuePcPrice/priceTypeCodeCondition
units
decimal
40
in_current_value
F
SECURITYDBO
PRICE_EXCHANGE
UNITS
NUMBER(28,12)
EagleML/referenceTransaction/issuePcPrice/units
unitsCondition
string
7023
in_price_condition
S
SECURITYDBO
PRICE_EXCHANGE
brokerRate/toCurrency/assetCurrency | ||||||||
brokerCode | Required | string | 1237 | SECURITYDBO | BROKER_RATES | BROKER_CODE | VARCHAR2(20) | EagleML/referenceTransaction/ |
brokerRate/ |
brokerCode |
spotRate |
Required | decimal |
10813
in_current_value
96 | SECURITYDBO |
BROKER_ |
RATES |
SPOT_ |
RATE | NUMBER(28,12) | EagleML/referenceTransaction/ |
fairValueFactorCondition
string
7025
in_price_condition
S
SECURITYDBO
PRICE_EXCHANGE
PRICE_CONDITION
VARCHAR2(20)
EagleML/referenceTransaction/issuePcPrice/fairValueFactorCondition
lastUpdateDate
date
7652
not stored in DB
EagleML/referenceTransaction/issuePcPrice/lastUpdateDate
marketDate
date
9264
in_market_date
S
SECURITYDBO
PRICE_EXCHANGE
MARKET_DATE
DATE
EagleML/referenceTransaction/issuePcPrice/marketDate
useVendorReloadProcess
integer
9916
not stored in DB
EagleML/referenceTransaction/issuePcPrice/useVendorReloadProcess
confidenceInterval
decimal
10957
in_confidence_interval
F
SECURITYDBO
PRICE_EXCHANGE
CONFIDENCEINTERVAL
NUMBER(38,12)
EagleML/referenceTransaction/issuePcPrice/confidenceInterval
priceLevel
integer
12007
in_price_level
I
SECURITYDBO
PRICE_EXCHANGE
PRICE_LEVEL
NUMBER(38)
EagleML/referenceTransaction/issuePcPrice/priceLevel
finalValidationNumber
integer
4891
not stored in DB
EagleML/referenceTransaction/issuePcPrice/finalValidationNumber
brokerRate/spotRate |