|
Overview
The SQL Query section allows you to create custom invoice sections that can pull in data from any table that is accessible in the InFocus Database.
Key Concepts
| • | Queries are pasted into the Query window and you must use the variable ^projectpath^ as the Parameter Variable. |
| • | InFocus comes with 2 system SQL Query sections Receipts and AllocateICCRevenueByPCT. |
| o | Receipts - This section allows for you to display an archived image that has been associated with a transaction being billed (i.e. Scanned .jpg image of a receipt) in an invoice. In order to use this section, you must be using the new HTTP Document Management. Currently the only supported image formats are jpg, jpeg, png, bmp and gif. |
| o | AllocateICCRevenueByPct - This query section will allocate ICC Revenue based on the same percent completes used in a fixed fee invoice. For this new SQL section to work it needs to be added to your fixed fee designs and placed anywhere after the fixed fee section with respect to the order of the sections. |
Field Descriptions
Name
| • | Textbox - The name of the Combination section can be edited here. Must be unique. |
| • | Stored Procedure - When checked, a stored procedure is placed into the SQL Query Window. When unchecked, the query must be written in the Query window. |
Query
| • | Query Window - Custom SQL Code is added here. Knowledge of SQL is required. |
|