...
Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | Star Tag | DB Field TypeSP Parameter | Xpath | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | OptionalObjectTypeEnum | not store stored in DB | EagleML/referenceTransaction/securityNotes/objectType | ||||||||||||
| objectId | OptionalObjectId | not store stored in DB | EagleML/referenceTransaction/securityNotes/objectId | ||||||||||||
| objectDescription | Optional | FeedTypeEnum | not store stored in DB | EagleML/referenceTransaction/securityNotes/objectDescription | |||||||||||
| updateTimestamp | Optional | dateTime | pacePACE_masterdboMASTERDBO | secSEC_notesNOTES | upddate | UPDDATE | DATE | EagleML/referenceTransaction/securityNotes/updateTimestamp | |||||||
| customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/securityNotes/customElements | |||||||||||
| sourceName | Optionalstring - used in resolution logic | PACE_MASTERDBO | INTERFACES | shortSHORT_descDESC | CHAR(15) | EagleML/referenceTransaction/securityNotes/sourceName | |||||||||
| updateSource | Optionalstringstring | 944 | pacein_update_ | masterdbouser | secPACE_notesMASTERDBO | upduserSEC_NOTES | 944UPDUSER | VARCHAR2(100) | in_update_user | EagleML/referenceTransaction/securityNotes/updateSource | |||||
| effectiveDate | Optionaldate | 1109 | DATE | EagleML/referenceTransaction/securityNotes/effectiveDate | |||||||||||
| languageId | Optional | integer | not store stored in DB | EagleML/referenceTransaction/securityNotes/languageId | |||||||||||
| tagNochangecase | Optional | string | not store stored in DB | EagleML/referenceTransaction/securityNotes/tagNochangecase | |||||||||||
| preserveNull | Optionalstring | not store stored in DB | EagleML/referenceTransaction/securityNotes/preserveNull | ||||||||||||
| noLoadValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/preserveNullnoLoadValidationFlagOptional | ||||||||||||
| accountingValidationFlag | YesNoOptionEnum | not store stored in DB | EagleML/referenceTransaction/securityNotes/accountingValidationFlag | ||||||||||||
| skipIfExistFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/ | noLoadValidationFlagskipIfExistFlag | |||||||||||
| Asset Identifiers Model (see extra table) | EagleML/referenceTransaction/securityNotes/ | ||||||||||||||
| NoteModel | NoteModel - Complex type (see extra table below) | EagleML/referenceTransaction/securityNotes/NoteModel/ | |||||||||||||
| |||||||||||||||
| updateDate | OptionalRequired | date | 1452 | pacein_ | masterdboupddate | secPACE_notesMASTERDBO | upddateSEC_NOTES | 1452UPDDATE | DATEin_upddate | EagleML/referenceTransaction/securityNotes/NoteModel/updateDate | |||||
| notes | Optionalstringstring | 3461 | pacein_ | masterdbonotes | secPACE_notesMASTERDBOnotes | SEC_NOTES | 3461NOTES | VARCHAR2(1000) | in_notes | EagleML/referenceTransaction/securityNotes/NoteModel/notes | |||||
| noteType | Optionalstringstring | 2097 | pacein_note_ | masterdbotype | secPACE_notesMASTERDBO | noteSEC_typeNOTES | 2097NOTE_TYPE | VARCHAR2(25) | in_note_type | EagleML/referenceTransaction/securityNotes/NoteModel/noteType | |||||
| updateUser | Required | string | 944 | pacein_update_ | masterdbouser | secPACE_notesMASTERDBO | upduserSEC_NOTES | 944UPDUSER | VARCHAR2(100) | EagleML/referenceTransaction/securityNotes/NoteModel/updateUser | |||||
| noteIndicator | string | 2095 | in | ||||||||||||
| _note_indicator | PACE_MASTERDBO | SEC_NOTES | NOTE_INDICATOR | CHAR(2) | EagleML/referenceTransaction/securityNotes/NoteModel/ | ||||||||||
| noteIndicatorOptional | |||||||||||||||
| noteCharKey | string | pace_masterdbo | sec_notes | note_indicator | 2095 | CHAR(2) | in_note_indicator3462 | in_note_char_key | PACE_MASTERDBO | SEC_NOTES | NOTE_CHAR_KEY | CHAR(12) | EagleML/referenceTransaction/securityNotes/NoteModel/noteCharKey | ||
| shareProperty | string | 1147 | in_share_property | PACE_MASTERDBO | SEC_NOTES | SHARE_PROPERTY | NUMBER | EagleML/referenceTransaction/securityNotes/NoteModel/shareProperty | |||||||
| privateNote | string | 1256 | in_private_note | PACE_MASTERDBO | SEC_NOTES | PRIVATE_NOTE | CHAR(1) | EagleML/referenceTransaction/securityNotes/NoteModel/ | noteIndicator|||||||
...
| privateNote |