Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

Data_Type

Xpath

objectType

Required

 

 

 

 

not stored in DB

 

EagleML/referenceTransaction/calendar/objectType

objectId

 

 

 

 

 

not stored in DB

 

EagleML/referenceTransaction/calendar/objectId

objectDescription

 

 

 

 

 

not stored in DB 

 

EagleML/referenceTransaction/calendar/objectDescription

updateTimestamp

 

 

 

 

 

PACE_MASTERDBO

ESTAR_CALENDAR

UPDATE_DATE

DATE

EagleML/referenceTransaction/calendar/updateTimestamp

customElements

 

 

 

 

 

reserved for customizations 

 

EagleML/referenceTransaction/calendar/customElements

sourceName

 

 

 

 

 

not stored in DB

 

 

 

EagleML/referenceTransaction/calendar/sourceName

updateSource

Required - Defaulted to "User ID" by Panel

 

944

in_update_source

S

PACE_MASTERDBO

ESTAR_CALENDAR

UPDATE_SOURCE

varchar2(32)

EagleML/referenceTransaction/calendar/updateSource 

effectiveDate

 

 

 

 

 

not stored in DB 

 

EagleML/referenceTransaction/calendar/effectiveDate

languageId

 

 

 

 

 

not stored in DB

 

EagleML/referenceTransaction/calendar/languageId

tagNochangecase

 

 

4637

 

 

not stored in DB

 

EagleML/referenceTransaction/calendar/tagNochangecase

preserveNull

 

 

5284

 

 

not stored in DB

 

EagleML/referenceTransaction/calendar/preserveNull

noLoadValidationFlag

 

 

 

 

 

not stored in DB 

 

EagleML/referenceTransaction/calendar/noLoadValidationFlag

accountingValidationFlag

 

 

 

 

 

not stored in DB

 

EagleML/referenceTransaction/calendar/accountingValidationFlag

calendarName

Required

 

1941

in_cal

S

PACE_MASTERDBO

ESTAR_CALENDAR

NAME

varchar2(50)

EagleML/referenceTransaction/calendar/calendarName 

calendarType

Required

 

1256

in_cal_type

S

PACE_MASTERDBO

ESTAR_CALENDAR

TYPE

varchar2(2)

EagleML/referenceTransaction/calendar/calendarType 

countryCode

Required

 

990

in_country_short_name

S

PACE_MASTERDBO

ESTAR_CALENDAR

COUNTRY_SHORT_NAME

char(20)

EagleML/referenceTransaction/calendar/countryCode 

countryName

 

 

4490

in_country_long_name

S

PACE_MASTERDBO

ESTAR_CALENDAR

COUNTRY_LONG_NAME

char(50)

EagleML/referenceTransaction/calendar/countryName 

calendarDescription

 

 

1942

in_desc

S

PACE_MASTERDBO

ESTAR_CALENDAR

DESCRIPTION

varchar2(100)

EagleML/referenceTransaction/calendar/calendarDescription 

financialExchange

 

 

2368

in_financial_exchange

S

PACE_MASTERDBO

ESTAR_CALENDAR

FINANCIAL_EXCHANGE

varchar2(30)

EagleML/referenceTransaction/calendar/financialExchange 

startingYear

Required

 

1943

in_excp_year

S

PACE_MASTERDBO

ESTAR_CALENDAR_DAY

STAR_YEAR

varchar2

EagleML/referenceTransaction/calendar/startingYear 

yearsToGenerate

Required

 

4299

in_years

I

PACE_MASTERDBO

ESTAR_CALENDAR

EXCP_YEAR

integer

EagleML/referenceTransaction/calendar/yearsToGenerate