...
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 |
|
|
|
| YesNoOptionEnum | not stored in DB, used to manage the download logic | EagleML/referenceTransaction/genericSMF/accountingValidationFlag | ||||||||||
| journalizingFlag | JournalizingFlagEnum | 1293 | in_journal_flag | S | smfflags_model.inc | not stored in DB, used to manage the download logic |
| EagleML/referenceTransaction/genericSMF/ | accountingValidationFlagjournalizingFlag | |||||||||||
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 | ||||||||||||
inactiveFlag |
|
| YesNoOptionEnum | 11043 | in_inactive_flag | S | smfflags_model.inc | SECURITYDBO | SECURITY_MASTER | INACTIVE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/inactiveFlag | ||||||||
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 | ||||||||
incomeCurrency |
|
| CurrencyCode | 1186 | in_sm_income_currency | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER | INCOME_CURRENCY | CHAR(3) | EagleML/referenceTransaction/genericSMF/incomeCurrency | ||||||||
quantityType | Required - Defaulted to "CURRENCY" 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.0000" 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.00" by panel |
| decimal | 19 | in_sm_trading_unit | F | smfobject.inc | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/quantityScale | ||||||||
maturityDate | Required |
| date | 38 | in_mat_date | S | fixedincomesmf_model.inc | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/referenceTransaction/genericSMF/maturityDate | ||||||||
maturityDelayDaysType |
| string | 3998 | in_maturity_delay_days_type | S | fixedincome_extension.inc | SECURITYDBO | FIXED_INCOME | MATURITY_DELAY_DAYS_TYPE | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/FixedIncomeModel/maturityDelayDaysType | |||||||||
ForwardModel |
|
| ForwardModel | EagleML/referenceTransaction/genericSMF/ForwardModel | ||||||||||||||||