Budget Information / Budget SQL¶
SQL queries can be entered that will be run when a budget is saved in Budgeting.
| Column Heading | Description |
|---|---|
| Enabled | Indicates if it is enabled or disabled. |
| SQL Name | Enter a name for the SQL query. |
| Budget Name | Select the relevant Budget Name from the drop-down list. |
| Popup Name | Select the relevant Popup Name from the drop-down list. |
| SQL Statement | Enter the SQL statement. |
Right click Menu Items¶
Cell Editor - this will bring up another window allowing you to enter, edit and view long text.
Insert - Create a new SQl entry
Copy - Copy an existing SQL entry
Remove - Delete a SQL entry