Code Category Data Map Table

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Data Type

SP Parameter

XPath

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

Star Tag

DB Data Type

SP Parameter

XPath

objectType

Optional

ObjectTypeEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/objectType

objectId

Optional

ObjectId

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/objectDescription

updateTimestamp

Optional

dateTime

PACE_MASTERDBO

CODE_VALUES

upd_datetime

 

DATE

 

EagleML/referenceTransaction/codeCategory/updateTimestamp

customElements

Not recommended

CustomElements - Complex type

reserved for customizations 

EagleML/referenceTransaction/codeCategory/customElements/

sourceName

Optional

string - used in resolution logics

PACE_MASTERDBO

INTERFACES

SHORT_DESC

 

CHAR(15)

 

EagleML/referenceTransaction/codeCategory/sourceName

updateSource

Optional

string

PACE_MASTERDBO

CODE_VALUES

UPD_OPER

944

char(50)

in_upd_src

EagleML/referenceTransaction/codeCategory/updateSource

effectiveDate

Optional

date

PACE_MASTERDBO

CODE_VALUES

upd_datetime

1109

DATE

 

EagleML/referenceTransaction/codeCategory/effectiveDate

languageId

Optional

integer

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/languageId

tagNochangecase

Optional

string

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/tagNochangecase

preserveNull

Optional

string

not stored in DB 

 

 

 

EagleML/referenceTransaction/codeCategory/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/noLoadValidationFlag

accountingValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

 

 

EagleML/referenceTransaction/codeCategory/accountingValidationFlag

codeCategory

 

 

CodeCategory Model

EagleML/referenceTransaction/codeCategory/