...
Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | ObjectTypeEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/objectType | ||||||||||||
objectId | ObjectId | not stored in DB | EagleML/referenceTransaction/securityNotes/objectId | ||||||||||||
objectDescription | FeedTypeEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/objectDescription | ||||||||||||
updateTimestamp | dateTime | PACE_MASTERDBO | SEC_NOTES | upddateUPDDATE | DATE | EagleML/referenceTransaction/securityNotes/updateTimestamp | |||||||||
customElements | Not recommended | CustomElements - Complex type | reserved for customizations | EagleML/referenceTransaction/securityNotes/customElements | |||||||||||
sourceName | string - used in resolution logic | PACE_MASTERDBO | INTERFACES | shortSHORT_descDESC | CHAR(15) | EagleML/referenceTransaction/securityNotes/sourceName | |||||||||
updateSource | string | 944 | in_update_user | PACE_MASTERDBO | SEC_NOTES | upduserUPDUSER | VARCHAR2(100) | EagleML/referenceTransaction/securityNotes/updateSource | |||||||
effectiveDate | date | 1109 | DATE | EagleML/referenceTransaction/securityNotes/effectiveDate | |||||||||||
languageId | integer | not stored in DB | EagleML/referenceTransaction/securityNotes/languageId | ||||||||||||
tagNochangecase | string | not stored in DB | EagleML/referenceTransaction/securityNotes/tagNochangecase | ||||||||||||
preserveNull | string | not stored in DB | EagleML/referenceTransaction/securityNotes/preserveNull | ||||||||||||
noLoadValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/noLoadValidationFlag | ||||||||||||
accountingValidationFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/accountingValidationFlag | ||||||||||||
skipIfExistFlag | YesNoOptionEnum | not stored in DB | EagleML/referenceTransaction/securityNotes/skipIfExistFlag | ||||||||||||
Asset Identifiers Model (see extra table) | EagleML/referenceTransaction/securityNotes/ | ||||||||||||||
NoteModel | NoteModel - Complex type (see extra table below) | EagleML/referenceTransaction/securityNotes/NoteModel/ | |||||||||||||
| |||||||||||||||
updateDate | Required | date | 1452 | in_upddate | PACE_MASTERDBO | SEC_NOTES | upddateUPDDATE | DATE | EagleML/referenceTransaction/securityNotes/NoteModel/updateDate | ||||||
notes | string | 3461 | in_notes | PACE_MASTERDBO | SEC_NOTES | notesNOTES | VARCHAR2(1000) | EagleML/referenceTransaction/securityNotes/NoteModel/notes | |||||||
noteType | string | 2097 | in_note_type | PACE_MASTERDBO | SEC_NOTES | noteNOTE_typeTYPE | VARCHAR2(25) | EagleML/referenceTransaction/securityNotes/NoteModel/noteType | |||||||
updateUser | Required | string | 944 | in_update_user | PACE_MASTERDBO | SEC_NOTES | upduserUPDUSER | 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/noteIndicator | |||||||
noteCharKey | string | 3462 | 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/privateNote |
...