In this page:
...
Parameter | Example of Value | Default Value | Comments | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ExtractDeliveryMethod | JMS,FTP,SFTP,FILE | FILE | Chooses the way the extract to be delivered. This setting can affect the set of available parameters you can apply to your extract. | |||||||||||
DeliveryStreamName | default value is taken from W_JMS_DEF_EXTRACT_STREAM global parameter in w_config_custom.inc | You use this parameter is case of ExtractDeliveryMethod = JMS to use a custom stream | ||||||||||||
FromFolder | ../../../cmw/extracts/ | ../../../cmw/extracts/ | Folder containing files to be archived. | |||||||||||
ToFolder | ../../../cmw/extracts/ | ../../../cmw/extracts/ | Folder in which the archives should be created.
Especially useful when you use FTP/SFTP/JMS delivery method, but want to save archive locally in the path different from default | |||||||||||
| test_new_name_002 | Archive name. Only ZIP format compression is available.
| ||||||||||||
| test_new_name_001 | If this parameter is specified, the archive name will be generated as: OutputZipNamePattern:+ :CorrID: so each archive name will be unique. test_new_name_001_1M6EX27SPOQZKMUN
| ||||||||||||
| tst_DateTimeStamp_my2_@feedtype.zip | Custom name pattern for the output file. List of valid expressions:
| ||||||||||||
FilesAddToZip | *.XML | ProcessCorrId.* | Template files that will be added to the archive. | |||||||||||
SendDataToFTP | Y or N | N |
If this parameter is set to Y, archive data will be loaded to FTP into the CMW\extracts folder. This is an equivalent of ExtractDeliveryMethod = FTP and means that result file will be sent to FTP, even if you choose another ExtractDeliveryMethod option.
or its obsolete variation (described to support backward compatibility):
ToFTPFolder is also supported, but this is an obsolete parameter, we highly recommend using CustomExtractLocation. | |||||||||||
| ../../../cmw/custom_extract/ | cmw/extracts/ | Defines a custom folder on FTP/SFTP or on server into which the archive is loaded. Consequently, you cannot set an absolute path to a folder – and this behavior is different from the case of CustomExtractLocation for common extracts (you can set absolute folder paths there). Resulting path for defferent delivery methods is made up like this: For Delivery Method = FILE: For Delivery Method = FTP: For Delivery Method = SFTP:
:STREAMDIR: = /envPath/estar/tpe/data/msgcenter/out/TAGVALUE/eagle_ml-2-0_default_cm_packer/ | |||||||||||
CustomFTPFolder | CMW/custom_extract/ | CMW/extracts/ | Defines a custom FTP folder into which the archive is loaded.
| |||||||||||
ExtractSendNotification | 1 or 0 | 1 | The same logic is used for SendNotification, but this option can only be applied to extracts within the workflow. |
...
Subprocess name | Common | Date | Entity | Held | SMF | History Only | Source | Delta Based | Own |
---|---|---|---|---|---|---|---|---|---|
eagle_generic_extract_entity_and_rule_objects | + | + | + | entitytype, historyonlyflag | |||||
--eagle_generic_extract_entity_objects | + | + | + | entitytype, historyonlyflag | |||||
----extract_entity_manager | + | + | + | ||||||
----extract_entity_manager_relationship | + | + | + | entitytype | |||||
----extract_entity_accounting_periods | + | + | + | ||||||
----extract_entity_accounting_basis | + | + | + | ||||||
---- extract_entity_analytics | + | + | + | + | |||||
----extract_entity_identifiers | + | + | + | entitytype | |||||
----extract_generic_entity | + | + | + | entitytype, historyonlyflag | |||||
----extract_entity_bank_relationship | + | + | + | ||||||
----extract_entity_composite | + | + | + | ||||||
----extract_entity_list | + | + | + | ||||||
----extract_entities_in_composite | + | + | + | ||||||
----extract_entities_in_list | + | + | + | ||||||
----extract_gips_disclosures | + | + | + | ||||||
----extract_gips_composite | + | + | + | ||||||
----extract_entity_entitlement_list | + | + | + | usergroups | |||||
----extract_entity_share_class | + | + | + | ||||||
----extract_entity_regulatory | + | + | |||||||
----extract_entity_security_lending | + | + | |||||||
--eagle_generic_extract_rule_objects | + | + | + | ||||||
----extract_rule_contract_cash | + | + | + | ||||||
----extract_rule_contractual_cash_settlement | + | + | + | ||||||
----extract_rule_earn_thru | + | + | + | ||||||
----extract_rule_basis_processing | + | + | + | ||||||
----extract_rule_backup_withholding | + | + | + | ||||||
----extract_rule_month_end_date | + | + | + | ||||||
----extract_rule_primary_mixed_cost_basis | + | + | + | ||||||
----extract_rule_amortization_schedule | + | + | + | ||||||
----extract_rule_accounting | + | + | + | ||||||
| |||||||||
eagle_generic_extract_reference_objects | + | + | + | + | + | + | selectiontype, selectionvalue, includeissuerxref, securitysubtype, xreftype, issueralias, issuerid, issuername, codecategory, codecategoryname, codevalue, codevaluename, fromcodecategory, fromcodecategoryname, CalendarBusinessName, CalendarType, DateTypeMacro, OnlyBusinessCalendar, ProcessCenterNamefromcodevalue, fromcodevaluename, fromsourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename, tosourcecode | ||
--eagle_generic_extract_issuer_objects | + | + | + | + | includeissuerxref, issueralias, issuerid, issuername | ||||
--extract_issuer_entity_relationship | + | + | + | + | includeissuerxref, issueralias, issuerid, issuername | ||||
----extract_issuer_relationship | + | + | issueralias, issuerid, issuername | ||||||
----extract_issuer_role | + | + | + | issueralias, issuerid, issuername | |||||
----extract_issuer_organization | + | + | issueralias, issuerid, issuername | ||||||
----extract_issuer_rating | + | + | issueralias, issuerid, issuername | ||||||
----extract_issuer | + | + | includeissuerxref, issueralias, issuerid, issuername | ||||||
--eagle_generic_extract_security_related_objects | + | + | + | + | + | selectiontype, selectionvalue, securitysubtype | |||
----extract_issue_fx_rate | + | + | + | + | + | ||||
----extract_issue_fx_pc_rate | + | + | + | + | + | ||||
----extract_issue_price | + | + | + | + | + | ||||
----extract_issue_exchange_price | + | + | + | + | + | ||||
----extract_smfidentifiers | + | + | + | + | + | securitysubtype, xreftype | |||
----extract_schedule | + | + | + | + | + | securitysubtype | |||
----extract_time_series | + | + | + | + | + | ||||
----extract_generic_issue_analytic | + | + | + | + | + | ||||
----extract_issue_variable_rate | + | + | + | + | + | ||||
----extract_rating | + | + | + | + | + | securitysubtype | |||
----extract_cancelsmfidentifiers | + | + | + | + | + | ||||
----extract_forward_points | + | + | + | + | + | ||||
----extract_factor | + | + | + | + | + | ||||
----extract_securityoverrides | + | + | + | + | |||||
----extract_naic_designation | + | + | + | + | + | ||||
--eagle_generic_extract_system_objects | + | + | + | jobname, codecategory, codecategoryname, codevalue, codevaluename, fromcodecategory, fromcodecategoryname, fromcodevalue, fromcodevaluename, fromsourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename, tosourcecode, CalendarBusinessName, CalendarType, DateTypeMacro, OnlyBusinessCalendar, ProcessCenterName | |||||
----extract_code_translation | + | + | fromcodecategory, fromcodecategoryname, fromcodevalue, fromcodevaluename, fromsourcecode, tocodecategory, tocodecategoryname, tocodevalue, tocodevaluename, tosourcecode | ||||||
----extract_code_category | + | + | codecategory, codecategoryname | ||||||
----extract_code_value | + | + | + | codecategory, codecategoryname, codevalue, codevaluename | |||||
----extract_calendar | + | + | |||||||
----extract_calendar_holiday | + | + | calendarname, calendardate, fromcalendardate, tocalendardate | ||||||
----extract_calendar_business_dates | + | + | CalendarBusinessName, CalendarType, DateTypeMacro, OnlyBusinessCalendar, ProcessCenterName | ||||||
----extract_error_definition | + | + | |||||||
----extract_yield_curve | + | + | |||||||
----extract_run_time_stamps | + | + | jobname | ||||||
----extract_ledger_notes | + | + | |||||||
--eagle_generic_extract_client_objects | + | + | selectiontype, selectionvalue | ||||||
----extract_client | + | + | selectiontype, selectionvalue | ||||||
----extract_client_communication | + | + | selectiontype, selectionvalue | ||||||
| |||||||||
eagle_generic_extract_warehouse_objects | + | + | + | + | + | BatchMode, ExcludeCurrentDay, accountingdate, fromaccountingdate, frommonthendaccountingdate, GLBasic, monthendaccountingdate, toaccountingdate, tomonthendaccountingdate, fromvaluationdate, tovaluationdate, valuationdate | |||
--extract_warehouse_cash_activity | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_closelot | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_openlot | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_performance | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_position | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_trade | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_nav | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_custody_activity | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_custody_balance | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_pending_trade | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_warehouse_glbalances | + | + | + | + | + | BatchMode, ExcludeCurrentDay, accountingdate, fromaccountingdate, frommonthendaccountingdate, GLBasic, monthendaccountingdate, toaccountingdate, tomonthendaccountingdate | |||
--extract_warehouse_nav_multi | + | + | + | + | + | BatchMode, ExcludeCurrentDay, fromvaluationdate, tovaluationdate, valuationdate | |||
--extract_warehouse_broker_trade_quote | + | + | + | + | + | BatchMode, ExcludeCurrentDay | |||
--extract_trade_quotes | + | + | + | + | |||||
--extract_warehouse_cash_flow_projection | + | + | + | + | + | ||||
--extract_warehouse_istarlot | + | + | + | + | + | ||||
--extract_warehouse_disclosure_status | + | + | + | + | + | ||||
| |||||||||
eagle_generic_extract_smf_objects | + | + | + | + | + | asofeffectivedate, securitysubtype | |||
--extract_generic_smf | + | + | + | + | + | asofeffectivedate, securitysubtype | |||
eagle_generic_extract_financial_event | + | + | + | + | |||||
--extract_financial_event | + | + | + | + | |||||
eagle_generic_extract_corp_actions_objects | + | + | + | + | + | ||||
--extract_generic_ca | + | + | + | + | + | ||||
--extract_voluntary_ca_election | + | + | + | + | + | ||||
eagle_generic_extract_accounting_objects | + | + | + | + | + | + | |||
--extract_accounting_trade | + | + | + | + | |||||
--extract_accounting_gl_activity | + | + | + | + | FromGLAccount, GLBasic, GLClass, GLDateType, GLFromDate, GLSector, GLToDate, ToGLAccount | ||||
--extract_accounting_traded_cash_activity | + | + | + | + | |||||
--extract_accounting_cash_projections | + | + | + | + | + | + | |||
--extract_accounting_accrued_income | + | + | + | + | + | + | |||
--extract_accounting_subscribe_reedem | + | + | + | + | + | + | |||
--extract_accounting_daily_mill_rate | + | + | + | + | + | + | |||
--extract_accounting_unsettled_trans | + | + | + | + | + | + | reportType, reportDate, baseCurrency, accountingBasis, longShortIndicator, cashCategory, eventReason, cashEventType, shareClass, localCurrency, includeCorpAction, includeFwdTransactions | ||
--extract_accounting_cash_journal | + | + | + | + | + | + | reportView, selectView, reportType | ||
--extract_accounting_realized_gl | + | + | + | + | + | + | reportType, reportTypeSource, includeCancels, displayZero, displayUDF | ||
--extract_accounting_settled_ca | + | + | + | + | + | + | |||
--extract_accounting_cons_earned_income | + | + | + | + | + | + | reportType, reportPeriod, startDate, endDate, longShortIndicator, rollupIndicator, accountingBasis, baseCurrency, localCurrency, taxableIndicator, nraTaxCountry, governmentIndicator, processCenter, conversionStatus, urglRecpayIndicator | ||
--extract_accounting_distribution_activity | + | + | + | + | + | + | |||
--extract_accounting_custom_ledger_acct | + | + | + | + | + | + | Switch, ChartOfAccountName, GLAccount, CustomAccount, CustomAccountDescription, GLPostType | ||
--extract_accounting_open_rec_pay_multi | + | + | + | + | + | + | issuename, settlecurrency, brokerName, brokerCode, targerEventId, eventType, tradeTicketNumber, category | ||
--extract_accounting_unapproved_var_margin | + | + | + | + | accountingBasis, baseCurrency, longShortIndicator, reportType | ||||
--extract_accounting_trial_balance | + | + | + | selectView, ledgerProfile, reportType, generalLedgerCurrency, accountingBasis, showMEMOAccounts, showAssetLevelDetails, reportFilters, selectSector, sectorID, sector, selectShareClass, shareClass, detailedClassView, reportDate, monthEndDate, filterSecurityBy, issuename | |||||
--extract_accounting_intraday_nav | + | + | + | ||||||
--extract_accounting_nav_for_nasdaq | + | + | + | ||||||
--extract_accounting_fair_value_comparison | + | + | + | ||||||
eagle_ml20_default_cm_packer | CustomExtractLocation, ExtractDeliveryMethod, FromFolder, ToFolder, OutputZipFileName, OutputZipFileNamePattern, SendDataToFTP |
...