Forward Points Data Map Table


Element

Optional/Required

Value Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

Xpath

objectType

Optional

ObjectTypeEnum

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/objectType

objectId

Optional

ObjectId

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/objectId

objectDescription

Optional

FeedTypeEnum

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/objectDescription

updateTimestamp

Optional

dateTime

 

 

 

 

DATE

EagleML/referenceTransaction/forwardPoints/updateTimestamp

customElements

Not recommended

CustomElements - Complex type

reserved for customizations

EagleML/referenceTransaction/forwardPoints/customElements

sourceName

Optional

string - used for resolution logics

1102

PACE_MASTERDBO

INTERFACES

short_desc

CHAR(15)

EagleML/referenceTransaction/forwardPoints/sourceName

updateSource

Optional

string

944

 

 

 

CHAR(8)

EagleML/referenceTransaction/forwardPoints/updateSource

effectiveDate

Optional

date

1109

 

 

 

DATE

EagleML/referenceTransaction/forwardPoints/effectiveDate

languageId

Optional

integer

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/languageId

tagNochangecase

Optional

string

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/tagNochangecase

preserveNull

Optional

string

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

 

not stored in DB

 

EagleML/referenceTransaction/forwardPoints/noLoadValidationFlag

Asset Identifiers Model

EagleML/referenceTransaction/forwardPoints/

fromAsset

Asset Identifiers Model

EagleML/referenceTransaction/forwardPoints/fromAsset/

period

Optional

decimal

8568

SECURITYDBO

FORWARD_POINTS

PERIOD

NUMBER

EagleML/referenceTransaction/forwardPoints/period

points

Optional

decimal

8571

SECURITYDBO

FORWARD_POINTS

POINTS

NUMBER(28,12)

EagleML/referenceTransaction/forwardPoints/points

fpRateCondition

Optional

string

8572

SECURITYDBO

FORWARD_POINTS

RATE_CONDITION

VARCHAR2(20)

EagleML/referenceTransaction/forwardPoints/fpRateCondition

origRateType

Optional

string

8573

SECURITYDBO

FORWARD_POINTS

ORIG_RATE_TYPE

NUMBER

EagleML/referenceTransaction/forwardPoints/origRateType

bestRateStatus

Optional

decimal

8574

SECURITYDBO

FORWARD_POINTS

BEST_RATE_STATUS

NUMBER

EagleML/referenceTransaction/forwardPoints/bestRateStatus

origSpotSrc

Optional

integer

8976

SECURITYDBO

FORWARD_POINTS

ORIG_SPOT_SRC

NUMBER

EagleML/referenceTransaction/forwardPoints/origSpotSrc

origPointSrc

Optional

integer

9458

SECURITYDBO

FORWARD_POINTS

ORIG_POINT_SRC

NUMBER

EagleML/referenceTransaction/forwardPoints/origPointSrc

sourceVendorDate

Optional

date

9454

SECURITYDBO

FORWARD_POINTS

SOURCE_VENDOR_DATE

DATE

EagleML/referenceTransaction/forwardPoints/sourceVendorDate

sourceVendorTime

Optional

string

9455

SECURITYDBO

FORWARD_POINTS

SOURCE_VENDOR_TIME

CHAR(8)

EagleML/referenceTransaction/forwardPoints/sourceVendorTime

sourceEffectiveDate

Optional

date

9457

SECURITYDBO

FORWARD_POINTS

SOURCE_EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/forwardPoints/sourceEffectiveDate

overrideFlag

Optional

YesNoOptionEnum

9383

SECURITYDBO

FORWARD_POINTS

OVERRIDE_FLAG

VARCHAR2(2)

EagleML/referenceTransaction/forwardPoints/overrideFlag

reworkFlag

Optional

YesNoOptionEnum

 

SECURITYDBO

FORWARD_POINTS

REWORK_FLAG

CHAR(2)

EagleML/referenceTransaction/forwardPoints/reworkFlag