TASK – This table stores all task information for the Track-IT pro database.
Ÿ ID – The unique ID for a task. (PK)
Ÿ NAME – The name for the task.
Ÿ GROUP – The group ID for the task group the task belongs to. (FK)
Ÿ DESC – The description for the task.
Ÿ GLOBAL – “T” if the task is global, “F” otherwise.
Ÿ PRORATE – The multiplier for a task. Used in calculating client costs.
Ÿ EFFDATE – The date the prorating is effective for.
Ÿ TARGET – Reserved for future use.
Ÿ ARCHIVE – “T” if the task is to be archived, “F” otherwise.
Ÿ OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.
Ÿ HIDE – “T” if the task is hidden is task lists, “F” otherwise.