SQL Series 1000000

System Configurations > Contract Application Calculation > Contract Application SQL Definition

SQL Series 1000000

Master Definitions for Contract Application Build

The prime entries that define the sequences applied by HighStone.

SQL Identifier

Notes and Comments

SQL 1000000 - 0

Defines the Series of SQL Scripts used to run an Application Report for a Given Invoicing Period - and the type of calculation applied.

SQL 1000000 - 0

1000010,SQLSCRIPT
1000040,SETVALUES
1000060,SQLSCRIPT
1000070,SQLSCRIPT

SQL 1000000 - 2

Query that Returns Entire Application Results - Source is tblProjectCosts - All columns are returned.

SQL 1000000 - 2

SELECT ProjSerialNo, StaffName AS SchemeManager, tblProjectCosts.* FROM (tblProjects INNER JOIN tblProjectCosts ON tblProjects.ProjAutoGUID = tblProjectCosts.PCProjectGUID) LEFT JOIN tblStaff ON tblProjects.ProjManagerId = tblStaff.StaffId ORDER BY tblProjects.ProjSerialNo;