Synthetic Cash SMF Data Map Table
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | SP TYPE | Include filename | 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 | Â |
languageId | Â | Â | integer | - | Â | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/genericSMF/languageId | Â | ||
tagNochangecase | Â | Â | string | 4637 | Â | Â | referenceobject.inc | Â | Â | Â | Â | EagleML/referenceTransaction/genericSMF/tagNochangecase | Â |
preserveNull | Â | Â | string | 5284 | Â | Â | referenceobject.inc | Â | Â | Â | Â | EagleML/referenceTransaction/genericSMF/preserveNull | Â |
noLoadValidationFlag | Â | Â | YesNoOptionEnum | Â | Â | Â | Â | not stored in DB, used to manage the download logic | Â | EagleML/referenceTransaction/genericSMF/noLoadValidationFlag | Â | ||
accountingValidationFlag | Required | Â | YesNoOptionEnum | Â | Â | Â | Â | not stored in DB, used to manage the download logic | Â | EagleML/referenceTransaction/genericSMF/accountingValidationFlag | Â | ||
EagleML/referenceTransaction/genericSMF/ | Â | ||||||||||||
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 "CASH" 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" 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 | Â |
issueTaxType | Â | Â | string | 668 | in_issue_tax_type | S | smfobject.inc | SECURITYDBO | SECURITY_MASTER_DETAIL | ISSUE_TAX_TYPE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/issueTaxType | Â |
putCallFlag | Â | Â | string | 1350 | in_put_call_flag | S | generic_smf_base_model.inc | SECURITYDBO | DERIVATIVES | PUT_CALL_FLAG | CHAR(4) | EagleML/referenceTransaction/genericSMF/putCallFlag | Â |
Â