Versions Compared

Old Version 1

changes.mady.by.user Anna Krapivina

Saved on

compared with

New Version 2

changes.mady.by.user Anna Krapivina

Saved on

Key

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


DB TableData --1163brokerRate/entityIdENTRYbrokerRateentryTypeassetCurrencyBROKERRATESSPOT_RATEbrokerRate/spotRate

Element

Optional/Required

Value Type

STAR Tag

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/

brokerRate

UnderlyingSMF/objectType

objectId


ObjectId

-




not stored in DB


EagleML/referenceTransaction/

brokerRate

UnderlyingSMF/objectId

objectDescription


FeedTypeEnum




not stored in DB


EagleML/referenceTransaction/UnderlyingSMF/objectDescription

updateTimestamp


dateTime




not stored in DB


EagleML/referenceTransaction/

brokerRate/objectDescription		effectiveDateRequireddate1109SECURITYDBOBROKER_RATESEFFECTIVE_DATEDATE

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/

brokerRate

UnderlyingSMF/

effectiveDate

sourceName

updateSource


entityId

string

Requiredstring

944

in_ird_update_source

S

SECURITYDBO

BROKER

UNDERLYING_

RATES

SECURITY

ENTITY

UPDATE_

ID

SOURCE

CHAR

VARCHAR2(

8)

255)

EagleML/referenceTransaction/UnderlyingSMF/updateSource

languageId
integer


not stored in DB
EagleML/referenceTransaction/entryTypeRequiredstring1882SECURITYDBOBROKER_RATESUnderlyingSMF/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
Asset Identifiers Model









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
StringWithCodeScheme11in_investment_typeS

SECURITYDBO

SECURITY_MASTERINVESTMENT_TYPECHAR(4)EagleML/referenceTransaction/UnderlyingSMF/investmentType
processingSecurityType
StringWithCodeSchemeRequiredstring3633931in_process_sec_typeSSECURITYDBOSECURITY_MASTERFROM_SEC_ALIASNUMBEREagleML/referenceTransaction/brokerRate/fromCurrency/assetCurrency
assetCurrencyRequiredstring313SECURITYDBOBROKER_RATESTO_SEC_ALIASNUMBEREagleML/referenceTransaction/brokerRate/toCurrency/assetCurrency
brokerCodeRequiredstring1237SECURITYDBOBROKER_RATESBROKER_CODEVARCHAR2(20)EagleML/referenceTransaction/brokerRate/brokerCode
spotRateRequireddecimal96SECURITYDBOBROKER_RATESPROCESS_SEC_TYPEVARCHAR2(15)EagleML/referenceTransaction/UnderlyingSMF/processingSecurityType
underlyingAsset
UnderlyingAssetIdentifiersModelAsset Identifiers ModelEagleML/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

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