Factor Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/objectType | ||
objectId | Optional | ObjectId |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/objectId | ||
objectDescription | Optional | FeedTypeEnum |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/objectDescription | ||
updateTimestamp | Optional | dateTime |
|
|
| SECURITYDBO | FACTOR | UPDATE_DATE | DATE | EagleML/accountingTransaction/factor/updateTimestamp |
customElements | Not recommended | CustomElements | CustomElements reserved for customizations | EagleML/accountingTransaction/factor/customElements | ||||||
sourceName | Optional | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR (15) | EagleML/accountingTransaction/factor/sourceName |
updateSource | Optional | string | 944 | in_update_source | S | SECURITYDBO | FACTOR | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/factor/updateSource |
effectiveDate | Optional | date | 1109 | in_effective_date | S | SECURITYDBO | FACTOR | EFFECTIVE_DATE | DATE | EagleML/accountingTransaction/factor/effectiveDate |
languageId | Optional | integer |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/languageId | ||
tagNochangecase | Optional | string |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/tagNochangecase | ||
preserveNull | Optional | string |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/preserveNull | ||
noLoadValidationFlag | Optional | YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/noLoadValidationFlag | ||
accountingValidationFlag | Optional | YesNoOptionEnum |
|
|
| not stored in DB |
| EagleML/accountingTransaction/factor/accountingValidationFlag | ||
EagleML/accountingTransaction/factor/ | ||||||||||
paymentDate | Optional | date | 1119 | in_payment_date | S | SECURITYDBO | FACTOR | PAYMENT_DATE | DATE | EagleML/accountingTransaction/factor/paymentDate |
factor | Optional | decimal | 91 | in_factor | F | SECURITYDBO | FACTOR | FACTOR | NUMBER(28,12) | EagleML/accountingTransaction/factor/factor |
factorSource | Optional | string | 3636 | in_factor_source | S | SECURITYDBO | FACTOR | FACTOR_SOURCE | CHAR(4) | EagleML/accountingTransaction/factor/factorSource |
status | Optional | string | 54 | in_factor_status | S | SECURITYDBO | FACTOR | FACTOR_STATUS | CHAR(1) | EagleML/accountingTransaction/factor/status |
paymentRate | extract only | decimal | 1118 | in_payment_rate | F | SECURITYDBO | FACTOR | PAYMENT_RATE | NUMBER(28,12) | EagleML/accountingTransaction/factor/paymentRate |
princpalPayment | extract only | decimal | 1116 | in_princpal_payment | F | SECURITYDBO | FACTOR | PRINCPAL_PAYMENT | NUMBER(28,12) | EagleML/accountingTransaction/factor/princpalPayment |
interestPayment | extract only | decimal | 1117 | in_interest_payment | F | SECURITYDBO | FACTOR | INTEREST_PAYMENT | NUMBER(28,12) | EagleML/accountingTransaction/factor/interestPayment |
cmoSeriesNumber | extract only | integer | 10430 | in_cmo_series_number | I | SECURITYDBO | FACTOR | CMO_SERIES_NUMBER | NUMBER | EagleML/accountingTransaction/factor/cmoSeriesNumber |