Issue PC Price Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Larry Ackerman
- Dmitry Donosiyan (Unlicensed)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Required |
| ObjectTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/objectType | ||
objectId |
|
| ObjectId |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/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 |
effectiveDate | Required |
| date | 1109 | in_effective_date | S | SECURITYDBO | PRICE_EXCHANGE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issuePcPrice/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 | NUMBER(28,12) | EagleML/referenceTransaction/issuePcPrice/lastPrice |
lastPriceCondition |
|
| string | 7015 |
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/lastPriceCondition | ||
askPrice |
|
| decimal | 7721 | in_current_value | F | SECURITYDBO | PRICE_EXCHANGE | PX_ASK | NUMBER(28,12) | EagleML/referenceTransaction/issuePcPrice/askPrice |
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 |
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) | 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) | 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 | VARCHAR2(20) | EagleML/referenceTransaction/issuePcPrice/unitsCondition |
fairValueFactor |
|
| decimal | 10813 | in_current_value | F | SECURITYDBO | PRICE_EXCHANGE | FAIR_VALUE_FACTOR | 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 | ||
dirtyPrice |
|
| decimal | 7727 | in_px_dirty | F | not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/dirtyPrice | ||
dirtyPriceCondition |
|
| string | 7050 |
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/dirtyPriceCondition | ||
openPrice |
|
| decimal | 7726 | in_px_open | F | not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/openPrice | ||
openPriceCondition |
|
| string | 7046 |
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/openPriceCondition | ||
originalVendorSource |
|
| string | 7050 |
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/originalVendorSource | ||
commentsOverrideFlag |
|
| string | 1257 |
|
| not stored in DB |
| EagleML/referenceTransaction/issuePcPrice/commentsOverrideFlag | ||
useRdcPricing |
|
| string |
|
|
| Toggles RDC load mode if set to Y |
| EagleML/referenceTransaction/issuePcPrice/useRdcPricing | ||
extendedUpdate |
|
| string | 7105 | in_extended_update |
| When the price is the same as the current value in the system and the extendedUpdate is set to Y, the price load will update the record for the following elements: |
| EagleML/referenceTransaction/issuePcPrice/extendedUpdate | ||