• SQL Functions View

    Published:

    The SQL Functions View enables you to create, edit and view SQL Functions for various different types within the application. Each one has an associated .net clr assembly containing the corresponding clr function that can be called from within sql.

  • SQL Functions

    Published:

    SQL Functions provide the ability to import .net clr functions into the LemonEdge database for reference and use within the query tools. This provides access to system default algorithms, such as IRR calculations, live from the query tools whilst also providing a mechanism for custom algorithms as well.

  • GL Account Classification View

    Published:

    The GL Account Classifications view allows you to configure the Classification Name the GL Account should have for each GL Classification setup in the system. This enables you to report on your entire GL in multiple different ways.

  • GL Accounts With Classifications View

    Published:

    The GL Accounts With Classifications view provides an overview of all GL Accounts in the system, and their associated names for each GL Classification setup in the system too.

  • Blending Transaction New Value Allocations

    Published:

    Blending Transaction New Value Allocations are used to provide a mechanism in which calculated Aggregate Values from this algorithm should be allocated across Transactions created on Instruments.

  • Blending Transaction New Value Aggregates

    Published:

    Blending Transaction New Value Aggregates hold the values you can apply to the Values of the newly created Transaction by the algorithm. These can come from the Blending Transaction Values or formulas.

  • Blending Transaction New Values

    Published:

    Blending Transaction New Values holds list of Transactions you want the algorithm to automatically create, including the Transaction Code for each Transaction which in turn specifies the processing logic applied to that created Transaction.

  • Blending Transaction Values

    Published:

    Blending Transaction Values holds the custom specified aggregate values for transactions against the source or target data sets. These values can easily be used in any part of the algorithm.