...
Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB FieldStar Tag | DB Field Type | SP Parameter | Xpath | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Optional | ObjectTypeEnum | not store stored in DB | EagleML/referenceTransaction/securityNotes/objectType | |||||||||||
| objectId | OptionalObjectId | not store stored in DB | EagleML/referenceTransaction/securityNotes/objectId | ||||||||||||
| objectDescription | OptionalFeedTypeEnum | not store stored in DB | EagleML/referenceTransaction/securityNotes/objectDescription | ||||||||||||
| updateTimestamp | Optional | dateTime | pacePACE_masterdboMASTERDBO | secSEC_notesNOTES | upddate | DATE | EagleML/referenceTransaction/securityNotes/updateTimestamp | ||||||||
| customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/securityNotes/customElements | |||||||||||
| sourceName | Optional | string - used in resolution logic | PACE_MASTERDBO | INTERFACES | short_desc | CHAR(15) | EagleML/referenceTransaction/securityNotes/sourceName | ||||||||
| updateSource | Optional | string | pace_masterdbo | sec_notesstring | 944 | in_update_user | PACE_MASTERDBO | SEC_NOTES | upduser | 944 | VARCHAR2(100)in_update_user | EagleML/referenceTransaction/securityNotes/updateSource | |||
| effectiveDate | Optionaldate | 1109 | DATE | EagleML/referenceTransaction/securityNotes/effectiveDate | |||||||||||
| languageId | Optionalinteger | not store stored in DB | EagleML/referenceTransaction/securityNotes/languageId | ||||||||||||
| tagNochangecase | Optionalstring | not store stored in DB | EagleML/referenceTransaction/securityNotes/tagNochangecase | ||||||||||||
| preserveNull | Optional | string | not store stored in DB | EagleML/referenceTransaction/securityNotes/preserveNull | |||||||||||
| noLoadValidationFlag | Optional | YesNoOptionEnum | not store stored in DB | EagleML/referenceTransaction/securityNotes/noLoadValidationFlag | |||||||||||
| Asset Identifiers Model | EagleML/referenceTransaction/securityNotes/ | ||||||||||||||
| NoteModel | NoteModel - Complex type (see extra table below) | EagleML/referenceTransaction/securityNotes/NoteModel/ | |||||||||||||
| |||||||||||||||
| updateDate | dateOptional | 1452 | datein_upddate | pacePACE_masterdboMASTERDBO | secSEC_notesNOTES | upddate | 1452 | DATEin_upddate | EagleML/referenceTransaction/securityNotes/NoteModel/updateDate | ||||||
| notes | Optional | string | pace_masterdbo | sec_notes | notes | 3461string | 3461 | in_notes | PACE_MASTERDBO | SEC_NOTES | notes | VARCHAR2(1000)in_notes | EagleML/referenceTransaction/securityNotes/NoteModel/notes | ||
| noteType | string | Optional | string | pace_masterdbo | sec_notes2097 | in_note_type | PACE_MASTERDBO | SEC_NOTES | note_type | 2097VARCHAR2(25)in_note_type | EagleML/referenceTransaction/securityNotes/NoteModel/noteType | ||||
| updateUser | Required | string | pace_masterdbo | sec_notes | upduser | 944944 | in_update_user | PACE_MASTERDBO | SEC_NOTES | upduser | VARCHAR2(100)in_update_user | EagleML/referenceTransaction/securityNotes/NoteModel/updateUser | |||
| noteIndicator | Optionalstringstring | 2095 | pacein_note_ | masterdboindicator | secPACE_notesMASTERDBO | noteSEC_indicatorNOTES | 2095NOTE_INDICATOR | CHAR(2) | EagleML/referenceTransaction/securityNotes/NoteModel/noteIndicator | ||||||
| noteCharKey | string | 3462 | in_note | _indicator_char_key | PACE_MASTERDBO | SEC_NOTES | NOTE_CHAR_KEY | EagleML/referenceTransaction/securityNotes/NoteModel/noteCharKey | |||||||
| shareProperty | string | 1147 | in_share_property | PACE_MASTERDBO | SEC_NOTES | SHARE_PROPERTY | EagleML/referenceTransaction/securityNotes/NoteModel/ | noteIndicator||||||||
...
| shareProperty | |||||||||
| privateNote | string | 1256 | in_private_note | PACE_MASTERDBO | SEC_NOTES | PRIVATE_NOTE | EagleML/referenceTransaction/securityNotes/NoteModel/privateNote |