BSSB SMF Data Map Table

When you load notionalAmount with accountingValidationFlag set to 'Y', please note that its value is mapped to FixedIncomeModel/amountIssued. You will not find notionalAmount in your extracted message and your preset FixedIncomeModel/amountIssued may change its value. This logic has been applied to provide Generic SMF support here without adding extra fields.

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
Asset Identifiers Model												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	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 "PAR" 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 "0.0100" 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
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
notionalAmount	Required		decimal	1537	in_fi_issue_amount	N	bssbsmf_model.inc	SECURITYDBO	FIXED_INCOME	ISSUE_AMOUNT	NUMBER(28,12)	EagleML/referenceTransaction/genericSMF/notionalAmount
smIssuerId			string	1413	in_sm_issuer_id	S	generic_smf_base_model.inc	SECURITYDBO	SECURITY_MASTER	ISSUER_ID	CHAR(20)	EagleML/referenceTransaction/genericSMF/smIssuerId
maturityDate	Required		date	38	in_mat_date	S	fixedincomesmf_model.inc	SECURITYDBO	SECURITY_MASTER	MAT_DATE	DATE	EagleML/referenceTransaction/genericSMF/maturityDate
FixedIncomeModel			FixedIncomeModel	Fixed Income Model (see extra table)								EagleML/referenceTransaction/genericSMF/FixedIncomeModel
UnderlyingModel			UnderlyingModel	Underlying Model (see extra table)								EagleML/referenceTransaction/genericSMF/UnderlyingModel