About the Extract and Load IWS Solutions
You can extract and load data via the following Eagle-provided sample IWS workflow solutions:
- The generic data extract IWS workflow solution
- The generic data load IWS workflow solution
The following table summarizes the status of the currently supported EagleML types and the associated load and extract process names.
For example, if you perform an Entity List extract, a file with the name GEN_EXTRACT_150901110525_ENTITYLIST_246.xml is created. At the same time, to load an Entity List file to the database correctly, the file name must contain the _ENTITYLIST_ pattern.
Sub Group | Supported EagleML Type | Extract/Load File Name Pattern | Load Process Name | Extract Process Name | Comments/Status |
---|---|---|---|---|---|
SMF | Generic SMF | _GENERICSMF_ | load_generic_smf | extract_generic_smf | |
Generic SMF MI | _GENERICSMFMI_ | load_generic_smf_mi | Only load object | ||
Multiple Leg SMF | _MULTILEGSMF_ | load_generic_multi_leg_smf | Only load object | ||
ENTITY | Entity List | _ENTITYLIST_ | load_entity_list | extract_entity_list | |
Entity To List | _ENTITYTOLIST_ | load_entity_to_list | Only load object | ||
Entities In List | _ENTITIESINLIST_ | load_entities_in_list | extract_entities_in_list | In development/modification | |
Entity Composite | _ENTITYCOMPOSITE_ | load_entity_composite | extract_entity_composite | ||
Entity To Composite | _ENTITYTOCOMPOSITE_ | load_entity_to_composite | Only load object | ||
Composite Entity List | _COMPOSITEENTITYLIST_ | load_entities_in_composite | extract_entities_in_composite | In development/modification | |
Entity Bank Relationship | _ENTITYBANKRELATIONSHIP_ | load_entity_bank_relationship | extract_entity_bank_relationship | ||
Entity Accounting Basis | _ENTITYACCOUNTINGBASIS_ | load_entity_accounting_basis | extract_entity_accounting_basis | ||
Entity XREF | _ENTITYXREF_ | load_entity_xref | |||
Generic Entity | _GENERICENTITY_ | load_generic_entity | extract_generic_entity | ||
Entity Manager | _ENTITYMANAGER_ | load_entity_manager | extract_entity_manager | ||
Entity Manager Relationship | _ENTITYMANAGERRELATIONSHIP_ | load_entity_manager_relationship | extract_entity_manager_relationship | ||
Entity Identifiers | _ENTITYIDENTIFIERS_ | load_entity_identifiers | extract_entity_identifiers | In development/modification | |
Entity Accounting Periods | _ENTITYACCOUNTINGPERIODS_ | load_entity_accounting_periods | extract_entity_accounting_periods | ||
GIPS Composite | _GIPSCOMPOSITE_ | load_gips_composite | extract_gips_composite | ||
Entity Benchmark Assignment | _BENCHMARKASSIGNMENT_ | load_entity_benchmark_assignment | Only load object | ||
Entity Entitlement List | _ENTITYENTITLEMENTLIST_ | extract_entity_entitlement_list | Only extract object | ||
Entity Share Class | _ENTITYSHARECLASS_ | extract_entity_share_class | Only extract object | ||
RULE | Month End Date Rule | _MONTHENDDATERULE_ | load_rule_month_end_date | extract_rule_month_end_date | |
Earn Thru Rule | _EARNTHRURULE_ | load_rule_earn_thru | extract_rule_earn_thru | ||
Contractual Cash Settlement Rule | _CONTRACTUALCASHSETTLEMENTRULE_ | load_rule_contractual_cash_settlement | extract_rule_contractual_cash_settlement | ||
Contract Cash Rule | _CONTRACTCASHRULE_ | load_rule_contract_cash | extract_rule_contract_cash | ||
Basis Processing Rule | _BASISPROCESSINGRULE_ | load_rule_basis_processing | extract_rule_basis_processing | ||
Backup Withholding Rule | _BACKUPWITHHOLDINGRULE_ | load_rule_backup_withholding | extract_rule_backup_withholding | ||
Amortization Schedule Rule | _AMORTIZATIONSCHEDULERULE_ | load_rule_amortization_schedule | extract_rule_amortization_schedule | ||
Accounting Rule | _ACCOUNTINGRULE_ | load_rule_accounting | extract_rule_accounting | ||
Primary Mixed Cost Basis Rule | _PRIMARYMIXEDCOSTBASISRULE_ | load_rule_primary_mixed_cost_basis | extract_rule_primary_mixed_cost_basis | ||
Warehouse | Warehouse Open Lot | _WAREHOUSEOPENLOT_ | load_warehouse_openlot | ||
Warehouse Open Lot XMLDBAPI | _WAREHOUSEOPENLOTXMLDBAPI_ | load_warehouse_openlot_xmldbapi | extract_warehouse_openlot | ||
Warehouse Close Lot | _WAREHOUSECLOSELOT_ | load_warehouse_closelot | extract_warehouse_closelot | ||
Warehouse Position | _WAREHOUSEPOSITION_ | load_warehouse_position | |||
Warehouse Position XMLDBAPI | _WAREHOUSEPOSITIONXMLDBAPI_ | load_warehouse_position_xmldbapi | extract_warehouse_position | ||
Warehouse Trade | _WAREHOUSETRADE_ | load_warehouse_trade | extract_warehouse_trade | ||
Warehouse Trade Charges | _WAREHOUSETRADECHARGES_ | load_warehouse_trade_charges | Only load object | ||
Warehouse Cash Activity | _WAREHOUSECASHACTIVITY_ | load_warehouse_cash_activity | extract_warehouse_cash_activity | ||
Warehouse Performance | _WAREHOUSEPERFORMANCE_ | load_warehouse_performance | extract_warehouse_performance | ||
Warehouse GL Balances | _WAREHOUSEGLBALANCES_ | load_warehouse_glbalances | extract_warehouse_glbalances | ||
Warehouse NAV | _WAREHOUSENAV_ | load_warehouse_nav | extract_warehouse_nav | ||
Warehouse NAV Multi | _WAREHOUSENAVMULTI_ | load_warehouse_nav_multi | extract_warehouse_nav_multi | ||
Warehouse Pending Trade | _WAREHOUSEPENDINGTRADE_ | load_warehouse_pending_trade | extract_warehouse_pending_trade | ||
Warehouse Broker Trade Quote | _WAREHOUSEBROKERTRADEQUOTE_ | load_warehouse_broker_trade_quote | extract_warehouse_broker_trade_quote | ||
Warehouse Cash Flow Projection | _WAREHOUSECASHFLOWPROJECTION_ | load_warehouse_cash_flow_projection | extract_warehouse_cash_flow_projection | ||
Trade Quotes | _TRADEQUOTES_ | load_trade_quotes | extract_trade_quotes | ||
Warehouse Trade XREF | _WAREHOUSETRADEXREFERENCE_ | load_warehouse_trade_xreference | Only load object | ||
Custody Restriction Activity | _CUSTODYRESTRICTIONACTIVITY_ | extract_custody_restriction_activity | Only extract object | ||
Custody Restriction Balance | _CUSTODYRESTRICTIONBALANCE_ | extract_custody_restriction_balance | Only extract object | ||
Warehouse Insurance Valuation Lot | _INSURANCEVALUATIONLOT_ | extract_warehouse_istarlot | Only extract object | ||
Warehouse Disclosure Status | _WAREHOUSEDISCLOSURESTATUS_ | load_warehouse_disclosure_status | extract_warehouse_disclosure_status | MAY2017 | |
ISSUER | Issuer MI | _ISSUERMI_ | load_issuer_mi | Only load object | |
Issuer | _ISSUER_ | load_issuer | extract_issuer | ||
Issuer Organization | _ISSUERORGANIZATION_ | load_issuer_organization | extract_issuer_organization | ||
Issuer Role | _ISSUERROLE_ | load_issuer_role | extract_issuer_role | ||
Issuer Entity Relationship | _ISSUERENTITYRELATIONSHIP_ | load_issuer_entity_relationship | extract_issuer_entity_relationship | MAY2017 | |
Issuer Relationship | _ISSUERRELATIONSHIP_ | load_issuer_relationship | extract_issuer_relationship | ||
Issuer Rating | _ISSUERRATING_ | extract_issuer_rating | |||
Role Model | _ROLEMODEL_ | load_issuer_role_model | Only load object | ||
Issuer Xref | _ISSUERXREF_ | load_issuer_xref | Only load object | ||
System | Code Value | _CODEVALUE_ | load_code_value | extract_code_value | |
Code Category | _CODECATEGORY_ | load_code_category | extract_code_category | ||
Code Translation | _CODETRANSLATION_ | load_code_translation | extract_code_translation | ||
Calendar | _CALENDAR_ | load_calendar | extract_calendar | ||
Calendar Holiday | _CALENDARHOLIDAY_ | load_calendar_holiday | extract_calendar_holiday | ||
Calendar Business Dates | _CALENDARBUSINESSDATES_ | extract_calendar_business_dates | Only extract object | ||
Error Definition | _ERRORDEFINITION_ | load_error_definition | extract_error_definition | ||
Yield Curve | _YIELDCURVE_ | load_yield_curve | extract_yield_curve | ||
Run Time Stamps | _RUNTIMESTAMPS_ | extract_run_time_stamps | Only extract object | ||
Ledger Notes | _LEDGERNOTES_ | load_ledger_notes | extract_ledger_notes | ||
GIPS Disclosures | _GIPSDISCLOSURES_ | load_gips_disclosures | extract_gips_disclosures | ||
Security Related | Issue Analytic | _ISSUEANALYTIC_ | load_issue_analytic | Only load object | |
Issue Fx Rate | _ISSUEFXRATE_ | load_issue_fx_rate | extract_issue_fx_rate | ||
Issue Pc Price | _ISSUEPCPRICE_ | load_issue_pc_price | Only load object | ||
Issue Price | _ISSUEPRICE_ | load_issue_price | extract_issue_price | ||
Issue Variable Rate | _ISSUEVARIABLERATE_ | load_issue_variable_rate | extract_issue_variable_rate | ||
Issue Fx Pc Rate | _ISSUEFXPCRATE_ | load_issue_fx_pc_rate | extract_issue_fx_pc_rate | ||
Generic Issue Analytic | _GENERICISSUEANALYTIC_ | load_generic_issue_analytic | extract_generic_issue_analytic | ||
Exchange Price | _EXCHANGEPRICE_ | load_exchange_price | extract_issue_exchange_price | ||
Schedule | _SCHEDULE_ | load_schedule | extract_schedule | ||
Rating | _RATING_ | load_rating | extract_rating | ||
Vendor Cash Flow | _VENDORCASHFLOW_ | load_vendor_cash_flow | Only load object | ||
Security Notes | _SECURITYNOTES_ | load_security_notes | Only load object | ||
Factor | _FACTOR_ | load_factor | extract_factor | ||
Model Price | _MODELPRICE_ | load_model_price | Only load object | ||
SMF Identifiers | _SMFIDENTIFIERS_ | load_smfidentifiers | extract_smfidentifiers | In development/modification | |
Time Series | _TIMESERIES_ | load_time_series | extract_time_series | ||
SMF Identifier | _SMFIDENTIFIER_ | load_smf_identifier | |||
Underlying SMF | _UNDERLYINGSMF_ | load_underlying_smf | Only load object | ||
Recovery Rate | _RECOVERYRATE_ | load_recovery_rate | Only load object | ||
Earnings Time Period Model | _EARNINGSTIMEPERIODMODEL_ | load_earnings_time_period_model | Only load object | ||
Forward Points | _FORWARDPOINTS_ | extract_forward_points | Only extract object | ||
Security Overrides | _SECURITYOVERRIDES_ | extract_security_overrides | Only extract object | ||
NAIC Designation | _NAICDESIGNATION_ | extract_naic_designation | Only extract object | ||
Client | Client | _CLIENT_ | load_client | extract_client | |
Client Communication | _CLIENTCOMMUNICATION_ | load_client_communication | extract_client_communication | ||
Corporate Action | GenericCA | _GENERICCA_ | load_generic_ca | extract_generic_ca | |
VoluntaryCAElection | _VOLUNTARYCAELECTION_ | load_voluntary_ca_election | extract_voluntary_ca_election | ||
MandatoryCAExclusion | _MANDATORYCAEXCLUSION_ | load_mandatory_ca_exclusion | Only load object | ||
Financial Event | Financial Event | _FINANCIALEVENT_ | extract_financial_event | Only extract object | |
Accounting | Cost Basis Adjustment | _COSTBASISADJUSTMENT_ | load_accounting_cost_basis_adjustment | Only load object | |
Accounting Trade | _ACCOUNTINGTRADE_ | load_accounting_trade | extract_accounting_trade | ||
Accounting Cash | _ACCOUNTINGCASH_ | load_accounting_cash | Only load object | ||
Accounting Asset Cash | _ACCOUNTINGASSETCASH_ | load_accounting_asset_cash | Only load object | ||
Accounting Reclaim Cash | _ACCOUNTINGRECLAIMCASH_ | load_accounting_reclaim_cash | Only load object | ||
Multiple Leg Accounting Trade | _MULTIPLELEGACCOUNTINGTRADE_ | load_accounting_trade_multi_leg | Only load object | ||
Impairments | _IMPAIRMENTS_ | load_accounting_impairments | Only load object | ||
(available in NOV2015 release) | |||||
Accrued Income | _ACCRUEDINCOME_ | extract_accounting_accrued_income | Only extract object | ||
Subscribe Reedem | _SUBSCRIBEREEDEM_ | extract_accounting_subscribe_reedem | Only extract object | ||
Daily Yield Mill Rate | _DAILYYIELDMILLRATE_ | extract_accounting_daily_mill_rate | Only extract object | ||
Unsettled Transactions | _UNSETTLEDTRANSACTIONS_ | extract_accounting_unsettled_trans | Only extract object | ||
Cash Journal | _CASHJOURNAL_ | extract_accounting_cash_journal | Only extract object | ||
Realized Gain Loss | _REALIZEDGAINLOSS_ | extract_accounting_realized_gl | Only extract object | ||
Settled Cash Activity | _SETTLEDCA_ | extract_accounting_settled_ca | Only extract object | ||
Consolidated Earned Income | _CONSEARNEDINCOME_ | extract_accounting_cons_earned_income | Only extract object | ||
General Ledger Activity | _GENERALLEDGERACTIVITY_ | extract_accounting_gl_activity | Only extract object | ||
Traded Cash Activity | _TRADEDCASHACTIVITY_ | extract_accounting_traded_cash_activity | Only extract object | ||
Distribution Activity | _DISTRIBUTIONACT_ | extract_accounting_distribution_activity | Only extract object | ||
Cash Projections | _CASHPROJECTIONS_ | extract_cash_projections | Only extract object | ||
Custom Ledger Account | _CUSTLEDGERACCT_ | extract_accounting_custom_ledger_acct | Only extract object | ||
Open Rec Pay Multi | _OPENRECPAYMULTI_ | extract_accounting_open_rec_pay_multi | Only extract object | ||
Unapproved Variation Margin | _UNAPPROVEDVARMARGIN_ | extract_accounting_unapproved_var_margin | Only extract object | ||
Trial Balance | _TRIALBALANCEEXTRACT_ | extract_accounting_trial_balance | Only extract object | ||
Accounting Intraday NAV | _INTRADAYNAV_ | extract_accounting_intraday_nav | Only extract object | ||
Accounting NAV for NASDAQ | _NAVFORNASDAQ_ | extract_accounting_nav_for_nasdaq | Only extract object | ||
Accounting Fair Value Comparison | _FAIRVALUECOMPARISON_ | extract_accounting_fair_value_comparison | Only extract object |
1
Sub Group | Supported EagleML Type | Extract/Load File Name Pattern | Load Process Name | Extract Process Name | Comments/Status |
SMF | Generic SMF | _GENERICSMF_ | load_generic_smf | extract_generic_smf | |
Generic SMF MI | _GENERICSMFMI_ | load_generic_smf_mi | Only load object | ||
Multiple Leg SMF | _MULTILEGSMF_ | load_generic_multi_leg_smf | Only load object | ||
ENTITY | Entity List | _ENTITYLIST_ | load_entity_list | extract_entity_list | |
Entity To List | _ENTITYTOLIST_ | load_entity_to_list | Only load object | ||
Entities In List | _ENTITIESINLIST_ | load_entities_in_list | extract_entities_in_list | In development / modification | |
Entity Composite | _ENTITYCOMPOSITE_ | load_entity_composite | extract_entity_composite | ||
Entity To Composite | _ENTITYTOCOMPOSITE_ | load_entity_to_composite | Only load object | ||
Composite Entity List | _COMPOSITEENTITYLIST_ | load_entities_in_composite | extract_entities_in_composite | In development / modification | |
Entity Bank Relationship | _ENTITYBANKRELATIONSHIP_ | load_entity_bank_relationship | extract_entity_bank_relationship | ||
Entity Accounting Basis | _ENTITYACCOUNTINGBASIS_ | load_entity_accounting_basis | extract_entity_accounting_basis | ||
Entity XREF | _ENTITYXREF_ | load_entity_xref | |||
Generic Entity | _GENERICENTITY_ | load_generic_entity | extract_generic_entity | ||
Entity Manager | _ENTITYMANAGER_ | load_entity_manager | extract_entity_manager | ||
Entity Manager Relationship | _ENTITYMANAGERRELATIONSHIP_ | load_entity_manager_relationship | extract_entity_manager_relationship | ||
Entity Identifiers | _ENTITYIDENTIFIERS_ | load_entity_identifiers | extract_entity_identifiers | In development / modification | |
Entity Accounting Periods | _ENTITYACCOUNTINGPERIODS_ | load_entity_accounting_periods | extract_entity_accounting_periods | ||
GIPS Disclosures | _GIPSDISCLOSURES_ | load_gips_disclosures | extract_gips_disclosures | ||
GIPS Composite | _GIPSCOMPOSITE_ | load_gips_composite | extract_gips_composite | ||
Entity Benchmark Assignment | _BENCHMARKASSIGNMENT_ | load_entity_benchmark_assignment | Only load object | ||
Entity Entitlement List | _ENTITYENTITLEMENTLIST_ | extract_entity_entitlement_list | Only extract object | ||
Entity Share Class | _ENTITYSHARECLASS_ | extract_entity_share_class | Only extract object | ||
RULE | Month End Date Rule | _MONTHENDDATERULE_ | load_rule_month_end_date | extract_rule_month_end_date | |
Earn Thru Rule | _EARNTHRURULE_ | load_rule_earn_thru | extract_rule_earn_thru | ||
Contractual Cash Settlement Rule | _CONTRACTUALCASHSETTLEMENTRULE_ | load_rule_contractual_cash_settlement | extract_rule_contractual_cash_settlement | ||
Contract Cash Rule | _CONTRACTCASHRULE_ | load_rule_contract_cash | extract_rule_contract_cash | ||
Basis Processing Rule | _BASISPROCESSINGRULE_ | load_rule_basis_processing | extract_rule_basis_processing | ||
Backup Withholding Rule | _BACKUPWITHHOLDINGRULE_ | load_rule_backup_withholding | extract_rule_backup_withholding | ||
Amortization Schedule Rule | _AMORTIZATIONSCHEDULERULE_ | load_rule_amortization_schedule | extract_rule_amortization_schedule | ||
Accounting Rule | _ACCOUNTINGRULE_ | load_rule_accounting | extract_rule_accounting | ||
Primary Mixed Cost Basis Rule | _PRIMARYMIXEDCOSTBASISRULE_ | load_rule_primary_mixed_cost_basis | extract_rule_primary_mixed_cost_basis | ||
Warehouse | Warehouse Open Lot | _WAREHOUSEOPENLOT_ | load_warehouse_openlot | ||
Warehouse Open Lot XMLDBAPI | _WAREHOUSEOPENLOTXMLDBAPI_ | load_warehouse_openlot_xmldbapi | extract_warehouse_openlot | ||
Warehouse Close Lot | _WAREHOUSECLOSELOT_ | load_warehouse_closelot | extract_warehouse_closelot | ||
Warehouse Position | _WAREHOUSEPOSITION_ | load_warehouse_position | |||
Warehouse Position XMLDBAPI | _WAREHOUSEPOSITIONXMLDBAPI_ | load_warehouse_position_xmldbapi | extract_warehouse_position | ||
Warehouse Trade | _WAREHOUSETRADE_ | load_warehouse_trade | extract_warehouse_trade | ||
Warehouse Trade Charges | _WAREHOUSETRADECHARGES_ | load_warehouse_trade_charges | Only load object | ||
Warehouse Cash Activity | _WAREHOUSECASHACTIVITY_ | load_warehouse_cash_activity | extract_warehouse_cash_activity | ||
Warehouse Performance | _WAREHOUSEPERFORMANCE_ | load_warehouse_performance | extract_warehouse_performance | ||
Warehouse GL Balances | _WAREHOUSEGLBALANCES_ | load_warehouse_glbalances | extract_warehouse_glbalances | ||
Warehouse NAV | _WAREHOUSENAV_ | load_warehouse_nav | extract_warehouse_nav | ||
Warehouse NAV Multi | _WAREHOUSENAVMULTI_ | load_warehouse_nav_multi | extract_warehouse_nav_multi | ||
Warehouse Pending Trade | _WAREHOUSEPENDINGTRADE_ | load_warehouse_pending_trade | extract_warehouse_pending_trade | ||
Warehouse Broker Trade Quote | _WAREHOUSEBROKERTRADEQUOTE_ | load_warehouse_broker_trade_quote | extract_warehouse_broker_trade_quote | ||
Warehouse Cash Flow Projection | _WAREHOUSECASHFLOWPROJECTION_ | load_warehouse_cash_flow_projection | extract_warehouse_cash_flow_projection | ||
Trade Quotes | _TRADEQUOTES_ | load_trade_quotes | extract_trade_quotes | ||
Warehouse Trade XREF | _WAREHOUSETRADEXREFERENCE_ | load_warehouse_trade_xreference | Only load object | ||
Custody Restriction Activity | _CUSTODYRESTRICTIONACTIVITY_ | extract_custody_restriction_activity | Only extract object | ||
Custody Restriction Balance | _CUSTODYRESTRICTIONBALANCE_ | extract_custody_restriction_balance | Only extract object | ||
Warehouse Insurance Valuation Lot | _INSURANCEVALUATIONLOT_ | extract_warehouse_istarlot | Only extract object | ||
ISSUER | Issuer MI | _ISSUERMI_ | load_issuer_mi | Only load object | |
Issuer | _ISSUER_ | load_issuer | extract_issuer | ||
Issuer Organization | _ISSUERORGANIZATION_ | load_issuer_organization | extract_issuer_organization | ||
Issuer Role | _ISSUERROLE_ | load_issuer_role | extract_issuer_role | ||
Issuer Relationship | _ISSUERRELATIONSHIP_ | load_issuer_relationship | extract_issuer_relationship | ||
Issuer Rating | _ISSUERRATING_ | extract_issuer_rating | |||
Role Model | _ROLEMODEL_ | load_issuer_role_model | Only load object | ||
Issuer Xref | _ISSUERXREF_ | load_issuer_xref | Only load object | ||
System | Code Value | _CODEVALUE_ | load_code_value | extract_code_value | |
Code Category | _CODECATEGORY_ | load_code_category | extract_code_category | ||
Code Translation | _CODETRANSLATION_ | load_code_translation | extract_code_translation | ||
Calendar | _CALENDAR_ | load_calendar | extract_calendar | ||
Calendar Holiday | _CALENDARHOLIDAY_ | load_calendar_holiday | extract_calendar_holiday | ||
Calendar Business Dates | _CALENDARBUSINESSDATES_ | extract_calendar_business_dates | Only extract object | ||
Error Definition | _ERRORDEFINITION_ | load_error_definition | extract_error_definition | ||
Yield Curve | _YIELDCURVE_ | load_yield_curve | extract_yield_curve | ||
Run Time Stamps | _RUNTIMESTAMPS_ | extract_run_time_stamps | Only extract object | ||
Ledger Notes | _LEDGERNOTES_ | load_ledger_notes | extract_ledger_notes | ||
Security Related | Issue Analytic | _ISSUEANALYTIC_ | load_issue_analytic | Only load object | |
Issue Fx Rate | _ISSUEFXRATE_ | load_issue_fx_rate | extract_issue_fx_rate | ||
Issue Pc Price | _ISSUEPCPRICE_ | load_issue_pc_price | Only load object | ||
Issue Price | _ISSUEPRICE_ | load_issue_price | extract_issue_price | ||
Issue Variable Rate | _ISSUEVARIABLERATE_ | load_issue_variable_rate | extract_issue_variable_rate | ||
Issue Fx Pc Rate | _ISSUEFXPCRATE_ | load_issue_fx_pc_rate | extract_issue_fx_pc_rate | ||
Generic Issue Analytic | _GENERICISSUEANALYTIC_ | load_generic_issue_analytic | extract_generic_issue_analytic | ||
Exchange Price | _EXCHANGEPRICE_ | load_exchange_price | extract_issue_exchange_price | ||
Schedule | _SCHEDULE_ | load_schedule | extract_schedule | ||
Rating | _RATING_ | load_rating | extract_rating | ||
Vendor Cash Flow | _VENDORCASHFLOW_ | load_vendor_cash_flow | Only load object | ||
Security Notes | _SECURITYNOTES_ | load_security_notes | Only load object | ||
Factor | _FACTOR_ | load_factor | extract_factor | ||
Model Price | _MODELPRICE_ | load_model_price | Only load object | ||
SMF Identifiers | _SMFIDENTIFIERS_ | load_smfidentifiers | extract_smfidentifiers | In development / modification | |
Time Series | _TIMESERIES_ | load_time_series | extract_time_series | ||
SMF Identifier | _SMFIDENTIFIER_ | load_smf_identifier | |||
Underlying SMF | _UNDERLYINGSMF_ | load_underlying_smf | Only load object | ||
Recovery Rate | _RECOVERYRATE_ | load_recovery_rate | Only load object | ||
Earnings Time Period Model | _EARNINGSTIMEPERIODMODEL_ | load_earnings_time_period_model | Only load object | ||
Forward Points | _FORWARDPOINTS_ | extract_forward_points | Only extract object | ||
Security Overrides | _SECURITYOVERRIDES_ | extract_security_overrides | Only extract object | ||
NAIC Designation | _NAICDESIGNATION_ | extract_naic_designation | Only extract object | ||
Client | Client | _CLIENT_ | load_client | extract_client | |
Client Communication | _CLIENTCOMMUNICATION_ | load_client_communication | extract_client_communication | ||
Corporate Action | GenericCA | _GENERICCA_ | load_generic_ca | extract_generic_ca | |
VoluntaryCAElection | _VOLUNTARYCAELECTION_ | load_voluntary_ca_election | extract_voluntary_ca_election | ||
MandatoryCAExclusion | _MANDATORYCAEXCLUSION_ | load_mandatory_ca_exclusion | Only load object | ||
Financial Event | Financial Event | _FINANCIALEVENT_ | extract_financial_event | Only extract object | |
Accounting | Cost Basis Adjustment | _COSTBASISADJUSTMENT_ | load_accounting_cost_basis_adjustment | Only load object | |
Accounting Trade | _ACCOUNTINGTRADE_ | load_accounting_trade | extract_accounting_trade | ||
Accounting Cash | _ACCOUNTINGCASH_ | load_accounting_cash | Only load object | ||
Accounting Asset Cash | _ACCOUNTINGASSETCASH_ | load_accounting_asset_cash | Only load object | ||
Accounting Reclaim Cash | _ACCOUNTINGRECLAIMCASH_ | load_accounting_reclaim_cash | Only load object | ||
Multiple Leg Accounting Trade | _MULTIPLELEGACCOUNTINGTRADE_ | load_accounting_trade_multi_leg | Only load object | ||
Impairments | _IMPAIRMENTS_ | load_accounting_impairments | Only load object | ||
(available in NOV 2015 release) | |||||
Accrued Income | _ACCRUEDINCOME_ | extract_accounting_accrued_income | Only extract object | ||
Subscribe Reedem | _SUBSCRIBEREEDEM_ | extract_accounting_subscribe_reedem | Only extract object | ||
Daily Yield Mill Rate | _DAILYYIELDMILLRATE_ | extract_accounting_daily_mill_rate | Only extract object | ||
Unsettled Transactions | _UNSETTLEDTRANSACTIONS_ | extract_accounting_unsettled_trans | Only extract object | ||
Cash Journal | _CASHJOURNAL_ | extract_accounting_cash_journal | Only extract object | ||
Realized Gain Loss | _REALIZEDGAINLOSS_ | extract_accounting_realized_gl | Only extract object | ||
Settled Cash Activity | _SETTLEDCA_ | extract_accounting_settled_ca | Only extract object | ||
Consolidated Earned Income | _CONSEARNEDINCOME_ | extract_accounting_cons_earned_income | Only extract object | ||
General Ledger Activity | _GENERALLEDGERACTIVITY_ | extract_accounting_gl_activity | Only extract object | ||
Traded Cash Activity | _TRADEDCASHACTIVITY_ | extract_accounting_traded_cash_activity | Only extract object | ||
Distribution Activity | _DISTRIBUTIONACT_ | extract_accounting_distribution_activity | Only extract object | ||
Cash Projections | _CASHPROJECTIONS_ | extract_cash_projections | Only extract object | ||
Custom Ledger Account | _CUSTLEDGERACCT_ | extract_accounting_custom_ledger_acct | Only extract object | ||
Open Rec Pay Multi | _OPENRECPAYMULTI_ | extract_accounting_open_rec_pay_multi | Only extract object | ||
Unapproved Variation Margin | _UNAPPROVEDVARMARGIN_ | extract_accounting_unapproved_var_margin | Only extract object | ||
Trial Balance | _TRIALBALANCEEXTRACT_ | extract_accounting_trial_balance | Only extract object | ||
Accounting Intraday NAV | _INTRADAYNAV_ | extract_accounting_intraday_nav | Only extract object | ||
Accounting NAV for NASDAQ | _NAVFORNASDAQ_ | extract_accounting_nav_for_nasdaq | Only extract object | ||
Accounting Fair Value Comparison | _FAIRVALUECOMPARISON_ | extract_accounting_fair_value_comparison | Only extract object |
2
You can extract and load data via the following Eagle-provided sample IWS workflow solutions:
Note: The Extract/Load File Name Pattern column contains patterns that must be used in names of files to be loaded via the generic_load. The same pattern is applied to extract file names.
For example, if you perform an Entity List extract, a file with the name GEN_EXTRACT_150901110525_ENTITYLIST_246.xml is created. At the same time, to load an Entity List file to the database correctly, the file name must contain the _ENTITYLIST_ pattern.
The following table summarizes the status of the currently supported EagleML types and the associated load and extract process names.
1
Sub Group | Supported EagleML Type | Extract/Load File Name Pattern | Load Process Name | Extract Process Name | Comments/Status |
SMF | Generic SMF | _GENERICSMF_ | load_generic_smf | extract_generic_smf | |
Generic SMF MI | _GENERICSMFMI_ | load_generic_smf_mi | Only load object | ||
Multiple Leg SMF | _MULTILEGSMF_ | load_generic_multi_leg_smf | Only load object | ||
ENTITY | Entity List | _ENTITYLIST_ | load_entity_list | extract_entity_list | |
Entity To List | _ENTITYTOLIST_ | load_entity_to_list | Only load object | ||
Entities In List | _ENTITIESINLIST_ | load_entities_in_list | extract_entities_in_list | In development/modification | |
Entity Composite | _ENTITYCOMPOSITE_ | load_entity_composite | extract_entity_composite | ||
Entity To Composite | _ENTITYTOCOMPOSITE_ | load_entity_to_composite | Only load object | ||
Composite Entity List | _COMPOSITEENTITYLIST_ | load_entities_in_composite | extract_entities_in_composite | In development/modification | |
Entity Bank Relationship | _ENTITYBANKRELATIONSHIP_ | load_entity_bank_relationship | extract_entity_bank_relationship | ||
Entity Accounting Basis | _ENTITYACCOUNTINGBASIS_ | load_entity_accounting_basis | extract_entity_accounting_basis | ||
Entity XREF | _ENTITYXREF_ | load_entity_xref | |||
Generic Entity | _GENERICENTITY_ | load_generic_entity | extract_generic_entity | ||
Entity Manager | _ENTITYMANAGER_ | load_entity_manager | extract_entity_manager | ||
Entity Manager Relationship | _ENTITYMANAGERRELATIONSHIP_ | load_entity_manager_relationship | extract_entity_manager_relationship | ||
Entity Identifiers | _ENTITYIDENTIFIERS_ | load_entity_identifiers | extract_entity_identifiers | In development/modification | |
Entity Accounting Periods | _ENTITYACCOUNTINGPERIODS_ | load_entity_accounting_periods | extract_entity_accounting_periods | ||
GIPS Disclosures | _GIPSDISCLOSURES_ | load_gips_disclosures | extract_gips_disclosures | ||
GIPS Composite | _GIPSCOMPOSITE_ | load_gips_composite | extract_gips_composite | ||
Entity Benchmark Assignment | _BENCHMARKASSIGNMENT_ | load_entity_benchmark_assignment | Only load object | ||
Entity Entitlement List | _ENTITYENTITLEMENTLIST_ | extract_entity_entitlement_list | Only extract object | ||
Entity Share Class | _ENTITYSHARECLASS_ | extract_entity_share_class | Only extract object | ||
RULE | Month End Date Rule | _MONTHENDDATERULE_ | load_rule_month_end_date | extract_rule_month_end_date | |
Earn Thru Rule | _EARNTHRURULE_ | load_rule_earn_thru | extract_rule_earn_thru | ||
Contractual Cash Settlement Rule | _CONTRACTUALCASHSETTLEMENTRULE_ | load_rule_contractual_cash_settlement | extract_rule_contractual_cash_settlement | ||
Contract Cash Rule | _CONTRACTCASHRULE_ | load_rule_contract_cash | extract_rule_contract_cash | ||
Basis Processing Rule | _BASISPROCESSINGRULE_ | load_rule_basis_processing | extract_rule_basis_processing | ||
Backup Withholding Rule | _BACKUPWITHHOLDINGRULE_ | load_rule_backup_withholding | extract_rule_backup_withholding | ||
Amortization Schedule Rule | _AMORTIZATIONSCHEDULERULE_ | load_rule_amortization_schedule | extract_rule_amortization_schedule | ||
Accounting Rule | _ACCOUNTINGRULE_ | load_rule_accounting | extract_rule_accounting | ||
Primary Mixed Cost Basis Rule | _PRIMARYMIXEDCOSTBASISRULE_ | load_rule_primary_mixed_cost_basis | extract_rule_primary_mixed_cost_basis | ||
Warehouse | Warehouse Open Lot | _WAREHOUSEOPENLOT_ | load_warehouse_openlot | ||
Warehouse Open Lot XMLDBAPI | _WAREHOUSEOPENLOTXMLDBAPI_ | load_warehouse_openlot_xmldbapi | extract_warehouse_openlot | ||
Warehouse Close Lot | _WAREHOUSECLOSELOT_ | load_warehouse_closelot | extract_warehouse_closelot | ||
Warehouse Position | _WAREHOUSEPOSITION_ | load_warehouse_position | |||
Warehouse Position XMLDBAPI | _WAREHOUSEPOSITIONXMLDBAPI_ | load_warehouse_position_xmldbapi | extract_warehouse_position | ||
Warehouse Trade | _WAREHOUSETRADE_ | load_warehouse_trade | extract_warehouse_trade | ||
Warehouse Trade Charges | _WAREHOUSETRADECHARGES_ | load_warehouse_trade_charges | Only load object | ||
Warehouse Cash Activity | _WAREHOUSECASHACTIVITY_ | load_warehouse_cash_activity | extract_warehouse_cash_activity | ||
Warehouse Performance | _WAREHOUSEPERFORMANCE_ | load_warehouse_performance | extract_warehouse_performance | ||
Warehouse GL Balances | _WAREHOUSEGLBALANCES_ | load_warehouse_glbalances | extract_warehouse_glbalances | ||
Warehouse NAV | _WAREHOUSENAV_ | load_warehouse_nav | extract_warehouse_nav | ||
Warehouse NAV Multi | _WAREHOUSENAVMULTI_ | load_warehouse_nav_multi | extract_warehouse_nav_multi | ||
Warehouse Pending Trade | _WAREHOUSEPENDINGTRADE_ | load_warehouse_pending_trade | extract_warehouse_pending_trade | ||
Warehouse Broker Trade Quote | _WAREHOUSEBROKERTRADEQUOTE_ | load_warehouse_broker_trade_quote | extract_warehouse_broker_trade_quote | ||
Warehouse Cash Flow Projection | _WAREHOUSECASHFLOWPROJECTION_ | load_warehouse_cash_flow_projection | extract_warehouse_cash_flow_projection | ||
Trade Quotes | _TRADEQUOTES_ | load_trade_quotes | extract_trade_quotes | ||
Warehouse Trade XREF | _WAREHOUSETRADEXREFERENCE_ | load_warehouse_trade_xreference | Only load object | ||
Custody Restriction Activity | _CUSTODYRESTRICTIONACTIVITY_ | extract_custody_restriction_activity | Only extract object | ||
Custody Restriction Balance | _CUSTODYRESTRICTIONBALANCE_ | extract_custody_restriction_balance | Only extract object | ||
Warehouse Insurance Valuation Lot | _INSURANCEVALUATIONLOT_ | extract_warehouse_istarlot | Only extract object | ||
ISSUER | Issuer MI | _ISSUERMI_ | load_issuer_mi | Only load object | |
Issuer | _ISSUER_ | load_issuer | extract_issuer | ||
Issuer Organization | _ISSUERORGANIZATION_ | load_issuer_organization | extract_issuer_organization | ||
Issuer Role | _ISSUERROLE_ | load_issuer_role | extract_issuer_role | ||
Issuer Relationship | _ISSUERRELATIONSHIP_ | load_issuer_relationship | extract_issuer_relationship | ||
Issuer Rating | _ISSUERRATING_ | extract_issuer_rating | |||
Role Model | _ROLEMODEL_ | load_issuer_role_model | Only load object | ||
Issuer Xref | _ISSUERXREF_ | load_issuer_xref | Only load object | ||
System | Code Value | _CODEVALUE_ | load_code_value | extract_code_value | |
Code Category | _CODECATEGORY_ | load_code_category | extract_code_category | ||
Code Translation | _CODETRANSLATION_ | load_code_translation | extract_code_translation | ||
Calendar | _CALENDAR_ | load_calendar | extract_calendar | ||
Calendar Holiday | _CALENDARHOLIDAY_ | load_calendar_holiday | extract_calendar_holiday | ||
Calendar Business Dates | _CALENDARBUSINESSDATES_ | extract_calendar_business_dates | Only extract object | ||
Error Definition | _ERRORDEFINITION_ | load_error_definition | extract_error_definition | ||
Yield Curve | _YIELDCURVE_ | load_yield_curve | extract_yield_curve | ||
Run Time Stamps | _RUNTIMESTAMPS_ | extract_run_time_stamps | Only extract object | ||
Ledger Notes | _LEDGERNOTES_ | load_ledger_notes | extract_ledger_notes | ||
Security Related | Issue Analytic | _ISSUEANALYTIC_ | load_issue_analytic | Only load object | |
Issue Fx Rate | _ISSUEFXRATE_ | load_issue_fx_rate | extract_issue_fx_rate | ||
Issue Pc Price | _ISSUEPCPRICE_ | load_issue_pc_price | Only load object | ||
Issue Price | _ISSUEPRICE_ | load_issue_price | extract_issue_price | ||
Issue Variable Rate | _ISSUEVARIABLERATE_ | load_issue_variable_rate | extract_issue_variable_rate | ||
Issue Fx Pc Rate | _ISSUEFXPCRATE_ | load_issue_fx_pc_rate | extract_issue_fx_pc_rate | ||
Generic Issue Analytic | _GENERICISSUEANALYTIC_ | load_generic_issue_analytic | extract_generic_issue_analytic | ||
Exchange Price | _EXCHANGEPRICE_ | load_exchange_price | extract_issue_exchange_price | ||
Schedule | _SCHEDULE_ | load_schedule | extract_schedule | ||
Rating | _RATING_ | load_rating | extract_rating | ||
Vendor Cash Flow | _VENDORCASHFLOW_ | load_vendor_cash_flow | Only load object | ||
Security Notes | _SECURITYNOTES_ | load_security_notes | Only load object | ||
Factor | _FACTOR_ | load_factor | extract_factor | ||
Model Price | _MODELPRICE_ | load_model_price | Only load object | ||
SMF Identifiers | _SMFIDENTIFIERS_ | load_smfidentifiers | extract_smfidentifiers | In development/modification | |
Time Series | _TIMESERIES_ | load_time_series | extract_time_series | ||
SMF Identifier | _SMFIDENTIFIER_ | load_smf_identifier | |||
Underlying SMF | _UNDERLYINGSMF_ | load_underlying_smf | Only load object | ||
Recovery Rate | _RECOVERYRATE_ | load_recovery_rate | Only load object | ||
Earnings Time Period Model | _EARNINGSTIMEPERIODMODEL_ | load_earnings_time_period_model | Only load object | ||
Forward Points | _FORWARDPOINTS_ | extract_forward_points | Only extract object | ||
Security Overrides | _SECURITYOVERRIDES_ | extract_security_overrides | Only extract object | ||
NAIC Designation | _NAICDESIGNATION_ | extract_naic_designation | Only extract object | ||
Client | Client | _CLIENT_ | load_client | extract_client | |
Client Communication | _CLIENTCOMMUNICATION_ | load_client_communication | extract_client_communication | ||
Corporate Action | GenericCA | _GENERICCA_ | load_generic_ca | extract_generic_ca | |
VoluntaryCAElection | _VOLUNTARYCAELECTION_ | load_voluntary_ca_election | extract_voluntary_ca_election | ||
MandatoryCAExclusion | _MANDATORYCAEXCLUSION_ | load_mandatory_ca_exclusion | Only load object | ||
Financial Event | Financial Event | _FINANCIALEVENT_ | extract_financial_event | Only extract object | |
Accounting | Cost Basis Adjustment | _COSTBASISADJUSTMENT_ | load_accounting_cost_basis_adjustment | Only load object | |
Accounting Trade | _ACCOUNTINGTRADE_ | load_accounting_trade | extract_accounting_trade | ||
Accounting Cash | _ACCOUNTINGCASH_ | load_accounting_cash | Only load object | ||
Accounting Asset Cash | _ACCOUNTINGASSETCASH_ | load_accounting_asset_cash | Only load object | ||
Accounting Reclaim Cash | _ACCOUNTINGRECLAIMCASH_ | load_accounting_reclaim_cash | Only load object | ||
Multiple Leg Accounting Trade | _MULTIPLELEGACCOUNTINGTRADE_ | load_accounting_trade_multi_leg | Only load object | ||
Impairments | _IMPAIRMENTS_ | load_accounting_impairments | Only load object | ||
(available in NOV2015 release) | |||||
Accrued Income | _ACCRUEDINCOME_ | extract_accounting_accrued_income | Only extract object | ||
Subscribe Reedem | _SUBSCRIBEREEDEM_ | extract_accounting_subscribe_reedem | Only extract object | ||
Daily Yield Mill Rate | _DAILYYIELDMILLRATE_ | extract_accounting_daily_mill_rate | Only extract object | ||
Unsettled Transactions | _UNSETTLEDTRANSACTIONS_ | extract_accounting_unsettled_trans | Only extract object | ||
Cash Journal | _CASHJOURNAL_ | extract_accounting_cash_journal | Only extract object | ||
Realized Gain Loss | _REALIZEDGAINLOSS_ | extract_accounting_realized_gl | Only extract object | ||
Settled Cash Activity | _SETTLEDCA_ | extract_accounting_settled_ca | Only extract object | ||
Consolidated Earned Income | _CONSEARNEDINCOME_ | extract_accounting_cons_earned_income | Only extract object | ||
General Ledger Activity | _GENERALLEDGERACTIVITY_ | extract_accounting_gl_activity | Only extract object | ||
Traded Cash Activity | _TRADEDCASHACTIVITY_ | extract_accounting_traded_cash_activity | Only extract object | ||
Distribution Activity | _DISTRIBUTIONACT_ | extract_accounting_distribution_activity | Only extract object | ||
Cash Projections | _CASHPROJECTIONS_ | extract_cash_projections | Only extract object | ||
Custom Ledger Account | _CUSTLEDGERACCT_ | extract_accounting_custom_ledger_acct | Only extract object | ||
Open Rec Pay Multi | _OPENRECPAYMULTI_ | extract_accounting_open_rec_pay_multi | Only extract object | ||
Unapproved Variation Margin | _UNAPPROVEDVARMARGIN_ | extract_accounting_unapproved_var_margin | Only extract object | ||
Trial Balance | _TRIALBALANCEEXTRACT_ | extract_accounting_trial_balance | Only extract object | ||
Accounting Intraday NAV | _INTRADAYNAV_ | extract_accounting_intraday_nav | Only extract object | ||
Accounting NAV for NASDAQ | _NAVFORNASDAQ_ | extract_accounting_nav_for_nasdaq | Only extract object | ||
Accounting Fair Value Comparison | _FAIRVALUECOMPARISON_ | extract_accounting_fair_value_comparison | Only extract object |
2
Sub Group | Supported EagleML Type | Extract/Load File Name Pattern | Load Process Name | Extract Process Name | Comments/Status |
---|---|---|---|---|---|
SMF | Generic SMF | _GENERICSMF_ | load_generic_smf | extract_generic_smf | |
Generic SMF MI | _GENERICSMFMI_ | load_generic_smf_mi | Only load object | ||
Multiple Leg SMF | _MULTILEGSMF_ | load_generic_multi_leg_smf | Only load object | ||
ENTITY | Entity List | _ENTITYLIST_ | load_entity_list | extract_entity_list | |
Entity To List | _ENTITYTOLIST_ | load_entity_to_list | Only load object | ||
Entities In List | _ENTITIESINLIST_ | load_entities_in_list | extract_entities_in_list | In development/modification | |
Entity Composite | _ENTITYCOMPOSITE_ | load_entity_composite | extract_entity_composite | ||
Entity To Composite | _ENTITYTOCOMPOSITE_ | load_entity_to_composite | Only load object | ||
Composite Entity List | _COMPOSITEENTITYLIST_ | load_entities_in_composite | extract_entities_in_composite | In development/modification | |
Entity Bank Relationship | _ENTITYBANKRELATIONSHIP_ | load_entity_bank_relationship | extract_entity_bank_relationship | ||
Entity Accounting Basis | _ENTITYACCOUNTINGBASIS_ | load_entity_accounting_basis | extract_entity_accounting_basis | ||
Entity XREF | _ENTITYXREF_ | load_entity_xref | |||
Generic Entity | _GENERICENTITY_ | load_generic_entity | extract_generic_entity | ||
Entity Manager | _ENTITYMANAGER_ | load_entity_manager | extract_entity_manager | ||
Entity Manager Relationship | _ENTITYMANAGERRELATIONSHIP_ | load_entity_manager_relationship | extract_entity_manager_relationship | ||
Entity Identifiers | _ENTITYIDENTIFIERS_ | load_entity_identifiers | extract_entity_identifiers | In development/modification | |
Entity Accounting Periods | _ENTITYACCOUNTINGPERIODS_ | load_entity_accounting_periods | extract_entity_accounting_periods | ||
GIPS Disclosures | _GIPSDISCLOSURES_ | load_gips_disclosures | extract_gips_disclosures | ||
GIPS Composite | _GIPSCOMPOSITE_ | load_gips_composite | extract_gips_composite | ||
Entity Benchmark Assignment | _BENCHMARKASSIGNMENT_ | load_entity_benchmark_assignment | Only load object | ||
Entity Entitlement List | _ENTITYENTITLEMENTLIST_ | extract_entity_entitlement_list | Only extract object | ||
Entity Share Class | _ENTITYSHARECLASS_ | extract_entity_share_class | Only extract object | ||
RULE | Month End Date Rule | _MONTHENDDATERULE_ | load_rule_month_end_date | extract_rule_month_end_date | |
Earn Thru Rule | _EARNTHRURULE_ | load_rule_earn_thru | extract_rule_earn_thru | ||
Contractual Cash Settlement Rule | _CONTRACTUALCASHSETTLEMENTRULE_ | load_rule_contractual_cash_settlement | extract_rule_contractual_cash_settlement | ||
Contract Cash Rule | _CONTRACTCASHRULE_ | load_rule_contract_cash | extract_rule_contract_cash | ||
Basis Processing Rule | _BASISPROCESSINGRULE_ | load_rule_basis_processing | extract_rule_basis_processing | ||
Backup Withholding Rule | _BACKUPWITHHOLDINGRULE_ | load_rule_backup_withholding | extract_rule_backup_withholding | ||
Amortization Schedule Rule | _AMORTIZATIONSCHEDULERULE_ | load_rule_amortization_schedule | extract_rule_amortization_schedule | ||
Accounting Rule | _ACCOUNTINGRULE_ | load_rule_accounting | extract_rule_accounting | ||
Primary Mixed Cost Basis Rule | _PRIMARYMIXEDCOSTBASISRULE_ | load_rule_primary_mixed_cost_basis | extract_rule_primary_mixed_cost_basis | ||
Warehouse | Warehouse Open Lot | _WAREHOUSEOPENLOT_ | load_warehouse_openlot | ||
Warehouse Open Lot XMLDBAPI | _WAREHOUSEOPENLOTXMLDBAPI_ | load_warehouse_openlot_xmldbapi | extract_warehouse_openlot | ||
Warehouse Close Lot | _WAREHOUSECLOSELOT_ | load_warehouse_closelot | extract_warehouse_closelot | ||
Warehouse Position | _WAREHOUSEPOSITION_ | load_warehouse_position | |||
Warehouse Position XMLDBAPI | _WAREHOUSEPOSITIONXMLDBAPI_ | load_warehouse_position_xmldbapi | extract_warehouse_position | ||
Warehouse Trade | _WAREHOUSETRADE_ | load_warehouse_trade | extract_warehouse_trade | ||
Warehouse Trade Charges | _WAREHOUSETRADECHARGES_ | load_warehouse_trade_charges | Only load object | ||
Warehouse Cash Activity | _WAREHOUSECASHACTIVITY_ | load_warehouse_cash_activity | extract_warehouse_cash_activity | ||
Warehouse Performance | _WAREHOUSEPERFORMANCE_ | load_warehouse_performance | extract_warehouse_performance | ||
Warehouse GL Balances | _WAREHOUSEGLBALANCES_ | load_warehouse_glbalances | extract_warehouse_glbalances | ||
Warehouse NAV | _WAREHOUSENAV_ | load_warehouse_nav | extract_warehouse_nav | ||
Warehouse NAV Multi | _WAREHOUSENAVMULTI_ | load_warehouse_nav_multi | extract_warehouse_nav_multi | ||
Warehouse Pending Trade | _WAREHOUSEPENDINGTRADE_ | load_warehouse_pending_trade | extract_warehouse_pending_trade | ||
Warehouse Broker Trade Quote | _WAREHOUSEBROKERTRADEQUOTE_ | load_warehouse_broker_trade_quote | extract_warehouse_broker_trade_quote | ||
Warehouse Cash Flow Projection | _WAREHOUSECASHFLOWPROJECTION_ | load_warehouse_cash_flow_projection | extract_warehouse_cash_flow_projection | ||
Trade Quotes | _TRADEQUOTES_ | load_trade_quotes | extract_trade_quotes | ||
Warehouse Trade XREF | _WAREHOUSETRADEXREFERENCE_ | load_warehouse_trade_xreference | Only load object | ||
Custody Restriction Activity | _CUSTODYRESTRICTIONACTIVITY_ | extract_custody_restriction_activity | Only extract object | ||
Custody Restriction Balance | _CUSTODYRESTRICTIONBALANCE_ | extract_custody_restriction_balance | Only extract object | ||
Warehouse Insurance Valuation Lot | _INSURANCEVALUATIONLOT_ | extract_warehouse_istarlot | Only extract object | ||
ISSUER | Issuer MI | _ISSUERMI_ | load_issuer_mi | Only load object | |
Issuer | _ISSUER_ | load_issuer | extract_issuer | ||
Issuer Organization | _ISSUERORGANIZATION_ | load_issuer_organization | extract_issuer_organization | ||
Issuer Role | _ISSUERROLE_ | load_issuer_role | extract_issuer_role | ||
Issuer Relationship | _ISSUERRELATIONSHIP_ | load_issuer_relationship | extract_issuer_relationship | ||
Issuer Rating | _ISSUERRATING_ | extract_issuer_rating | |||
Role Model | _ROLEMODEL_ | load_issuer_role_model | Only load object | ||
Issuer Xref | _ISSUERXREF_ | load_issuer_xref | Only load object | ||
System | Code Value | _CODEVALUE_ | load_code_value | extract_code_value | |
Code Category | _CODECATEGORY_ | load_code_category | extract_code_category | ||
Code Translation | _CODETRANSLATION_ | load_code_translation | extract_code_translation | ||
Calendar | _CALENDAR_ | load_calendar | extract_calendar | ||
Calendar Holiday | _CALENDARHOLIDAY_ | load_calendar_holiday | extract_calendar_holiday | ||
Calendar Business Dates | _CALENDARBUSINESSDATES_ | extract_calendar_business_dates | Only extract object | ||
Error Definition | _ERRORDEFINITION_ | load_error_definition | extract_error_definition | ||
Yield Curve | _YIELDCURVE_ | load_yield_curve | extract_yield_curve | ||
Run Time Stamps | _RUNTIMESTAMPS_ | extract_run_time_stamps | Only extract object | ||
Ledger Notes | _LEDGERNOTES_ | load_ledger_notes | extract_ledger_notes | ||
Security Related | Issue Analytic | _ISSUEANALYTIC_ | load_issue_analytic | Only load object | |
Issue Fx Rate | _ISSUEFXRATE_ | load_issue_fx_rate | extract_issue_fx_rate | ||
Issue Pc Price | _ISSUEPCPRICE_ | load_issue_pc_price | Only load object | ||
Issue Price | _ISSUEPRICE_ | load_issue_price | extract_issue_price | ||
Issue Variable Rate | _ISSUEVARIABLERATE_ | load_issue_variable_rate | extract_issue_variable_rate | ||
Issue Fx Pc Rate | _ISSUEFXPCRATE_ | load_issue_fx_pc_rate | extract_issue_fx_pc_rate | ||
Generic Issue Analytic | _GENERICISSUEANALYTIC_ | load_generic_issue_analytic | extract_generic_issue_analytic | ||
Exchange Price | _EXCHANGEPRICE_ | load_exchange_price | extract_issue_exchange_price | ||
Schedule | _SCHEDULE_ | load_schedule | extract_schedule | ||
Rating | _RATING_ | load_rating | extract_rating | ||
Vendor Cash Flow | _VENDORCASHFLOW_ | load_vendor_cash_flow | Only load object | ||
Security Notes | _SECURITYNOTES_ | load_security_notes | Only load object | ||
Factor | _FACTOR_ | load_factor | extract_factor | ||
Model Price | _MODELPRICE_ | load_model_price | Only load object | ||
SMF Identifiers | _SMFIDENTIFIERS_ | load_smfidentifiers | extract_smfidentifiers | In development/modification | |
Time Series | _TIMESERIES_ | load_time_series | extract_time_series | ||
SMF Identifier | _SMFIDENTIFIER_ | load_smf_identifier | |||
Underlying SMF | _UNDERLYINGSMF_ | load_underlying_smf | Only load object | ||
Recovery Rate | _RECOVERYRATE_ | load_recovery_rate | Only load object | ||
Earnings Time Period Model | _EARNINGSTIMEPERIODMODEL_ | load_earnings_time_period_model | Only load object | ||
Forward Points | _FORWARDPOINTS_ | extract_forward_points | Only extract object | ||
Security Overrides | _SECURITYOVERRIDES_ | extract_security_overrides | Only extract object | ||
NAIC Designation | _NAICDESIGNATION_ | extract_naic_designation | Only extract object | ||
Client | Client | _CLIENT_ | load_client | extract_client | |
Client Communication | _CLIENTCOMMUNICATION_ | load_client_communication | extract_client_communication | ||
Corporate Action | GenericCA | _GENERICCA_ | load_generic_ca | extract_generic_ca | |
VoluntaryCAElection | _VOLUNTARYCAELECTION_ | load_voluntary_ca_election | extract_voluntary_ca_election | ||
MandatoryCAExclusion | _MANDATORYCAEXCLUSION_ | load_mandatory_ca_exclusion | Only load object | ||
Financial Event | Financial Event | _FINANCIALEVENT_ | extract_financial_event | Only extract object | |
Accounting | Cost Basis Adjustment | _COSTBASISADJUSTMENT_ | load_accounting_cost_basis_adjustment | Only load object | |
Accounting Trade | _ACCOUNTINGTRADE_ | load_accounting_trade | extract_accounting_trade | ||
Accounting Cash | _ACCOUNTINGCASH_ | load_accounting_cash | Only load object | ||
Accounting Asset Cash | _ACCOUNTINGASSETCASH_ | load_accounting_asset_cash | Only load object | ||
Accounting Reclaim Cash | _ACCOUNTINGRECLAIMCASH_ | load_accounting_reclaim_cash | Only load object | ||
Multiple Leg Accounting Trade | _MULTIPLELEGACCOUNTINGTRADE_ | load_accounting_trade_multi_leg | Only load object | ||
Impairments | _IMPAIRMENTS_ | load_accounting_impairments | Only load object | ||
(available in NOV2015 release) | |||||
Accrued Income | _ACCRUEDINCOME_ | extract_accounting_accrued_income | Only extract object | ||
Subscribe Reedem | _SUBSCRIBEREEDEM_ | extract_accounting_subscribe_reedem | Only extract object | ||
Daily Yield Mill Rate | _DAILYYIELDMILLRATE_ | extract_accounting_daily_mill_rate | Only extract object | ||
Unsettled Transactions | _UNSETTLEDTRANSACTIONS_ | extract_accounting_unsettled_trans | Only extract object | ||
Cash Journal | _CASHJOURNAL_ | extract_accounting_cash_journal | Only extract object | ||
Realized Gain Loss | _REALIZEDGAINLOSS_ | extract_accounting_realized_gl | Only extract object | ||
Settled Cash Activity | _SETTLEDCA_ | extract_accounting_settled_ca | Only extract object | ||
Consolidated Earned Income | _CONSEARNEDINCOME_ | extract_accounting_cons_earned_income | Only extract object | ||
General Ledger Activity | _GENERALLEDGERACTIVITY_ | extract_accounting_gl_activity | Only extract object | ||
Traded Cash Activity | _TRADEDCASHACTIVITY_ | extract_accounting_traded_cash_activity | Only extract object | ||
Distribution Activity | _DISTRIBUTIONACT_ | extract_accounting_distribution_activity | Only extract object | ||
Cash Projections | _CASHPROJECTIONS_ | extract_cash_projections | Only extract object | ||
Custom Ledger Account | _CUSTLEDGERACCT_ | extract_accounting_custom_ledger_acct | Only extract object | ||
Open Rec Pay Multi | _OPENRECPAYMULTI_ | extract_accounting_open_rec_pay_multi | Only extract object | ||
Unapproved Variation Margin | _UNAPPROVEDVARMARGIN_ | extract_accounting_unapproved_var_margin | Only extract object | ||
Trial Balance | _TRIALBALANCEEXTRACT_ | extract_accounting_trial_balance | Only extract object | ||
Accounting Intraday NAV | _INTRADAYNAV_ | extract_accounting_intraday_nav | Only extract object | ||
Accounting NAV for NASDAQ | _NAVFORNASDAQ_ | extract_accounting_nav_for_nasdaq | Only extract object | ||
Accounting Fair Value Comparison | _FAIRVALUECOMPARISON_ | extract_accounting_fair_value_comparison | Only extract object |
Add Comment