Warehouse Cash Flow Projection Inbound Interface

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 23, 2024 by Kinga Huszno
1 min read

Overview

Warehouse Cash Flow Projection inbound interface is designed to load and update data in CASHDBO.CASH_FLOW_PROJECTION database table 

Incoming message format: EagleML (WarehouseCashFlowProjection complex type).

Stream Logic

EagleML Processing Sequence

Warehouse Cash Flow Projection is loaded into DB via eagle_ml-2-0_default_in_xml_warehouse_preproc in two steps:

  • XSLT transformation. XSLT rule 'eagle_default/in/xml/xslt/wrh_egl_gen_interface3.xsl' is used.

  • Loading data into the database. The 'eagle_default/in/xml/xml-warehouse_v2.xml' rule is used.

To load or update data in Warehouse Cash Flow Projection database tables send an EagleML message into the eagle_ml-2-0_default_in_xml_warehouse_preproc stream.

Keys used to update:

SecurityAlias, EntityId, EffectiveDate

Security Resolution Logic

<securityAlias> should not be specified in the incoming EagleML message.

Refer to Security Resolution for Warehouse Objects

Entity Resolution Logic

Refer to Entity Resolution for Warehouse Objects