Security Default Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
- Jawann Swislow
Element | Comments | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|
objectType |
| ObjectTypeEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/objectType | ||
objectId |
| ObjectId |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/objectId | ||
objectDescription |
| FeedTypeEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/objectDescription | ||
updateTimestamp |
| dateTime |
|
| SECURITYDBO | SECURITY_DEFAULT | UPDATE_DATE | DATE | EagleML/referenceTransaction/securityDefault/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type |
|
| reserved for customization |
| EagleML/referenceTransaction/securityDefault/customElements | ||
sourceName |
| string - needed for resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/securityDefault/sourceName |
updateSource | Required | string | 944 | in_update_source | SECURITYDBO | SECURITY_DEFAULT | UPDATE_SOURCE | VARCHAR2(32) | EagleML/referenceTransaction/securityDefault/updateSource |
effectiveDate |
| date |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/effectiveDate | ||
languageId |
| integer |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/languageId | ||
tagNochangecase |
| string |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/tagNochangecase | ||
preserveNull |
| string |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/preserveNull | ||
noLoadValidationFlag |
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/noLoadValidationFlag | ||
accountingValidationFlag |
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/accountingValidationFlag | ||
skipIfExistFlag |
| YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/securityDefault/skipIfExistFlag | ||
Security Ids are required |
| EagleML/referenceTransaction/securityDefault/ | |||||||
processingSecurityType |
| StringWithCodeScheme | 82 |
| SECURITYDBO | SECURITY_DEFAULT | SECURITY_TYPE | VARCHAR2(15) | EagleML/referenceTransaction/securityDefault/processingSecurityType |
costingRule | Required, but is auto-calculated based on security information | string |
|
| SECURITYDBO | SECURITY_DEFAULT | COSTING_RULE | VARCHAR2(12) | EagleML/referenceTransaction/securityDefault/costingRule |
beginDate | Required | date | 220/71 | in_begin_date | SECURITYDBO | SECURITY_DEFAULT | DEFAULT_BEGIN_DATE | DATE | EagleML/referenceTransaction/securityDefault/beginDate |
endDate | Should be greater than the incoming begin date | date | 221/73 | in_end_date | SECURITYDBO | SECURITY_DEFAULT | DEFAULT_END_DATE | DATE | EagleML/referenceTransaction/securityDefault/endDate |
defaultType | Required | string | 1551 |
| SECURITYDBO | SECURITY_DEFAULT | DEFAULT_TYPE | VARCHAR2(10) | EagleML/referenceTransaction/securityDefault/defaultType |
accountingBasis | Required | string | 21 |
| SECURITYDBO | SECURITY_DEFAULT | ACCT_BASIS | VARCHAR2(5) | EagleML/referenceTransaction/securityDefault/accountingBasis |
comments |
| string |
|
| SECURITYDBO | SECURITY_DEFAULT | COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/securityDefault/comments |