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 | 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 | 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 | ||
quantityType | Required - Defaulted to "CONTRACTS" by panel | 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.00" 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 "100.00" 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 | ||
region | string | 5423 | in_region | S | generic_smf_base_model.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | REGION | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/region | ||
putCallIndicator | Required | StringWithCodeScheme | 1350 | in_call_put_flag | S | optioncontractsmf_model.inc | SECURITYDBO | EQUITY | CALL_PUT_FLAG | CHAR(4) | EagleML/referenceTransaction/genericSMF/putCallIndicator | |
variationMarginFlag | YesNoOptionEnum | 4533 | in_var_margin | S | futurecontractsmf_model.inc | SECURITYDBO | DERIVATIVES | VAR_MARGIN | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/variationMarginFlag | ||
variationMarginRule | integer | 4350 | in_var_margin_rule | N | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | VAR_MARGIN_RULE | NUMBER | EagleML/referenceTransaction/genericSMF/variationMarginRule | ||
amereuro | Required | string | 1142 | in_amereuro | S | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | AMEREURO | VARCHAR2(10) | EagleML/referenceTransaction/genericSMF/amereuro | |
curr0 | string | 1356 | in_curr0 | S | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | CURR0 | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/curr0 | ||
curr1 | string | 1357 | in_curr1 | S | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | CURR1 | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/curr1 | ||
underlyingCusip | Required | string | 1348 | in_underlying_cusip | S | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | UNDERLYING_CUSIP | CHAR(100) | EagleML/referenceTransaction/genericSMF/underlyingCusip | |
underlyingSecurity | string | 1141 | in_underlying_security | S | underlyingsmf_model.inc | SECURITYDBO | DERIVATIVES | UNDERLYING_SECURITY | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/underlyingSecurity | ||
maturityDate | Required | decimal | 38 | in_mat_date | S | fixedincomesmf_model.inc | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/referenceTransaction/genericSMF/maturityDate | |
strikePrice | Required | decimal | 67 | in_strike_price | F | optioncontractsmf_model.inc | SECURITYDBO | DERIVATIVES | STRIKE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/strikePrice | |
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 | ||
FixedIncomeModel | FixedIncomeModel | EagleML/referenceTransaction/genericSMF/FixedIncomeModel | ||||||||||
FixedIncomeExtension | FixedIncomeExtensionModel | EagleML/referenceTransaction/genericSMF/FixedIncomeExtension | ||||||||||
General
Content
Integrations