Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
objectType | Required |
ObjectTypeEnum | - |
not stored in DB | ||||||
EagleML/referenceTransaction/genericSMF/objectType | ||||
objectId | ||||
ObjectId | - |
not stored in DB | |||||
EagleML/referenceTransaction/genericSMF/objectId | |
objectDescription |
FeedTypeEnum | - |
not stored in DB | |||||
EagleML/referenceTransaction/genericSMF/objectDescription | |
updateTimestamp |
dateTime | - |
not stored in DB | ||||||
EagleML/referenceTransaction/genericSMF/updateTimestamp | ||||||||||||
sourceName | Required | Required | string | 1102 | in_short_desc | S | referenceobject.inc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/genericSMF/sourceName |
updateSource | Required | Required | string | 944 | in_update_source | S | referenceobject.inc | SECURITYDBO | SECURITY_MASTER | UPDATE_SOURCE | CHAR(255) | EagleML/referenceTransaction/genericSMF/updateSource |
effectiveDate | Required | Required | date | 1109 | in_effective_date | S | referenceobject.inc | SECURITYDBO | All history (_HIST) tables | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/genericSMF/effectiveDate |
accountingValidationFlag | Required |
YesNoOptionEnum |
not stored in DB, used to manage the download logic | EagleML/referenceTransaction/genericSMF/accountingValidationFlag | |||||||||||
EagleML/referenceTransaction/genericSMF/ | ||||||||||||
historyOnlyFlag | ||||||||||||
YesNoOptionEnum | 1257 | in_trans_type | S | smfflags_model.inc | not stored in DB, used for resolution logic | EagleML/referenceTransaction/genericSMF/historyOnlyFlag | |||||
spokeCheckFlag | |||||||||||
integer | 7250 | in_hub_tag | I | smfflags_model.inc | not stored in DB, used for resolution logic | EagleML/referenceTransaction/genericSMF/spokeCheckFlag | |||||
inactiveFlag | |||||||||||
YesNoOptionEnum | 11043 | in_inactive_flag | S | smfflags_model.inc | SECURITYDBO | SECURITY_MASTER | INACTIVE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/inactiveFlag | |||
vendorModeFlag |
VendorModeFlagEnum | 1085 |
smfflags_model.inc | not stored in DB, used for resolution logic | EagleML/referenceTransaction/genericSMF/vendorModeFlag | |||||
updateMasterTablesFlag | |||||||
string | 990 | in_tag_list | S | smfflags_model.inc | not stored in DB, used for resolution logic | EagleML/referenceTransaction/genericSMF/updateMasterTablesFlag | ||||||
journalizingFlag | ||||||||||||
JournalizingFlagFlagEnum | 1293 | in_journal_flag | S | smfflags_model.inc | not stored in DB, used for resolution logic | EagleML/referenceTransaction/genericSMF/journalizingFlag | |||||
fieldCompareFlag | |||||||||||
YesNoOptionEnum | 989 | in_989_flag | S | smfflags_model.inc | not stored in DB, used for resolution logic | EagleML/referenceTransaction/genericSMF/fieldCompareFlag | |||||
investmentType | Required | ||||||||||
StringWithCodeScheme | 11 | in_investment_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | CHAR(4) | EagleML/referenceTransaction/genericSMF/investmentType | |||
processingSecurityType | Required | Required | StringWithCodeScheme | 3931 | in_process_sec_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | PROCESS_SEC_TYPE | VARCHAR2(15) | EagleML/referenceTransaction/genericSMF/processingSecurityType |
securityType |
string | 82 | in_security_type | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | EagleML/referenceTransaction/genericSMF/securityType | |||
securitySubType |
string | 1464 | in_alt_security_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | ALT_SECURITY_TYPE | CHAR(15) | EagleML/referenceTransaction/genericSMF/securitySubType | ||
settlementCurrency | Required |
CurrencyCode | 63 | in_settlement_currency | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | SETTLEMENT_CURRENCY | CHAR(3) | EagleML/referenceTransaction/genericSMF/settlementCurrency | |
incomeCurrency | Required |
CurrencyCode | 1186 | in_sm_income_currency | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | INCOME_CURRENCY | CHAR(3) | EagleML/referenceTransaction/genericSMF/incomeCurrency | ||
quantityType | Required - Defaulted to "SHARES" |
StringWithCodeScheme | 12 | in_quantity_type | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | QUANTITY_TYPE | CHAR(12) | EagleML/referenceTransaction/genericSMF/quantityType | ||
priceMultiplier | Required - Defaulted to "1" by panel |
decimal | 18 | in_price_multiplier | F | smfobject.inc | SECURITYDBO | SECURITY_MASTER | PRICE_MULTIPLIER | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/priceMultiplier | ||
quantityScale | Required - Defaulted to "1" by panel |
decimal | 19 | in_sm_trading_unit | F | smfobject.inc | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/quantityScale | ||
issueCountryCode | Required |
CountryCode | 1418 | in_nra_tax_country | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | NRA_TAX_COUNTRY | CHAR(30) | EagleML/referenceTransaction/genericSMF/issueCountryCode | |
countryOfRiskCode |
CountryCode | 10536 | in_country_of_risk | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | COUNTRY_OF_RISK | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/countryOfRiskCode | |||
issueTaxType |
string | 668 | in_issue_tax_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | ISSUE_TAX_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/issueTaxType | ||
region |
string | 5423 | in_region | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | REGION | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/region | ||
restrictedIndicator |
string | 1139 | in_liquid_flag | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | LIQUID_FLAG | CHAR(2) | EagleML/referenceTransaction/genericSMF/restrictedIndicator | ||
multiListedIndicator |
YesNoOptionEnum | 4565 | in_multi_listed_flag | S | smfobject.inc | SECURITYDBO | EQUITY | MULTI_LISTED_FLAG | CHAR(2) | EagleML/referenceTransaction/genericSMF/multiListedIndicator | ||
refundIndicator |
YesNoOptionEnum | 3132 | in_muni_refund_stat | S | smfobject.inc | SECURITYDBO | MUNI | MUNI_REFUND_STAT | CHAR(2) | EagleML/referenceTransaction/genericSMF/refundIndicator | ||
gicsSector |
string | 10181 | in_gics_sector | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SECTOR | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsSector | ||
gicsSectorName |
string | 10182 | in_gics_name | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_NAME | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsSectorName | ||
gicsIndustryGroup |
string | 10183 | in_gics_industry_group | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsIndustryGroup | |||
gicsIndustryGroupName |
string | 10184 | in_gics_industry_group_name | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP_NAME | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsIndustryGroupName | ||
gicsIndustry |
string | 10185 | in_gics_industry | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsIndustry | ||
gicsIndustryName |
string | 10186 | in_gics_industry_name | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_NAME | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsIndustryName | ||
gicsSubIndustry |
string | 10187 | in_gics_sub_industry | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUB_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsSubIndustry | ||
gicsSubIndustryName |
string | 10188 | in_gics_sub_industry_name | S | gics_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUB_INDUSTRY_NAME | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/gicsSubIndustryName | ||
offset |
decimal | 215 | in_offset | N | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | OFFSET | NUMBER | EagleML/referenceTransaction/genericSMF/offset | |||
underlyingCusip |
string | 1348 | in_underlying_cusip | S | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | UNDERLYING_CUSIP | CHAR(100) | EagleML/referenceTransaction/genericSMF/underlyingCusip | |||
maturityDate |
decimal | 38 | in_mat_date | S | fixedincomesmf_model.inc | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/referenceTransaction/genericSMF/maturityDate | ||
closedEndFundFlag |
string | 1792 | in_closed_end_fund_flag | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | CLOSED_END_FUND_FLAG | CHAR(2) | EagleML/referenceTransaction/genericSMF/closedEndFundFlag | ||
smIssuerId |
string | 1413 | in_sm_issuer_id | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | ISSUER_ID | CHAR(20) | EagleML/referenceTransaction/genericSMF/smIssuerId | |||
issuerInd |
string | 1417 | in_issuer_ind | S | generic_smf_base_model.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ISSUER_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/issuerInd | ||
minorInd |
string | 1789 | in_minor_ind | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | MINOR_IND | CHAR(8) | EagleML/referenceTransaction/genericSMF/minorInd | ||
registeredFlag |
string | 1445 | in_registered_flag | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | REGISTERED_FLAG | CHAR(2) | EagleML/referenceTransaction/genericSMF/registeredFlag | |||
pficFlag |
string | 2906 | in_pfic_flag | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER | PFIC_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/pficFlag | ||
EquityModel |
EquityModel | EagleML/referenceTransaction/genericSMF/EquityModel | ||||||||||
FixedIncomeModel | |||||||||||
FixedIncomeModel | EagleML/referenceTransaction/genericSMF/FixedIncomeModel | |||||||||||