Versions Compared

Key

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

Element

Optional/Required

Value Type

SP Parameter

SP Type

Star Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

objectType

Optional

ObjectTypeEnum

not stored in DB

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/objectType

objectId

Optional

ObjectId

not stored in DB

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/objectDescription

updateTimestamp

Optional

dateTime

1106

RULESDBO

GLOBAL

OVERRIDE_TAX_

RATE

TREATY

UPDATE_DATE

date

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/updateTimestamp

customElementsOptionalCustomElementsreserved for customizationsEagleML/referenceTransaction/globalTaxRate/customElements

updateSource

Optional

string

in_update_source

S

944

RULESDBO

GLOBAL

OVERRIDE_TAX_

RATE

TREATY

UPDATE_SOURCE

varchar2(32)

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/updateSource

Entity Common Id Model

EagleML/referenceTransaction/overrideTaxTreaty/

distributionType

Required

string

in_dist_type

S

670

RULESDBO

GLOBAL

OVERRIDE_TAX_

RATE

TREATY

DIST_TYPE

varchar2(3)

EagleML/referenceTransaction/

globalTaxRate/distributionTypebeginDateRequireddatein_begin_dateS71RULESDBOGLOBAL_TAX_RATEBEGIN_DATEdateEagleML/referenceTransaction/globalTaxRate/beginDateendDatedatein_end_dateS73RULESDBOGLOBAL_TAX_RATEEND_DATEdateEagleML/referenceTransaction/globalTaxRate/endDateentityCountrystring1193not stored in DBEagleML/referenceTransaction/globalTaxRate/entityCountryentityCountryCodeRequiredCountryCodein_entity_countryS1342RULESDBOGLOBAL_TAX_RATEENTITY_COUNTRYchar(10)EagleML/referenceTransaction/globalTaxRate/entityCountryCode

overrideTaxTreaty/distributionType

issueCountry

string

2290

1081

not stored in DB

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/issueCountry

issueCountryCode

Required

CountryCode

in_issue_country

S

1418

RULESDBO

GLOBAL

OVERRIDE_TAX_

RATE

TREATY

ISSUE_COUNTRY

char(10)

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/issueCountryCode

entityTaxTypeRequiredstringin_entity_tax_typeSentityTaxQualifierRequiredstringin_entity_tax_qualifierS3930RULESDBOGLOBAL_TAX_RATEENTITY_TAX_QUALIFIERvarchar2(8)EagleML/referenceTransaction/globalTaxRate/entityTaxQualifierprimaryExchangeCodeRequiredExchangeCodein_exchangeS17RULESDBOGLOBAL_TAX_RATEEXCHANGEchar(8)EagleML/referenceTransaction/globalTaxRate/primaryExchangeCode

3929RULESDBOGLOBAL_TAX_RATEENTITY_TAX_TYPEvarchar2(20)EagleML/referenceTransaction/globalTaxRate/entityTaxType

issueTaxType

Required

string

in_issue_tax_type

S

668

RULESDBO

GLOBAL

OVERRIDE_TAX_

RATE

TREATY

ISSUE_TAX_TYPE

varchar2(30)

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/issueTaxType

overrideIndicatorCode

beginDate

Required

YesNoOptionEnum

date

in_

override

begin_

ind

date

S

669

71

RULESDBO

GLOBAL_TAX_RATE

OVERRIDE_

INDvarchar2(1)EagleML/referenceTransaction/globalTaxRate/overrideIndicatorCodetaxWithholdingRatedecimalin_withhold_rateF1295RULESDBOGLOBAL_TAX_RATEWITHHOLD_RATEnumber(28,12)

TAX_TREATY

BEGIN_DATE

date

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/

taxWithholdingRate

beginDate

taxReclaimRatenumber(28,12)

endDate

decimalin_reclaim_rateF1296RULESDBOGLOBAL_TAX_RATERECLAIM_RATEnumber(28,12)EagleML/referenceTransaction/globalTaxRate/taxReclaimRateavoirWithholdingRatedecimalin_spec_withhold_rateF1297RULESDBOGLOBAL_TAX_RATESPEC_WITHHOLD_RATE

Required

date

in_end_date

S

73

RULESDBO

OVERRIDE_TAX_TREATY

END_DATE

date

EagleML/referenceTransaction/

globalTaxRate

overrideTaxTreaty/

avoirWithholdingRatedescription

endDate

avoirReclaimRatedecimalin_spec_reclaim_rateF1298RULESDBOGLOBAL_TAX_RATESPEC_RECLAIM_RATEnumber(28,12)EagleML/referenceTransaction/globalTaxRate/avoirReclaimRate

description

Optional

string

in_rate_desc

S

1104

RULESDBO

GLOBAL

OVERRIDE_TAX_

RATE

TREATY

RATE_DESC

varchar2(255)

EagleML/referenceTransaction/

globalTaxRate/description

doubleTaxReclaimRate

decimal
in_double_tax_rate
18597
RULESDBOGLOBAL_TAX_RATE
DOUBLE_TAX_RATE
number(38,12)EagleML/referenceTransaction/globalTaxRate/doubleTaxReclaimRate

overrideTaxTreaty/description