Ok, here is an example doc, please give it a try.
{
"_id" : NUUID("c26442ad-a8df-4095-8086-405994222c53"),
"SecurityAggregateVersion" : NumberLong(4),
"MarketDataAggregateVersion" : NumberLong(1),
"Fields" : {
"Issuer_Fundamentals_CountryOfRisk_Iso3166Alpha2" : {
"_t" : "StringSecurityDataField",
"LastUpdate" : "16620353903630469",
"EffectiveDateTime" : "2022-09-01T12:29:45.8112946",
"AssetType" : -1,
"Source" : "ABCD",
"BillingCategory" : "Test Billing",
"BillingInfo" : [
[
"master_information.instrument_master.trex_asset_type",
"20"
],
[
"equity.equity_details.ADR_structure",
"## ERROR: Field not returned from BICE ##"
],
[
"master_information.organization_master.org_country_code",
"AT"
],
[
"debt.payment_schedule.pool_factor",
null
],
[
"debt.cmo_details.tranche_number",
null
],
[
"debt.fixed_income.debt_type",
"## ERROR: Field not returned from BICE ##"
]
],
"Value" : "AT678"
},
"Issuer_Fundamentals_Name" : {
"_t" : "StringSecurityDataField",
"LastUpdate" : "16620353903630469",
"EffectiveDateTime" : "2022-09-01T12:29:45.8112946",
"AssetType" : -1,
"Source" : "ABCD",
"BillingCategory" : "Test Billing",
"BillingInfo" : [
[
"master_information.instrument_master.trex_asset_type",
"20"
],
[
"equity.equity_details.ADR_structure",
"## ERROR: Field not returned from BICE ##"
],
[
"master_information.organization_master.org_country_code",
"AT"
],
[
"debt.payment_schedule.pool_factor",
null
],
[
"debt.cmo_details.tranche_number",
null
],
[
"debt.fixed_income.debt_type",
"## ERROR: Field not returned from BICE ##"
]
],
"Value" : "Centrobank AG"
}
},
"SourceFields" : {
"ABCD" : {
"Instrument_Issue_Issuer_IdcIssuer" : {
"_t" : "StringSecurityDataField",
"LastUpdate" : "16620353903726245",
"EffectiveDateTime" : "2022-09-01T12:29:45.8112946",
"AssetType" : -1,
"Source" : "ABCD",
"BillingCategory" : "Test Billing",
"BillingInfo" : [
[
"master_information.instrument_master.trex_asset_type",
"20"
],
[
"equity.equity_details.ADR_structure",
"## ERROR: Field not returned from BICE ##"
],
[
"master_information.organization_master.org_country_code",
"AT"
],
[
"debt.payment_schedule.pool_factor",
null
],
[
"debt.cmo_details.tranche_number",
null
],
[
"debt.fixed_income.debt_type",
"## ERROR: Field not returned from BICE ##"
]
],
"Value" : "CENHAN"
},
"Instrument_Issue_IssueCurrency_Iso4217Alpha3" : {
"_t" : "StringSecurityDataField",
"LastUpdate" : "16620353903726245",
"EffectiveDateTime" : "2022-09-01T12:29:45.8112946",
"AssetType" : -1,
"Source" : "ABCD",
"BillingCategory" : "Test Billing",
"BillingInfo" : [
[
"master_information.instrument_master.trex_asset_type",
"20"
],
[
"equity.equity_details.ADR_structure",
"## ERROR: Field not returned from BICE ##"
],
[
"master_information.organization_master.org_country_code",
"AT"
],
[
"debt.payment_schedule.pool_factor",
null
],
[
"debt.cmo_details.tranche_number",
null
],
[
"debt.fixed_income.debt_type",
"## ERROR: Field not returned from BICE ##"
]
],
"Value" : "EUR"
},
"Instrument_Debt_CouponSchedule" : {
"_t" : "ArraySecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"BillingCategory" : "Manual Entry",
"OverrideUntil" : "2021-01-14T14:18:43.13",
"Value" : [
{
"_t" : "RecordSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T14:18:43.13",
"Value" : {
"Price" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : "77777.0"
},
"IsPercentage" : {
"_t" : "BooleanSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : false
},
"Date" : {
"_t" : "DateSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : "2020-01-01"
}
}
}
]
}
},
"OpenFigi" : {
"Instrument_Naming_ShortName" : {
"_t" : "StringSecurityDataField",
"LastUpdate" : "16620353905711796",
"EffectiveDateTime" : "2022-09-01T12:29:46.2499029",
"AssetType" : -1,
"Source" : "OpenFigi",
"BillingCategory" : "OpenFigi",
"BillingInfo" : [],
"Value" : "TEST 0 PERP"
},
"Instrument_Classification_BloombergSecurityType" : {
"_t" : "StringSecurityDataField",
"LastUpdate" : "16620353905711796",
"EffectiveDateTime" : "2022-09-01T12:29:46.2499029",
"AssetType" : -1,
"Source" : "OpenFigi",
"BillingCategory" : "OpenFigi",
"BillingInfo" : [],
"Value" : "EURO-ZONE"
},
"Instrument_PriceDivisor" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620369913791479",
"EffectiveDateTime" : "2022-09-01T10:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"BillingCategory" : "Test Billing",
"BillingInfo" : [
[
"master_information.instrument_master.trex_asset_type",
"20"
],
[
"equity.equity_details.ADR_structure",
"## ERROR: Field not returned from BICE ##"
],
[
"master_information.organization_master.org_country_code",
"AT"
],
[
"debt.payment_schedule.pool_factor",
null
],
[
"debt.cmo_details.tranche_number",
null
],
[
"debt.fixed_income.debt_type",
"## ERROR: Field not returned from BICE ##"
]
],
"OverrideUntil" : "2021-09-30T14:18:43.13",
"Value" : "101.0"
},
"Instrument_Debt_CouponSchedule" : {
"_t" : "ArraySecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"BillingCategory" : "Manual Entry",
"OverrideUntil" : "2021-01-14T14:18:43.13",
"Value" : [
{
"_t" : "RecordSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T14:18:43.13",
"Value" : {
"Price" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : "77777.0"
},
"IsPercentage" : {
"_t" : "BooleanSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : false
},
"Date" : {
"_t" : "DateSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : "2020-01-01"
}
}
}
]
}
},
"RemotePlus" : {
"Instrument_MarketData_DailyVolume" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620353906311889",
"EffectiveDateTime" : "2022-09-01T00:00:00",
"AssetType" : -1,
"Source" : "RemotePlus",
"BillingCategory" : "Test Billing2",
"BillingInfo" : [
[
"trexASSET",
"20"
],
[
"TYP1",
null
],
[
"ETDTYPE",
null
],
[
"ATYPE",
"30"
],
[
"COQ",
"AT"
]
],
"Value" : "294000.0"
},
"Instrument_MarketData_LastPrice" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620353906311889",
"EffectiveDateTime" : "2022-09-01T00:00:00",
"AssetType" : -1,
"Source" : "RemotePlus",
"BillingCategory" : "Test Billing2",
"BillingInfo" : [
[
"trexASSET",
"20"
],
[
"TYP1",
null
],
[
"ETDTYPE",
null
],
[
"ATYPE",
"30"
],
[
"COQ",
"AT"
]
],
"Value" : "0.309"
},
"Instrument_PriceDivisor" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620369913791479",
"EffectiveDateTime" : "2022-09-01T10:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"BillingCategory" : "Test Billing",
"BillingInfo" : [
[
"master_information.instrument_master.trex_asset_type",
"20"
],
[
"equity.equity_details.ADR_structure",
"## ERROR: Field not returned from BICE ##"
],
[
"master_information.organization_master.org_country_code",
"AT"
],
[
"debt.payment_schedule.pool_factor",
null
],
[
"debt.cmo_details.tranche_number",
null
],
[
"debt.fixed_income.debt_type",
"## ERROR: Field not returned from BICE ##"
]
],
"OverrideUntil" : "2021-09-30T14:18:43.13",
"Value" : "101.0"
},
"Instrument_Debt_CouponSchedule" : {
"_t" : "ArraySecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"BillingCategory" : "Manual Entry",
"OverrideUntil" : "2021-01-14T14:18:43.13",
"Value" : [
{
"_t" : "RecordSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T14:18:43.13",
"Value" : {
"PrBICE" : {
"_t" : "DecimalSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : "77777.0"
},
"IsPercentage" : {
"_t" : "BooleanSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : false
},
"Date" : {
"_t" : "DateSecurityDataField",
"LastUpdate" : "16620388323222898",
"EffectiveDateTime" : "2021-01-12T15:18:43.13",
"AssetType" : 0,
"Source" : "Manual",
"OverrideUntil" : "2021-01-14T00:00:00",
"Value" : "2020-01-01"
}
}
}
]
}
}
}
}