Element | Optional/Required | Value Type |
|---|
Star Tag | SP Parameter | SP Type | Eagle DB |
|---|
DB Table | DB Field |
|---|
DB Field Type | XPath |
|---|---|
objectType |
ObjectTypeEnum |
not stored in DB | EagleML/referenceTransaction/ | |||||||
underlyingSMF/objectType | ||
objectId | ObjectId |
not stored in DB | EagleML/referenceTransaction/ | ||||||
underlyingSMF/objectId | ||
objectDescription | FeedTypeEnum |
not stored in DB | EagleML/referenceTransaction/underlyingSMF/objectDescription | |||||||||
updateTimestamp | dateTime | not stored in DB | EagleML/referenceTransaction/ | |||||||
underlyingSMF/updateTimestamp | ||||||||||
customElements | Not recommended | CustomElements | CustomElements - reserved for customizations | |||||||
sourceName | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/ |
underlyingSMF/ |
sourceName |
updateSource |
string |
944 | in_ird_update_source | S | SECURITYDBO |
UNDERLYING_ |
SECURITY |
UPDATE_ |
SOURCE |
VARCHAR2( |
255) | EagleML/referenceTransaction/underlyingSMF/updateSource | |||||||||
languageId | integer | not stored in DB | EagleML/referenceTransaction/ | |||||||
underlyingSMF/languageId | ||||||||||
tagNochangecase | string | not stored in DB | EagleML/referenceTransaction/underlyingSMF/tagNochangecase | |||||||
preserveNull | string | not stored in DB | EagleML/referenceTransaction/underlyingSMF/preserveNull | |||||||
noLoadValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/underlyingSMF/noLoadValidationFlag | |||||||
spokeCheckFlag | integer | not stored in DB | EagleML/referenceTransaction/underlyingSMF/spokeCheckFlag | |||||||
skipIfExistFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/underlyingSMF/skipIfExistFlag | |||||||
underlyingDeleteReinsertSwitch | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/underlyingSMF/underlyingDeleteReinsertSwitch | |||||||
underlyingAutoEnrichDataSwitch | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/underlyingSMF/underlyingAutoEnrichDataSwitch | |||||||
underlyingRetainBeginDateSwitch | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/underlyingSMF/underlyingRetainBeginDateSwitch | |||||||
investmentType | StringWithCodeScheme | 11 | in_investment_type | S | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | CHAR(4) | EagleML/referenceTransaction/ | |
underlyingSMF/ |
investmentType |
processingSecurityType |
StringWithCodeScheme |
3931 | in_process_sec_type | S | SECURITYDBO |
SECURITY_ |
MASTER |
PROCESS_SEC_TYPE | VARCHAR2(15) | EagleML/referenceTransaction/underlyingSMF/processingSecurityType | ||||||||
underlyingAsset | UnderlyingAssetIdentifiersModel | EagleML/referenceTransaction/underlyingSMF/underlyingAsset/ | ||||||||
underlyingRate | decimal | 3611 | in_underlying_rate | F | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_RATE | NUMBER(28,12) | EagleML/referenceTransaction/underlyingSMF/underlyingRate | |
underlyingPrice | decimal | 3612 | in_underlying_price | F | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/underlyingSMF/underlyingPrice | |
underlyingSecurityIncomeProcessingFlag | string | 9712 | in_stream_flag | S | SECURITYDBO | UNDERLYING_SECURITY | STREAM_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/underlyingSMF/underlyingSecurityIncomeProcessingFlag | |
baseContractXreferenceIdAndType | AssetIdAndAssetIdType | EagleML/referenceTransaction/underlyingSMF/baseContractXreferenceIdAndType/ | ||||||||
nonFundedIndicator | string | 905 | in_non_fund_flag | S | SECURITYDBO | UNDERLYING_SECURITY | NON_FUND_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/underlyingSMF/nonFundedIndicator | |
securityGlobalAmount | decimal | 909 | in_security_amount | I | SECURITYDBO | UNDERLYING_SECURITY | SECURITY_AMOUNT | NUMBER(38,12) | EagleML/referenceTransaction/underlyingSMF/securityGlobalAmount | |
underlyingSecurityAmount | decimal | 911 | in_underlying_amount | I | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_AMOUNT | NUMBER(38,12) | EagleML/referenceTransaction/underlyingSMF/underlyingSecurityAmount | |
underlyingPercentage | decimal | 912 | in_underlying_pct | I | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_PCT | NUMBER(38,12) | EagleML/referenceTransaction/underlyingSMF/underlyingPercentage | |
underlyingType | string | 916 | in_underlying_type | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_TYPE | VARCHAR2(100) | EagleML/referenceTransaction/underlyingSMF/underlyingType | |
reasonDescription | string | 56 | in_reason | S | SECURITYDBO | UNDERLYING_SECURITY | REASON | EagleML/referenceTransaction/underlyingSMF/reasonDescription | ||
underlyingChar1 | string | 3613 | in_underlying_char1 | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/underlyingSMF/underlyingChar1 | |
underlyingChar2 | string | 3614 | in_underlying_char2 | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/underlyingSMF/underlyingChar2 | |
underlyingChar3 | string | 3615 | in_underlying_char3 | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/underlyingSMF/underlyingChar3 | |
underlyingFloat1 | decimal | 3616 | in_underlying_float1 | F | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/underlyingSMF/underlyingFloat1 | |
underlyingFloat2 | decimal | 3617 | in_underlying_float2 | F | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/underlyingSMF/underlyingFloat2 | |
underlyingFloat3 | decimal | 3618 | in_underlying_float3 | F | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/ | |
underlyingSMF/underlyingFloat3 | ||||||||||
underlyingDate1 | date | 3619 | in_underlying_date1 | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_DATE1 | DATE | EagleML/referenceTransaction/underlyingSMF/underlyingDate1 | |
underlyingDate2 | date | 3620 | in_underlying_date2 | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_DATE2 | DATE | EagleML/referenceTransaction/underlyingSMF/underlyingDate2 | |
underlyingDate3 | date | 3621 | in_underlying_date3 | S | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_DATE3 | DATE | EagleML/referenceTransaction/underlyingSMF/underlyingDate3 | |
beginDate | Required | date | 71 | in_begin_date | S | SECURITYDBO | UNDERLYING_SECURITY | BEGIN_DATE | DATE | EagleML/referenceTransaction/underlyingSMF/beginDate |
endDate | date | 73 | in_end_date | S | SECURITYDBO | UNDERLYING_SECURITY | END_DATE | DATE | EagleML/referenceTransaction/underlyingSMF/endDate |