Pricing System Setting Data Map Table

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

DB Data Type

XPath

Element

Optional/Required

Value Type

Eagle DB

DB Table

DB Field

DB Data Type

XPath

objectType

Required

ObjectTypeEnum

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/objectType

objectId

Optional

ObjectId

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/objectDescription

updateTimestamp

Optional

dateTime

RULESDBO

PRICING_SYSTEM_SETTINGS

UPDATE_DATE

DATE

EagleML/referenceTransaction/pricingSystemSetting/updateTimestamp

customElements

Not recommended

CustomElements

reserved for customizations

 

EagleML/referenceTransaction/pricingSystemSetting/customElements/

sourceName

 

string

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR (15)

EagleML/referenceTransaction/pricingSystemSetting/sourceName

updateSource

Optional

string

RULESDBO

PRICING_SYSTEM_SETTINGS

UPDATE_USER

VARCHAR2(50)

EagleML/referenceTransaction/pricingSystemSetting/updateSource

effectiveDate

Optional

date

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/effectiveDate

languageId

Optional

integer

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/languageId

tagNochangecase

Optional

string

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/tagNochangecase

preserveNull

Optional

string

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/preserveNull

noLoadValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/noLoadValidationFlag

accountingValidationFlag

Optional

YesNoOptionEnum

not stored in DB

 

EagleML/referenceTransaction/pricingSystemSetting/accountingValidationFlag

code

Optional

string

RULESDBO

PRICING_SYSTEM_SETTINGS

CODE

VARCHAR2(50)

EagleML/referenceTransaction/pricingSystemSetting/code

description

Optional

string

RULESDBO

PRICING_SYSTEM_SETTINGS

DESCRIPTION

VARCHAR2(255)

EagleML/referenceTransaction/pricingSystemSetting/description

value

Optional

string

RULESDBO

PRICING_SYSTEM_SETTINGS

VALUE

VARCHAR2(50)

EagleML/referenceTransaction/pricingSystemSetting/value

comments

Optional

string

RULESDBO

PRICING_SYSTEM_SETTINGS

COMMENTS

VARCHAR2(2048)

EagleML/referenceTransaction/pricingSystemSetting/comments

editStatus

Optional

YesNoOptionEnum

RULESDBO

PRICING_SYSTEM_SETTINGS

EDIT_STATUS

CHAR(1)

EagleML/referenceTransaction/pricingSystemSetting/editStatus

reason

Optional

string

RULESDBO

PRICING_SYSTEM_SETTINGS

REASON

VARCHAR2(255)

EagleML/referenceTransaction/pricingSystemSetting/reason

settingType

Optional

ProcedureModeTypeEnum

RULESDBO

PRICING_SYSTEM_SETTINGS

SETTING_TYPE

VARCHAR2(1)

EagleML/referenceTransaction/pricingSystemSetting/settingType

sysItem

Optional

integer

RULESDBO

PRICING_SYSTEM_SETTINGS

SYS_ITEM

NUMBER(38,0)

EagleML/referenceTransaction/pricingSystemSetting/sysItem

Â