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 |
Â