Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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

Xpath

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/

issuePcPrice

brokerRate/objectType

objectId

ObjectId

-

not stored in DB

EagleML/referenceTransaction/

issuePcPrice

brokerRate/objectId

objectDescription

FeedTypeEnum

-

not stored in DB

EagleML/referenceTransaction/

issuePcPrice/objectDescription

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

in_effective_date

S

SECURITYDBO

PRICE

BROKER_

EXCHANGE

RATES

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/

issuePcPriceNUMBER(28,12

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

Asset Identifiers Model

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/

issuePcPrice

brokerRate/

lastPrice

entityId

entryType

lastPriceConditionNUMBER(28,12

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/

issuePcPrice

brokerRate/

askPrice

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

NUMBER(28,12)

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/

issuePcPrice/midPrice

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

NUMBER(28,12)

brokerRate/fromCurrency/assetCurrency

assetCurrency

Required

string

313

SECURITYDBO

BROKER_RATES

TO_SEC_ALIAS

NUMBER

EagleML/referenceTransaction/

issuePcPrice/priceTypeCode

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

PRICE_CONDITION

brokerRate/toCurrency/assetCurrency

brokerCode

Required

string

1237

SECURITYDBO

BROKER_RATES

BROKER_CODE

VARCHAR2(20)

EagleML/referenceTransaction/

issuePcPrice

brokerRate/

unitsCondition

brokerCode

spotRate

fairValueFactorF

Required

decimal

10813

in_current_value

96

SECURITYDBO

PRICE

BROKER_

EXCHANGE

RATES

FAIR

SPOT_

VALUE_FACTOR

RATE

NUMBER(28,12)

EagleML/referenceTransaction/

issuePcPrice/fairValueFactor

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

dirtyPricedecimal7727in_px_dirtyFnot stored in DB EagleML/referenceTransaction/issuePcPrice/dirtyPricedirtyPriceConditionstring7050not stored in DB EagleML/referenceTransaction/issuePcPrice/dirtyPriceConditionopenPricedecimal7726in_px_openFnot stored in DB EagleML/referenceTransaction/issuePcPrice/openPriceopenPriceConditionstring7046not stored in DB EagleML/referenceTransaction/issuePcPrice/openPriceConditionoriginalVendorSourcestring7050not stored in DB EagleML/referenceTransaction/issuePcPrice/originalVendorSourcecommentsOverrideFlagstring1257 not stored in DB EagleML/referenceTransaction/issuePcPrice/commentsOverrideFlaguseRdcPricingstringToggles RDC load mode if set to YEagleML/referenceTransaction/issuePcPrice/useRdcPricing

brokerRate/spotRate