Underlying SMF Data Map Table
- Anna Krapivina
- Kinga Huszno
- Aleksei Barich
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 |