Difference between revisions of "OpenFlyers SQL stored functions and procedures"
(Created page with '__TOC__ =Presentation= This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imp...') |
|||
Line 2: | Line 2: | ||
=Presentation= | =Presentation= | ||
This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports. | This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports. | ||
+ | |||
+ | =sumAccountEntry= | ||
+ | *This function exists with OF 2.1+ | ||
+ | *Stored function to compute the current balance of an account at a given date | ||
+ | *Input parameters: | ||
+ | **accountId (account Id) | ||
+ | **endDate (to compute only account entries before this date) | ||
+ | *Output parameters* | ||
+ | **totalBalance (balance) |
Revision as of 20:32, 15 December 2010
Contents
Presentation
This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports.
sumAccountEntry
- This function exists with OF 2.1+
- Stored function to compute the current balance of an account at a given date
- Input parameters:
- accountId (account Id)
- endDate (to compute only account entries before this date)
- Output parameters*
- totalBalance (balance)