Contracts table information in SupportCentre Plus
I would like to add the Hours Spent and Hours Remaining (from the Contracts screen) in a report. There are no standard reports for the Contracts information, but I was wondering if someone could give me an SQL to let me know the table and field names that hold this information.
If anyone know, could they provide the SQL to create a report to show Hours Spent and Hours Remaining, grouped by Time Entry Type?
Thanks.
If anyone know, could they provide the SQL to create a report to show Hours Spent and Hours Remaining, grouped by Time Entry Type?
Thanks.