About EagleML Filters

The Control Message file contains filter parameters. All these parameters are located in Task parameters section. Apart from the parameters you can set in the Control Message for a particular extract, there is an option to define global parameters influencing all processes in an environment, including extracts.

Filter parameters define a range of data which is going to be extracted from the Database tables for each object. The list of objects and corresponding filter parameters are described below.

Eagle also maintains a list of available EagleML filters.

For example, the value of parameter “updatedate” follows.

<taskParameter>       <name>updatedate</name>       <dataType>S</dataType>       <value>2013-06-25 15-00-00</value> </taskParameter>

All parameter names are case-sensitive.

Cross-Reference of Objects and Filters

All filters can be divided into groups: Common, Date, Entity, Held, Smf, Sources, Delta Based, Issuer and Own filters. “Own” filters are implemented within the rules of an object and are usually specific for the object. All other filters are implemented in the include files located in the folder /eagle_ml-2-0_cm and are shared between several EagleML objects, as follows.

Filter

Include Filename

Filter

Include Filename

Common

extract_filter_common.inc

Date

extract_filter_date
extract_date_sql.inc

Entity

extract_filter_entity.inc

Held

extract_filter_held.inc

Smf

extract_filter_smf.inc

Sources

extract_filter_sources.inc

Delta Based

extract_delta_based.inc

Issuer

extract_filter_iif.inc

See the following table to learn which filters are supported for the EagleML object you are going to extract.

Object Name

Feed Type

Common

Date

Entity

Held

SMF

History Only

Sources

Delta Based

Issuer

Own

CM Parameters

Object Name

Feed Type

Common

Date

Entity

Held

SMF

History Only

Sources

Delta Based

Issuer

Own

CM Parameters

Entity

 

 

 

 

 

 

 

 

 

 

 

 

Composite Entity List

ENTITYCOMPOSITELISTEXTRACT

+

+

+

 

 

+

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Manager Relationship

ENTITYMANAGERRELEXTRACT

+

+

+

 

 

 

 

 

 

entitytype, maxeffectivedate (only in history mode)

RemoveEntityDuplicates

Entity Share Class

ENTITYSHARECLASSEXTRACT

+

+

+

 

+

+

+

 

 

 

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates

Entity Accounting Basis

ENTITYACCBASISEXTRACT

+

+

+

 

 

 

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates, UseAllAcctBasis

Entity Analytic

ENTITYANALYTICEXTRACT

+

+

+

 

 

 

+

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Bank Relationship

ENTITYBANKRELEXTRACT

+

+

+

 

 

 

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Liquidity

ENTITYLIQUIDITYEXTRACT

+

+

+

 

 

+

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Manager

ENTITYMANAGEREXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Entity XREF

ENTITYXREFEXTRACT

+

+

+

 

 

 

 

 

 

entitytype

RemoveEntityDuplicates

Entity List

ENTITYLISTEXTRACT

+

+

+

 

 

 

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entities In List

STATICENTITYLISTEXTRACT

+

+

+

 

 

 

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entities In List

DYNAMICENTITYLISTEXTRACT

+

+

+
(EntityList filter is required)

 

 

 

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Generic Entity

ENTITYEXTRACT

+

+

+

 

 

+

+

 

 

entitytype, activeStatus

IncludeEntityInfo, RemoveEntityDuplicates

Entity Accounting Periods

ENTITYACCPERIODSEXTRACT

+

+

+

 

 

 

 

+

 

accountingBasis

IncludeEntityInfo, RemoveEntityDuplicates

Entity Peer Group Ranking

ENTITYPEERGROUPRANKINGEXTRACT

+

+

+

 

 

 

+

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Regulatory

ENTITYREGULATORYEXTRACT

+

+

+

 

 

+

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Security Lending

ENTITYSECLENDINGEXTRACT

+

+

+

 

 

 

+

+

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Entity Statistic

ENTITYSTATISTICEXTRACT

+

+

+

 

 

 

+

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Rule

 

 

 

 

 

 

 

 

 

 

 

 

Primary Mixed Cost Basis Rule

RULEPRIMCOSTBASISEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Contract Cash Rule

RULECONTRACTCASHEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Contractual Cash Settlement Rule

RULECCSETTLEMENTEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Earn Thru Rule

RULEEARNTHRUEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Basis Processing Rule

RULEBASISPROCEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Backup Withholding Rule

RULEBUWITHHOLDINGEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Month End Date Rule

RULEMONTHENDDATEEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Amortization Schedule Rule

RULEAMORTSCHDLEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

Accounting Rule

RULEACCOUNTINGEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

SMF

 

 

 

 

 

 

 

 

 

 

 

 

Generic SMF

SMFEXTRACT

+

+

 

+

+

+

+

+

 

securitysubtype, maxeffectivedate (only in history mode)

IncludeAssetProperties

Reference

 

 

 

 

 

 

 

 

 

 

 

 

Calendar

REFCALENDAREXTRACT

+

+

 

 

 

 

 

 

 

 

 

Calendar Business Dates

CALBUSINESSDATESEXTRACT

 

 

 

 

 

 

 

 

 

OnlyBusinessCalendar, CalendarType, CalendarBusinessName, DateTypeMacro, ProcessCenterName

 

Calendar Holiday

REFCALENDARHOLIDAYEXTRACT

+

+

 

 

 

 

 

 

 

calendarname, fromcalendardate, calendardate, tocalendardate

 

Classification Matrix

CLASSIFICATIONMATRIXEXTRACT

+

+

 

 

 

 

 

 

 

ExcludeClassMatrixId, pendingOnly, ClassificationMatrixName

 

Code Translation

CODETRANEXTRACT

+

+

 

 

 

 

 

+

 

fromsourcecode,fromcodecategory, fromcodecategoryname, fromcodevalue, fromcodevaluename, tosourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename

 

Code Value

CODEVALEXTRACT

+

+

 

 

 

+

 

+

 

sourcename, codecategory, codecategoryname, codevalue, codevaluename

 

Code Category

CODEEXTRACT

+

+

 

 

 

 

 

+

 

codecategoryname, codecategory

 

Сompliance 2A-7 Pricing Report

COMPLIANCE2A7PRICINGEXTRACT

+

+

 

+

 

 

 

 

 

accountingBasis, selectView, reportType, reportPeriod, 2A7PricingSource, reportFilters, advancedReportOptions, selectSector, sectorId, sector, filterSecurityBy, issuename, summaryMain, holdingsByTierLevel, holdingsByInvestmentType, holdingsByIssuer, securityRatings. Read more..

 

Demand List

DEMANDLIST

 

 

 

 

 

 

 

 

 

 

 

Entity Entitlement List

ENTITYENTITLEMENTLISTEXTRACT

+

 

+

 

 

 

 

 

 

usergroups (required)

RemoveEntityDuplicates

Error Definition

EXCEPTIONDEFEXTRACT

+

+

 

 

 

 

v.13+

 

 

ErrorCode

 

Ledger Notes

LEDGERNOTESEXTRACT

+

+

 

 

 

 

 

 

 

 

 

Line of Credit

LINEOFCREDITEXTRACT

+

+

+

 

 

 

 

 

+

facilityid

RemoveEntityDuplicates

NAIC Designation

NAICDESIGNATIONEXTRACT

+

+

 

 

 

 

 

 

 

naicresolutiontype, naicassetid, naicclientid

 

PACE Calendar

PACECALENDAREXTRACT

+

 

 

 

 

 

 

+

 

 

 

PACE System

PACESYSEXTRACT

+

+

 

 

 

 

 

+

 

sysitem

 

Pricing System Setting

PRICINGSYSSETTINGEXTRACT

+

+

 

 

 

+

 

+

 

code

 

Process Center

PROCESSCENTEREXTRACT

+

 

 

 

 

 

 

 

 

ProcessCenterName, CalendarBusinessName

 

Rating

RATINGSEXTRACT

+

+

 

+

+

+

+

+

 

maxeffectivedate

IncludeAssetProperties

Report Dictionary

DICTIONARYEXTRACT

+

+

 

 

+

 

+

+

 

excludesecuritylinksflag, dictionaryname

IncludeAssetProperties, linkedassetonlydelta

Run Time Stamps

RPTTIMESTAMPS

 

 

 

 

 

 

 

 

 

 

 

Source

SOURCEEXTRACT

+

+

 

 

 

 

 

 

 

sourceinstance, sourcename

 

Security related

 

 

 

 

 

 

 

 

 

 

 

 

SMF Identifiers

XREFEXTRACT

+

+

 

+

+

+

 

+

 

xrefidtype, securitysubtype, securityalias

 

SMF Identifier Config

XREFCONFIGEXTRACT

 

 

 

 

 

 

 

+

 

 

 

Exchange Price

ISSUEEXCHANGEPRICEEXTRACT

+

+

+

+

+

 

+

+

 

 

IncludeAssetProperties, RemoveEntityDuplicates

Issue Variable Rate

ISSUEVARRATEEXTRACT

+

+

 

+

+

+

+

+

 

 

IncludeAssetProperties

Issue Fx Rate

ISSUEFXRATEEXTRACT

+

+

 

+

+

 

+

+

 

 

 

Issue Fx Rate Demand

ISSUEFXRATEDEMANDEXTRACT

+

+

 

 

+

 

+

+

 

 

 

Issue Price

ISSUEPRICEEXTRACT

+

+

+

+

+

+

+

+

 

 

IncludeAssetProperties, RemoveEntityDuplicates

Issue Fx Pc Rate

ISSUEFXPCRATEEXTRACT

+

+

 

+

+

 

+

+

 

 

 

Generic Issue Analytic

GENISSUEANALYTICEXTRACT

+

+

 

+

+

+

+

+

 

 

IncludeAssetProperties

Schedule

SCHEDULEEXTRACT

+

+

 

+

+

+

+

+

 

securitysubtype

IncludeAssetProperties

GIPS Composite

REFGIPSCOMPOSITEEXTRACT

+

+

+

 

 

 

 

 

 

 

RemoveEntityDuplicates

GIPS Disclosure

REFGIPSDISCLOSUREEXTRACT

+

+

 

 

 

 

 

 

 

DisclosureName, DisclosureType

 

Time Series

REFTIMESERIESEXTRACT

+

+

 

+

+

 

 

+

 

 

 

Trade Quote

REFTRADEQUOTESEXTRACT

+

+

+

+

+

 

+

+

 

 

RemoveEntityDuplicates

Yield Curve

YIELDCURVEEXTRACT

+

+

 

 

 

 

 

 

 

 

 

Forward Points

FORWARDPOINTSEXTRACT

+

+

 

+

+

+

+

+

 

 

IncludeAssetProperties

Factor

FACTOREXTRACT

+

+

 

+

+

+

+

+

 

 

IncludeAssetProperties

Security Default

SECURITYDEFAULTEXTRACT

+

+

 

+

+

 

 

 

 

 

 

Security Notes

SECURITYNOTESEXTRACT

+

+

 

 

+

 

 

+

 

 

 

Security Overrides

SECURITYOVERRIDESEXTRACT

+

+

 

 

+

 

+

+

 

 

IncludeAssetProperties

Earnings Time Period

EARNINGSTIMEPERIODEXTRACT

+

+

 

 

+

 

 

+

 

 

 

Issuer

 

 

 

 

 

 

 

 

 

 

 

 

Issuer

GENISSUEREXTRACT

+

+

 

+

+

+

 

+

+

maxeffectivedate (only in history mode)

 

Issuer ESG

ISSUERESGEXTRACT

+

+

 

 

 

+

 

+

+

maxeffectivedate (only in history mode)

 

Issuer Entity Relationship

ISSUERENTRELEXTRACT

 

 

 

 

 

 

 

+

 

 

 

Issuer Rating

ISSUERRATINGEXTRACT

+

+

 

 

 

 

 

+

+

maxeffectivedate

 

Issuer Organization

ISSUERORGEXTRACT

+

+

 

+

+

+

 

+

+

maxeffectivedate (only in history mode)

 

Issuer Regulatory

ISSUERREGULATORYEXTRACT

+

+

 

 

 

 

 

+

+

 

 

Issuer Relationship

ISSUERRELEXTRACT

+

+

 

 

 

 

 

+

+

 

 

Issuer Role

ISSUERROLEEXTRACT

+

+

 

+

+

+

 

+

+

minenddate

 

Warehouse

 

 

 

 

 

 

 

 

 

 

 

 

Warehouse Pending Trade

WRHSPENDINGTRADESEXTRACT

+

+

+

 

+

 

+

+

 

 

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Custody Activity

WRHSCSTDACTIVITYEXTRACT

+

+

+

 

+

 

 

+

 

 

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Custody Balance

WRHSCSTDBALANCEEXTRACT

+

+

+

 

+

 

 

+

 

 

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Cash Activity

WRHSCASHACTIVITYEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates,excludezero

Warehouse Performance

WRHSPERFORMANCEEXTRACT

+

+

+

 

+

 

+

 

 

BatchMode

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, IncludeCurveAnalytics, excludezero

Warehouse Close Lot

WRHSCLOSELOTEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Position

WRHSPOSITIONEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode, extractLevel

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, TakeBaseCurrencyFromWRHSPosDet, includeZeroPositions, IncludeCurveAnalytics, IncludePortfolioValuation, excludezero

Warehouse Open Lot

WRHSOPENLOTEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode, extractLevel

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, includeZeroPositions, IncludePortfolioValuation, IncludeWashSales, excludezero

Warehouse Open Lot

WRHSOPENLOTBROKERROLLUPEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode, extractLevel

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, includeZeroPositions, IncludePortfolioValuation, IncludeWashSales, GroupBy, excludezero

Warehouse Trade

WRHSTRADEEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode, transactioncode

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, EnableSignageLogic, excludezero, EnhanceCalcTransactionId

Warehouse Trade Charges

WRHSTRADECHARGESEXTRACT

+

+

+

 

+

 

+

 

 

BatchMode

 

Warehouse Trade Xref Identifier

WRHSTRADEXREFEXTRACT

+

 

+

 

+

 

 

 

 

 

 

Warehouse NAV Multi

WRHSNAVMULTIEXTRACT

+

+

+

 

+

 

 

+

 

BatchMode

IncludeAssetProperties, IncludeExtendedDetails, includeEntityShareClass, includeReportDetails, includeCustomReportDetails, IncludeAverageNetAssets, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse NAV

WRHSNAVEXTRACT

+

+

+

 

 

 

+

+

 

BatchMode

IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse NAV Month End

WRHSNAVMONTHENDEXTRACT

+

+

+

 

 

 

+

+

 

 

IncludeAssetProperties, IncludeExtendedDetails, includeEntityShareClass, UseFundsOfFunds, IncludeEntityInfo, excludezero

Warehouse General Ledger Balances

WRHSGLDETAILPOSTINGEXTRACT

+

+

+

 

+

 

+

+

 

BatchMode, GLBasic,  IncludeMEMOAccounts, IncludeOnlyAcctBaseCurrency

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Broker Trade Quote

WRHSBROKTRDQUOTEEXTRACT

+

+

+

+

+

 

+

+

 

masterTicketNumber

RemoveEntityDuplicates, excludezero

Warehouse Cash Flow Projection

WRHSCASHFLOWPROJEXTRACT

+

+

+

 

+

 

+

+

 

 

IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Insurance Valuation Lot

WRHSCASHFLOWPROJEXTRACT

+

+

+

 

+

 

 

 

 

clientID, Lot_id

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Disclosure Status

WRHSDISCLOSURESTATUSEXTRACT

+

+

+

 

+

 

+

 

 

 

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Warehouse Wash Sale Trade

WRHSWASHSALETRADEEXTRACT

+

+

+

+

+

 

+

+

 

BatchMode, origaccountingdate, fromorigaccountingdate, toorigaccountingdate

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, excludezero

Corporate Action

 

 

 

 

 

 

 

 

 

 

 

 

Generic Corporate Actions

GENCORPACTIONSEXTRACT

+

+

 

+

+

+

 

+

 

maxsweepdate, maxsweepdaterule, UseTransTypeGrouping, transType, cpReason, cpStatus, clientSpecificCAId

IncludeAssetProperties

Voluntary CA Election

VOLCAELECTIONEXTRACT

+

+

 

+

+

+

 

+

 

 

 

Client

 

 

 

 

 

 

 

 

 

 

 

 

Client

CLIENTEXTRACT

+

+

+

 

 

 

 

+

 

ClientID, Instance

RemoveEntityDuplicates

Client Communication

CLIENTCOMMEXTRACT

+

+

 

 

 

 

 

+

 

ClientID, CommunicationType, Instance

 

Accounting

 

 

 

 

 

 

 

 

 

 

 

 

Accounting Trade

ACCOUNTINGTRADEEXTRACT

+

+

+

 

+

 

+

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Financial Event

FINANCIALEVENTEXTRACT
(a specific extract for Accounting Trade, tagvalue-only, no EagleML interpretation)

+

+

+

 

+

 

+

+

 

 

 

Traded Cash Activity

TRADEDCAEXTRACT

+

+

+

 

+

 

 

 

 

accountingBasis, UsePrimaryBasisOnly

IncludeAssetProperties, IncludeExtendedDetails, EnableSignageLogic, IncludeEntityInfo, RemoveEntityDuplicates, EnhanceCalcTransactionId

Settled Cash Activity

SETTLEDCAEXTRACT

+

+

+

 

+

 

 

+

 

accountingBasis, UsePrimaryBasisOnly

IncludeExtendedDetails, EnableSignageLogic, IncludeEntityInfo, RemoveEntityDuplicates, EnhanceCalcTransactionId

Accounting GL Activity

GLACTIVITYEXTRACT

+

+

+

 

+

 

 

+

 

FromGLAccount, GLBasic, GLClass, GLDateType, GLFromDate, GLToDate, GLSector, ToGLAccount, IncludeALLOCATEEvents,

IncludeMEMOAccounts, NetRollbackReplayEntries

IncludeAssetProperties, IncludeEntityInfo

Accrued Income

ACCRUEDINCOMEEXTRACT

+

+

+

+

+

 

 

 

 

 

IncludeAssetProperties, IncludeEntityInfo

Subscribe Redeem

SUBSCRIBEREEDEMEXTRACT

+

+

+

 

+

 

 

 

 

 

IncludeAssetProperties, IncludeExtendedDetails, includeEntityShareClass, IncludeSubscribeReedemCalcFields,

IncludeEntityInfo, RemoveEntityDuplicates

Daily Yield Mill Rate

DAILYYIELDMILLRATEEXTRACT

+

+

+

 

 

 

 

 

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Cash Journal

CASHJOURNALEXTRACT

+

+

+

 

+

 

 

 

 

reportView, selectView, reportType, reportPeriod, includeCancels, displayZero, nraTaxCountry, localCurrency, longShortIndicator, eventType, baseCurrency, processCodeTranslation, codeMapName
All filters are case-insensitive

 

Cash Projections

CASHPROJECTIONSEXTRACT

+

+

+

 

+

 

 

+

 

CashProjectionReportType, CashProjectionReportName, CashProjectionPositionSwitch, CashProjectionInstanceType, CashProjectionInstance, accountingBasis

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates, IncludeExtendedDetails

Unsettled Transactions

UNSETTLEDTRANSACTIONSEXTRACT

+

+

 

 

 

 

 

 

 

reportType, reportDate, baseCurrency, accountingBasis, longShortIndicator, cashCategory, eventReason, cashEventType, shareClass, localCurrency, includeCorpAction, includeFwdTransactions

accountingValidationFlag (required in case you set a range of dates)

Realized Gain Loss

REALIZEDGAINLOSSEXTRACT

+

+

+

 

+

 

 

 

 

reportType, reportPeriod, reportTypeSource, includeCancels, displayZero, accountingBasis, reportFilters, filterSecurityBy, assetCurrency or localCurrency, longShortIndicator, eventType, issuename, nraTaxCountry, lotPosSwitch (SP mode only), displayUDF (panel mode for v2017 or higher, SP mode only for other)
All filters are case-insensitive

accountingValidationFlag, IncludeEntityInfo, RemoveEntityDuplicates

Consolidated Earned Income

CONSEARNEDINCOMEEXTRACT

 

+

+

 

+

 

 

 

 

reportPeriod, reportType, reportStartDate, reportEndDate, accountingBasis, baseCurrency or localCurrency, taxableIndicator, nraTaxCountry, longShortIndicator, governmentIndicator, issuename,

rollupIndicator (SP mode only), processCenter (SP mode only), conversionStatus (SP mode only), urglRecpayIndicator (SP mode only)
All filters are case-insensitive

accountingValidationFlag, selectView, selectSector, sectorID, detailSelection

Distribution Activity

DISTRIBUTIONACTEXTRACT

+

+

+

 

+

 

 

 

 

 

IncludeAssetProperties, IncludeExtendedDetails, IncludeEntityInfo, RemoveEntityDuplicates

Custom Ledger Account

CUSTLEDGERACCTEXTRACT

+

+

+

 

 

 

 

 

 

GLSelectionType, GLChartOfAccountName, GLAccount, GLCustomAccount, GLCustomAccountDescription, GLPostType

 

Open Rec Pay Multi

OPENRECPAYMULTIEXTRACT

+

+

+

 

 

 

 

 

 

settleCurrency, brokerName, brokerCode, targerEventId, eventType, tradeTicketNumber, category, entityName, issuename
All filters are case-insensitive

IncludeEntityInfo, RemoveEntityDuplicates

Unapproved Variation Margin

UNAPPROVEDVARMARGINEXTRACT

+

+

+

 

+

 

 

 

 

accountingBasis, baseCurrency, longShortIndicator, reportType

IncludeAssetProperties, IncludeEntityInfo, RemoveEntityDuplicates

Trial Balance

TRIALBALANCEEXTRACT

 

 

+

 

 

 

 

 

 

selectView, ledgerProfile, reportType, generalLedgerCurrency, accountingBasis, showMEMOAccounts, showAssetLevelDetails, reportFilters, selectSector, sectorID, sector, selectShareClass, shareClass, detailedClassView, reportDate, filterSecurityBy, issuename
All filters are case-insensitive

IncludeEntityInfo, RemoveEntityDuplicates

Fair Value Comparison

FAIRVALUECOMPARISONEXTRACT

+

+

+

 

+

 

 

 

 

accountingBasis, reportType, nextDayOpenSourceName, nextBusinessDay, nextDayOpenPriceType, nextOpenPricingExchange, reportFilters, showMEMOAccounts, showAssetLevelDetails, filterSecurityBy, issuename, longShort, assetCurrency, issueCountry

IncludeEntityInfo, RemoveEntityDuplicates

Accounting Intraday NAV

INTRADAYNAVEXTRACT

+

+

+

 

 

 

 

+

 

 

IncludeEntityInfo, RemoveEntityDuplicates, includeEntityShareClass

Accounting NAV for NASDAQ

NAVFORNASDAQEXTRACT

+

+

+

 

 

 

 

+

 

 

IncludeEntityInfo, RemoveEntityDuplicates

Working Trial Balance

WORKINGTRIALBALANCEEXTRACT

+

+

+

 

 

 

 

 

 

accountingBasis, generalLedgerCurrency, selectView, selectSector, sectorID, Sector, selectShareClass, shareClass, detailedClassView, reportType, ledgerProfile, reportFilters, showMEMOAccounts, showAssetLevelDetails, filterSecurityBy, xrefid, xrefidtype, primaryassetid, issuename, includeExcludeCloseoutEntries

IncludeEntityInfo, RemoveEntityDuplicates

Monthly Portfolio Valuation

MONTHLYPORTFOLIOVALUATIONEXTRACT

+

+

+

 

+

 

 

+

 

 

RemoveEntityDuplicates

Portfolio Valuation

PORTFOLIOVALUATIONEXTRACT

+

+

+

 

+

 

 

+

 

 

RemoveEntityDuplicates

Accounting Rejection

REJECTIONEXTRACT

+

+

+

+

+

+

+

+

 

eventType, eventId, updateSource

IncludeExtendedDetails, IncludeAssetProperties

Accounting Position As Of

POSITIONASOFEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Preferred Share

PREFERREDSHAREEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Master Feeder Relationship

MASTERFEEDERRELATIONEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Bank Cash Settlement

BANKCASHSETTLEMENTEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Weighted Average

WEIGHTEDAVERAGEEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Expense Activity

EXPENSEACTIVITYEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Pricing Report

PRICINGREPORTEXTRACT

+

+

+

 

+

 

 

 

 

usergroups

 

User Administration

 

 

 

 

 

 

 

 

 

 

 

 

User

USEREXTRACT

+

+

 

 

 

 

 

+

 

userid, businessgroupname, usergroupname, applicationgroupname, centerrolename, accountstate, SetProcessingOptionsValue

IncludeInstanceIds

Group

USERGROUPEXTRACT

+

+

 

 

 

 

 

 

 

userid, businessgroupname, usergroupname, applicationgroupname, centerrolename, accountstate, SetProcessingOptionsValue

IncludeInstanceIds

Entitlement

USERENTITLEMENTEXTRACT

+

 

 

 

 

 

 

 

 

PropertyName

 

Eagle Administration Settings

EAGLEADMINISTRATIONSETTINGSEXTRACT

 

 

 

 

 

 

 

 

 

 

 

Internal

 

 

 

 

 

 

 

 

 

 

 

 

Control Center Event Log

CONTROLCENTEREVENTLOGEXTRACT

+

+

 

 

 

 

 

 

 

eventgroupname, eventtaskid, activeflag, completedflag, coregroup, statisticcategory, statisticname, statistictype, businessprocessinggroup

 

S2P Reporting

 

 

 

 

 

 

 

 

 

 

 

 

Spd Delta Trigger Log

SPDDELTATRIGGERLOGEXTRACT

+

+

+

 

+

 

+

+

 

eventId, messageSubType, updateSource, localCurrency, accountingBasis, minAccountingDateFlag

 

Other

 

 

 

 

 

 

 

 

 

 

 

 

Calculate Date

CALCULATEDATE