Warehouse GL Balances Inbound Interface

Owned by Natalie Gesin (Deactivated)
Last updated: Dec 29, 2022 by Alexey Trubitsyn
1 min read

Overview

The stored procedure name is  LEDGERDBO.SPD_LEDGER.LED_EGL_GEN_INTERFACE

Contains elements from the LEDGERDBO.GL_DETAIL_POSTING table and Entity and Security Cross Reference Identifiers.

Stream Logic

EagleML Processing Sequence

Warehouse GL Balances 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-wh_gl_detail_posting.xml' rule is used.

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

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