Global Tax Rates Data Map Table

objectType

Optional

ObjectTypeEnum

not stored in DB

EagleML/referenceTransaction/globalTaxRate/objectType

objectId

Optional

ObjectId

not stored in DB

EagleML/referenceTransaction/globalTaxRate/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

EagleML/referenceTransaction/globalTaxRate/objectDescription

updateTimestamp

Optional

dateTime

1106

RULESDBO

GLOBAL_TAX_RATE

UPDATE_DATE

date

EagleML/referenceTransaction/globalTaxRate/updateTimestamp

customElements

Optional

CustomElements

reserved for customizations

EagleML/referenceTransaction/globalTaxRate/customElements

updateSource

Optional

string

in_update_source

S

944

RULESDBO

GLOBAL_TAX_RATE

UPDATE_SOURCE

varchar2(32)

EagleML/referenceTransaction/globalTaxRate/updateSource

distributionType

Required

string

in_dist_type

S

670

RULESDBO

GLOBAL_TAX_RATE

DIST_TYPE

varchar2(3)

EagleML/referenceTransaction/globalTaxRate/distributionType

beginDate

Required

date

in_begin_date

S

71

RULESDBO

GLOBAL_TAX_RATE

BEGIN_DATE

date

EagleML/referenceTransaction/globalTaxRate/beginDate

endDate

date

in_end_date

S

73

RULESDBO

GLOBAL_TAX_RATE

END_DATE

date

EagleML/referenceTransaction/globalTaxRate/endDate

entityCountry

string

1193

not stored in DB

EagleML/referenceTransaction/globalTaxRate/entityCountry

entityCountryCode

Required

CountryCode

in_entity_country

S

1342

RULESDBO

GLOBAL_TAX_RATE

ENTITY_COUNTRY

char(10)

EagleML/referenceTransaction/globalTaxRate/entityCountryCode

issueCountry

string

2290

not stored in DB

EagleML/referenceTransaction/globalTaxRate/issueCountry

issueCountryCode

Required

CountryCode

in_issue_country

S

1418

RULESDBO

GLOBAL_TAX_RATE

ISSUE_COUNTRY

char(10)

EagleML/referenceTransaction/globalTaxRate/issueCountryCode

entityTaxType

Required

string

in_entity_tax_type

S

3929

RULESDBO

GLOBAL_TAX_RATE

ENTITY_TAX_TYPE

varchar2(20)

EagleML/referenceTransaction/globalTaxRate/entityTaxType

entityTaxQualifier

Required

string

in_entity_tax_qualifier

S

3930

RULESDBO

GLOBAL_TAX_RATE

ENTITY_TAX_QUALIFIER

varchar2(8)

EagleML/referenceTransaction/globalTaxRate/entityTaxQualifier

primaryExchangeCode

Required

ExchangeCode

in_exchange

S

17

RULESDBO

GLOBAL_TAX_RATE

EXCHANGE

char(8)

EagleML/referenceTransaction/globalTaxRate/primaryExchangeCode

issueTaxType

Required

string

in_issue_tax_type

S

668

RULESDBO

GLOBAL_TAX_RATE

ISSUE_TAX_TYPE

varchar2(30)

EagleML/referenceTransaction/globalTaxRate/issueTaxType

overrideIndicatorCode

YesNoOptionEnum

in_override_ind

S

669

RULESDBO

GLOBAL_TAX_RATE

OVERRIDE_IND

varchar2(1)

EagleML/referenceTransaction/globalTaxRate/overrideIndicatorCode

taxWithholdingRate

decimal

in_withhold_rate

F

1295

RULESDBO

GLOBAL_TAX_RATE

WITHHOLD_RATE

number(28,12)

EagleML/referenceTransaction/globalTaxRate/taxWithholdingRate

taxReclaimRate

decimal

in_reclaim_rate

F

1296

RULESDBO

GLOBAL_TAX_RATE

RECLAIM_RATE

number(28,12)

EagleML/referenceTransaction/globalTaxRate/taxReclaimRate

avoirWithholdingRate

decimal

in_spec_withhold_rate

F

1297

RULESDBO

GLOBAL_TAX_RATE

SPEC_WITHHOLD_RATE

number(28,12)

EagleML/referenceTransaction/globalTaxRate/avoirWithholdingRate

avoirReclaimRate

decimal

in_spec_reclaim_rate

F

1298

RULESDBO

GLOBAL_TAX_RATE

SPEC_RECLAIM_RATE

number(28,12)

EagleML/referenceTransaction/globalTaxRate/avoirReclaimRate

description

string

in_rate_desc

S

1104

RULESDBO

GLOBAL_TAX_RATE

RATE_DESC

varchar2(255)

EagleML/referenceTransaction/globalTaxRate/description

doubleTaxReclaimRate

decimal

^{in_double_tax_rate}

¹⁸⁵⁹⁷

RULESDBO

GLOBAL_TAX_RATE

^{DOUBLE_TAX_RATE}

number(38,12)

^{EagleML/referenceTransaction/globalTaxRate/doubleTaxReclaimRate}