Generic SMF - Note Model Data Map 

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

Element

Optional/ Required

Value Type

Star Tag

SP Parameter

SP Type

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

updateDate

Required

date

1452

in_upddate

S

 

PACE_MASTERDBO

SEC_NOTES

UPDDATE

DATE

EagleML/referenceTransaction/genericSMF/NoteModel/updateDate

notes

 

string

3461

in_notes

S

 

PACE_MASTERDBO

SEC_NOTES

NOTES

VARCHAR2(1000)

EagleML/referenceTransaction/genericSMF/NoteModel/notes

noteType

 

string

2097

in_note_type

S

 

PACE_MASTERDBO

SEC_NOTES

NOTE_TYPE

VARCHAR2(100)

EagleML/referenceTransaction/genericSMF/NoteModel/noteType

updateUser

Required

string

944

in_update_source

S

 

PACE_MASTERDBO

SEC_NOTES

UPDUSER

VARCHAR2(125)

EagleML/referenceTransaction/genericSMF/NoteModel/updateUser

noteIndicator

 

string

2095

in_upduser

S

 

PACE_MASTERDBO

SEC_NOTES

NOTE_INDICATOR

CHAR(2)

EagleML/referenceTransaction/genericSMF/NoteModel/noteIndicator

noteCharKey

 

string

3462

in_note_char_key

S

 

PACE_MASTERDBO

SEC_NOTES

NOTE_CHAR_KEY

CHAR(12)

EagleML/referenceTransaction/genericSMF/NoteModel/noteCharKey

shareProperty

 

string

1147

in_share_property

S

 

PACE_MASTERDBO

SEC_NOTES

SHARE_PROPERTY

NUMBER

EagleML/referenceTransaction/genericSMF/NoteModel/shareProperty

privateNote

 

string

1256

in_private_note

S

 

PACE_MASTERDBO

SEC_NOTES

PRIVATE_NOTE

CHAR(1)

EagleML/referenceTransaction/genericSMF/NoteModel/privateNote